APPS.GMPPSRP dependencies on DUAL

Line 352: SELECT gmp_matl_rep_id_s.NEXTVAL INTO X_rep_id FROM dual;

348: dbms_sql.define_column (cur_item, 3, X_category_id);
349:
350: X_row_count := dbms_sql.execute_and_fetch (cur_item);
351: IF X_row_count > 0 THEN
352: SELECT gmp_matl_rep_id_s.NEXTVAL INTO X_rep_id FROM dual;
353: G_matl_rep_id := X_rep_id;
354: X_i := 0;
355: LOOP
356: dbms_sql.column_value (cur_item, 1, X_item_id);

Line 700: ' FROM DUAL ';

696: ' FROM ps_matl_hdr pmh ' ||
697: ' WHERE pmh.matl_rep_id = ' ||G_matl_rep_id||
698: ' ORDER BY pmh.inventory_item_id, pmh.organization_id ' ||
699: ' ) HEADER ' ||
700: ' FROM DUAL ';
701:
702: -- DELETE FROM GMP_BUCKETED_XML_GTMP;
703: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, x_stmt);
704:

Line 734: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';

730: DBMS_XMLGEN.closeContext(qryctx);
731: DBMS_LOB.FREETEMPORARY (temp_clob);
732: -- B7481907 Rajesh Patangya Ends
733:
734: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
735: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
736: INSERT INTO gmp_bucketed_xml_temp(bckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);
737: ps_generate_output(x_seq_num);
738: