APPS.GMPPSRP dependencies on GMP_MATL_REP_ID_S

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 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: