APPS.GMPMPACT dependencies on GMP_UNBUCKETED_XML_TEMP

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

1900:
1901: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1902: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1903:
1904: INSERT INTO gmp_unbucketed_xml_temp(ubckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);
1905: ps_generate_output(x_seq_num);
1906:
1907: EXCEPTION
1908: WHEN OTHERS THEN

Line 2241: DELETE FROM gmp_unbucketed_xml_temp WHERE ubckt_matl_xml_id = p_sequence_num;

2237: DEV_STATUS => l_dev_status,
2238: MESSAGE => l_message
2239: );
2240:
2241: DELETE FROM gmp_unbucketed_xml_temp WHERE ubckt_matl_xml_id = p_sequence_num;
2242:
2243: /* Bug: 6609251 Vpedarla added a NULL parameters for the submition of the FND request for XDOREPPB */
2244: l_req_id := FND_REQUEST.SUBMIT_REQUEST('XDO','XDOREPPB','', '',FALSE,'',
2245: l_conc_id,554,G_template,

Line 2287: FROM gmp_unbucketed_xml_temp

2283:
2284: BEGIN
2285:
2286: SELECT xml_file INTO l_file
2287: FROM gmp_unbucketed_xml_temp
2288: WHERE ubckt_matl_xml_id = p_sequence_num;
2289: l_limit:= 1;
2290:
2291: l_len := DBMS_LOB.GETLENGTH (l_file);