APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on DUAL

Line 785: SELECT decode(l_values(1),'0','COMPLETED','CANCELLED') INTO l_new_status FROM dual;

781: END IF;*/
782:
783: --Change by Sabrina for ER#14830536 Start
784: --l_new_status:='COMPLETED';
785: SELECT decode(l_values(1),'0','COMPLETED','CANCELLED') INTO l_new_status FROM dual;
786: l_values_VAT_Header:=l_values;
787: --Corresponding GTA for this VAT hasn't been imported yet
788: IF NOT l_vat_tbl.EXISTS(l_gta_invoice_num)
789: THEN

Line 967: FROM dual;

963:
964:
965: SELECT ar_gta_trx_headers_all_s.NEXTVAL
966: INTO l_trx_header_rec.gta_trx_header_id
967: FROM dual;
968:
969: EXCEPTION
970: WHEN OTHERS THEN
971:

Line 1057: FROM dual;

1053: :=l_trx_header_rec.gta_trx_header_id;
1054:
1055: SELECT ar_gta_trx_lines_all_s.NEXTVAL
1056: INTO l_trx_line_rec.gta_trx_line_id
1057: FROM dual;
1058:
1059: l_line_num:=l_line_num+1;
1060: l_trx_line_rec.line_number :=l_line_num;
1061: l_trx_line_rec.item_description :=l_values(2);

Line 1077: FROM dual;

1073: '1',l_values(9),
1074: NULL)
1075: INTO l_trx_line_rec.unit_price
1076: , l_trx_line_rec.unit_tax_price
1077: FROM dual;
1078:
1079: l_trx_line_rec.discount_flag:=l_values(1);
1080: l_trx_line_rec.enabled_flag :='Y';
1081: l_trx_line_rec.request_id := fnd_global.CONC_REQUEST_ID;

Line 1467: FROM dual;

1463: , l_succ_XML
1464: , l_failed_XML
1465: )
1466: INTO l_report_XML
1467: FROM dual;
1468:
1469: AR_GTA_TRX_UTIL.output_conc(l_report_XML.Getclobval);
1470:
1471: clear_imp_temp_table;

Line 1987: FROM dual;

1983: END IF; --length(lv_trx_crmemo_notification_num) <> 16
1984: BEGIN
1985: SELECT to_number(lv_trx_crmemo_notification_num)
1986: INTO ln_notification_num
1987: FROM dual;
1988: EXCEPTION
1989: WHEN OTHERS THEN
1990: lb_num_flag := FALSE;
1991: END;