APPS.GMPPSRP dependencies on GMP_BUCKETED_XML_TEMP

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

732: -- B7481907 Rajesh Patangya Ends
733:
734: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
735: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
736: INSERT INTO gmp_bucketed_xml_temp(bckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);
737: ps_generate_output(x_seq_num);
738:
739: EXCEPTION
740: WHEN OTHERS THEN

Line 1073: DELETE FROM gmp_bucketed_xml_temp WHERE bckt_matl_xml_id = p_sequence_num;

1069: DEV_STATUS => l_dev_status,
1070: MESSAGE => l_message
1071: );
1072:
1073: DELETE FROM gmp_bucketed_xml_temp WHERE bckt_matl_xml_id = p_sequence_num;
1074:
1075: /* Bug: 6609251 Vpedarla added a NULL parameters for the submition of the FND request for XDOREPPB */
1076: l_req_id := FND_REQUEST.SUBMIT_REQUEST('XDO','XDOREPPB','', '',FALSE,'',
1077: l_conc_id,554,G_template,

Line 1120: FROM gmp_bucketed_xml_temp

1116:
1117: BEGIN
1118:
1119: SELECT xml_file INTO l_file
1120: FROM gmp_bucketed_xml_temp
1121: WHERE bckt_matl_xml_id = p_sequence_num;
1122: l_limit:= 1;
1123:
1124: l_len := DBMS_LOB.GETLENGTH (l_file);