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 686: ' FROM DUAL ';

682: ' FROM ps_matl_hdr pmh ' ||
683: ' WHERE pmh.matl_rep_id = ' ||G_matl_rep_id||
684: ' ORDER BY pmh.inventory_item_id, pmh.organization_id ' ||
685: ' ) HEADER ' ||
686: ' FROM DUAL ';
687:
688: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
689:
690: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;

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

684: ' ORDER BY pmh.inventory_item_id, pmh.organization_id ' ||
685: ' ) HEADER ' ||
686: ' FROM DUAL ';
687:
688: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
689:
690: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
691:
692: --DELETE FROM GMP_BUCKETED_XML_GTMP;