APPS.GMP_PLNG_DTL_REPORT_PKG dependencies on GMP_PDR_XML_TEMP

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

1401:
1402: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1403:
1404: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1405: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,1,x_seq_num );
1406: DBMS_LOB.FREETEMPORARY (result);
1407: ps_generate_output(x_seq_num,1);
1408:
1409: ELSE /* Not Combined PDR */

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

1479:
1480: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1481:
1482: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1483: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,2,x_seq_num );
1484: DBMS_LOB.FREETEMPORARY (result);
1485: ps_generate_output(x_seq_num,2);
1486:
1487: -- INSERT INTO ns_debug (col3) values (G_horiz_pdr_stmt);

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

1551:
1552: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1553:
1554: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1555: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,3,x_seq_num );
1556: DBMS_LOB.FREETEMPORARY (result);
1557: ps_generate_output(x_seq_num,3);
1558:
1559: -- INSERT INTO ns_debug (col3) values (G_vert_pdr_stmt);

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

1623:
1624: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1625:
1626: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1627: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,4,x_seq_num );
1628: -- INSERT INTO temp_r1(xml_file, file_type, pdr_xml_id) VALUES(result,4,x_seq_num );
1629: DBMS_LOB.FREETEMPORARY (result);
1630: ps_generate_output(x_seq_num,4);
1631:

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

1696:
1697: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1698:
1699: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1700: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,5,x_seq_num );
1701: DBMS_LOB.FREETEMPORARY (result);
1702: ps_generate_output(x_seq_num,5);
1703:
1704: -- INSERT INTO ns_debug (col3) values (G_act_pdr_stmt);

Line 1880: DELETE FROM gmp_pdr_xml_temp WHERE pdr_xml_id = p_sequence_num;

1876:
1877: gmp_debug_message(' Wait completed for conc request '||to_char(l_conc_id));
1878:
1879:
1880: DELETE FROM gmp_pdr_xml_temp WHERE pdr_xml_id = p_sequence_num;
1881: COMMIT;
1882:
1883:
1884: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'p_pdr_type = '||to_char(p_pdr_type));

Line 2007: FROM gmp_pdr_xml_temp

2003:
2004: file_varchar2 := NULL ;
2005:
2006: SELECT xml_file INTO l_file
2007: FROM gmp_pdr_xml_temp
2008: WHERE pdr_xml_id = p_sequence_num;
2009: l_limit:= 1;
2010: /* changed the Number from 10 to 15, becuase it is trimiing the First Standard Line */
2011: l_len := DBMS_LOB.GETLENGTH (l_file);