APPS.GMPPSRP dependencies on GMP_BUCKETED_XML_TEMP

Line 695: INSERT INTO gmp_bucketed_xml_temp(bckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);

691:
692: --DELETE FROM GMP_BUCKETED_XML_GTMP;
693: qryctx := dbms_xmlgen.newcontext(x_stmt);
694: result := DBMS_XMLGEN.getXML(qryCtx);
695: INSERT INTO gmp_bucketed_xml_temp(bckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);
696: DBMS_XMLGEN.closeContext(qryCtx);
697: ps_generate_output(x_seq_num);
698:
699: EXCEPTION

Line 1033: DELETE FROM gmp_bucketed_xml_temp WHERE bckt_matl_xml_id = p_sequence_num;

1029: DEV_STATUS => l_dev_status,
1030: MESSAGE => l_message
1031: );
1032:
1033: DELETE FROM gmp_bucketed_xml_temp WHERE bckt_matl_xml_id = p_sequence_num;
1034:
1035: /* Bug: 6609251 Vpedarla added a NULL parameters for the submition of the FND request for XDOREPPB */
1036: l_req_id := FND_REQUEST.SUBMIT_REQUEST('XDO','XDOREPPB','', '',FALSE,'',
1037: l_conc_id,554,G_template,

Line 1079: FROM gmp_bucketed_xml_temp

1075:
1076: BEGIN
1077:
1078: SELECT xml_file INTO l_file
1079: FROM gmp_bucketed_xml_temp
1080: WHERE bckt_matl_xml_id = p_sequence_num;
1081: l_limit:= 1;
1082:
1083: l_len := DBMS_LOB.GETLENGTH (l_file);