APPS.GMP_PLNG_DTL_REPORT_PKG dependencies on GMP_PDR_XML_TEMP

Line 1173: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,1,x_seq_num );

1169: result := DBMS_XMLGEN.getXML(qryCtx);
1170: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1171:
1172: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1173: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,1,x_seq_num );
1174: DBMS_XMLGEN.closeContext(qryCtx);
1175: ps_generate_output(x_seq_num,1);
1176:
1177: ELSE /* Not Combined PDR */

Line 1216: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,2,x_seq_num );

1212: result := DBMS_XMLGEN.getXML(qryCtx);
1213: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1214:
1215: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1216: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,2,x_seq_num );
1217: DBMS_XMLGEN.closeContext(qryCtx);
1218: ps_generate_output(x_seq_num,2);
1219:
1220: -- INSERT INTO ns_debug (col3) values (G_horiz_pdr_stmt);

Line 1261: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,3,x_seq_num );

1257: result := DBMS_XMLGEN.getXML(qryCtx);
1258: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1259:
1260: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1261: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,3,x_seq_num );
1262: DBMS_XMLGEN.closeContext(qryCtx);
1263: ps_generate_output(x_seq_num,3);
1264:
1265: -- INSERT INTO ns_debug (col3) values (G_vert_pdr_stmt);

Line 1306: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,4,x_seq_num );

1302: result := DBMS_XMLGEN.getXML(qryCtx);
1303: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1304:
1305: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1306: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,4,x_seq_num );
1307: DBMS_XMLGEN.closeContext(qryCtx);
1308: ps_generate_output(x_seq_num,4);
1309:
1310: -- INSERT INTO ns_debug (col3) values (G_excep_pdr_stmt);

Line 1351: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,5,x_seq_num );

1347: result := DBMS_XMLGEN.getXML(qryCtx);
1348: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1349:
1350: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1351: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,5,x_seq_num );
1352: DBMS_XMLGEN.closeContext(qryCtx);
1353: ps_generate_output(x_seq_num,5);
1354:
1355: -- INSERT INTO ns_debug (col3) values (G_act_pdr_stmt);

Line 1513: DELETE FROM gmp_pdr_xml_temp WHERE pdr_xml_id = p_sequence_num;

1509: );
1510:
1511: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Wait completed for conc request '||to_char(l_conc_id));
1512:
1513: DELETE FROM gmp_pdr_xml_temp WHERE pdr_xml_id = p_sequence_num;
1514: COMMIT;
1515:
1516: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'p_pdr_type = '||to_char(p_pdr_type));
1517:

Line 1635: FROM gmp_pdr_xml_temp

1631:
1632: BEGIN
1633:
1634: SELECT xml_file INTO l_file
1635: FROM gmp_pdr_xml_temp
1636: WHERE pdr_xml_id = p_sequence_num;
1637: l_limit:= 1;
1638:
1639: l_len := DBMS_LOB.GETLENGTH (l_file);