APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on DUAL

Line 858: FROM dual;

854:
855:
856: SELECT jmf_gta_trx_headers_all_s.NEXTVAL
857: INTO l_trx_header_rec.gta_trx_header_id
858: FROM dual;
859:
860: EXCEPTION
861: WHEN OTHERS THEN
862:

Line 948: FROM dual;

944: :=l_trx_header_rec.gta_trx_header_id;
945:
946: SELECT jmf_gta_trx_lines_all_s.NEXTVAL
947: INTO l_trx_line_rec.gta_trx_line_id
948: FROM dual;
949:
950: l_line_num:=l_line_num+1;
951: l_trx_line_rec.line_number :=l_line_num;
952: l_trx_line_rec.item_description :=l_values(2);

Line 968: FROM dual;

964: '1',l_values(9),
965: NULL)
966: INTO l_trx_line_rec.unit_price
967: , l_trx_line_rec.unit_tax_price
968: FROM dual;
969:
970: l_trx_line_rec.discount_flag:=l_values(1);
971: l_trx_line_rec.enabled_flag :='Y';
972: l_trx_line_rec.request_id := fnd_global.CONC_REQUEST_ID;

Line 1305: FROM dual;

1301: , l_succ_XML
1302: , l_failed_XML
1303: )
1304: INTO l_report_XML
1305: FROM dual;
1306:
1307: JMF_GTA_TRX_UTIL.output_conc(l_report_XML.Getclobval);
1308:
1309: clear_imp_temp_table;

Line 1786: FROM dual;

1782: END IF; --length(lv_trx_crmemo_notification_num) <> 16
1783: BEGIN
1784: SELECT to_number(lv_trx_crmemo_notification_num)
1785: INTO ln_notification_num
1786: FROM dual;
1787: EXCEPTION
1788: WHEN OTHERS THEN
1789: lb_num_flag := FALSE;
1790: END;