Replies posted by safarnia.hamid

2 Replies

proharikg
Sidekick (Partner)
proharikgSidekick (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to delete a custom field?

and don’t forgot cleanup after delete custom field. 

5
safarnia.hamid
Do Gooder
2 years ago
GPIE
Hero (Customer)
GPIEHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Automate Purchase Order PDF Email

This code can be run to both generate the PDF parameters and send the PDF in one hit, to either negate the need to create the PDF parameters or to override the existing PDF parameters. Note the expansion of the ATTR_ data. Now it would be nice to be able to change the email subject and body. DECLARE LAYOUT_NAME_ VARCHAR(2000):='PurchaseOrderPrintRep.rdl'; REPORT_ID_ VARCHAR2(2000):= 'PURCHASE_ORDER_PRINT_REP'; REPORT_ATTR_ VARCHAR2(2000):= ''; PARAMETER_ATTR_ VARCHAR2(2000):= ''; DISTRIBUTION_LIST_ VARCHAR2(2000):= ''; INSTANCE_ATTR_ VARCHAR2(2000):= ''; PRINT_JOB_ID_ VARCHAR2(2000):= ''; PRINT_ATTR_ VARCHAR2(2000):= ''; PRINTER_ID_ VARCHAR2(2000):= 'PDF_PRINTER'; PUR_ORDER_PRINT_OPTION_ VARCHAR(2000) := 'Order'; --PUR_ORDER_PRINT_OPTION_ VARCHAR(2000) := 'Order Work Copy'; ORDER_NO_ VARCHAR2(2000):= ORDER_NO; RESULT_KEY_ VARCHAR2(2000):= ''; ATTR_ VARCHAR2(2000):= '';BEGIN REPORT_ATTR_:= 'REPORT_ID'||CHR(31)||'PURCHASE_ORDER_PRINT_REP'||CHR(30)||'LAYOUT_NAME'||CHR(31)||'PurchaseOrde

17
D
Sidekick (Customer)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings