APPS.GMPMPACT dependencies on GMP_MATL_REP_ID_S

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

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

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

1831: ' ) HEADER ' ||
1832: ' FROM DUAL ';
1833:
1834: --DELETE FROM GMP_UNBUCKETED_XML_GTMP;
1835: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1836:
1837: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1838:
1839: qryctx := dbms_xmlgen.newcontext(x_stmt);