APPS.GMPMPACT dependencies on GMP_UNBUCKETED_XML_TEMP

Line 1841: INSERT INTO gmp_unbucketed_xml_temp(ubckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);

1837: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1838:
1839: qryctx := dbms_xmlgen.newcontext(x_stmt);
1840: result := DBMS_XMLGEN.getXML(qryCtx);
1841: INSERT INTO gmp_unbucketed_xml_temp(ubckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);
1842: DBMS_XMLGEN.closeContext(qryCtx);
1843: ps_generate_output(x_seq_num);
1844:
1845: EXCEPTION

Line 2179: DELETE FROM gmp_unbucketed_xml_temp WHERE ubckt_matl_xml_id = p_sequence_num;

2175: DEV_STATUS => l_dev_status,
2176: MESSAGE => l_message
2177: );
2178:
2179: DELETE FROM gmp_unbucketed_xml_temp WHERE ubckt_matl_xml_id = p_sequence_num;
2180:
2181: /* Bug: 6609251 Vpedarla added a NULL parameters for the submition of the FND request for XDOREPPB */
2182: l_req_id := FND_REQUEST.SUBMIT_REQUEST('XDO','XDOREPPB','', '',FALSE,'',
2183: l_conc_id,554,G_template,

Line 2224: FROM gmp_unbucketed_xml_temp

2220:
2221: BEGIN
2222:
2223: SELECT xml_file INTO l_file
2224: FROM gmp_unbucketed_xml_temp
2225: WHERE ubckt_matl_xml_id = p_sequence_num;
2226: l_limit:= 1;
2227:
2228: l_len := DBMS_LOB.GETLENGTH (l_file);