APPS.GMPMPACT dependencies on GMP_MATL_REP_ID_S

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

408: dbms_sql.define_column (cur_item, 3, X_category_id);
409:
410: X_row_count := dbms_sql.execute_and_fetch (cur_item);
411: IF X_row_count > 0 THEN
412: SELECT gmp_matl_rep_id_s.NEXTVAL INTO X_rep_id FROM dual;
413: G_matl_rep_id := X_rep_id;
414: X_i := 0;
415: LOOP
416: dbms_sql.column_value (cur_item, 1, X_item_id);

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

1897: DBMS_XMLGEN.closeContext(qryctx);
1898: DBMS_LOB.FREETEMPORARY (temp_clob);
1899: -- B7481907 Rajesh Patangya Ends
1900:
1901: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1902: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1903:
1904: INSERT INTO gmp_unbucketed_xml_temp(ubckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);
1905: ps_generate_output(x_seq_num);