APPS.GMP_DESPATCH_LOAD_RPT_PKG dependencies on GMP_RESDISP_XML_TEMP

Line 351: INSERT INTO GMP_RESDISP_XML_TEMP (RESDISP_XML_RPT_ID,RESULT) VALUES (resdisp_rpt_id, result1);

347: -- B7481907 Rajesh Patangya Ends
348:
349: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
350: EXECUTE IMMEDIATE seq_stmt INTO resdisp_rpt_id ;
351: INSERT INTO GMP_RESDISP_XML_TEMP (RESDISP_XML_RPT_ID,RESULT) VALUES (resdisp_rpt_id, result1);
352: DBMS_XMLGEN.closeContext(qryCtx);
353:
354: COMMIT;
355:

Line 562: INSERT INTO GMP_RESDISP_XML_TEMP (RESDISP_XML_RPT_ID,RESULT) VALUES (resdisp_rpt_id, result1);

558: -- B7481907 Rajesh Patangya Ends
559:
560: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
561: EXECUTE IMMEDIATE seq_stmt INTO resdisp_rpt_id ;
562: INSERT INTO GMP_RESDISP_XML_TEMP (RESDISP_XML_RPT_ID,RESULT) VALUES (resdisp_rpt_id, result1);
563: DBMS_XMLGEN.closeContext(qryCtx);
564:
565: COMMIT;
566:

Line 825: DELETE FROM GMP_RESDISP_XML_TEMP WHERE RESDISP_XML_RPT_ID = p_sequence_num;

821: DEV_STATUS => l_dev_status,
822: MESSAGE => l_message
823: );
824:
825: DELETE FROM GMP_RESDISP_XML_TEMP WHERE RESDISP_XML_RPT_ID = p_sequence_num;
826:
827: /* Bug: 6609251 Vpedarla added a NULL parameters for the submition of the FND request for XDOREPPB */
828:
829: l_req_id := FND_REQUEST.SUBMIT_REQUEST('XDO','XDOREPPB','', '',FALSE,'',

Line 884: FROM GMP_RESDISP_XML_TEMP

880:
881: BEGIN
882:
883: SELECT RESULT INTO l_file
884: FROM GMP_RESDISP_XML_TEMP
885: WHERE RESDISP_XML_RPT_ID = p_sequence_num;
886:
887: l_limit:= 1;
888: l_len := DBMS_LOB.GETLENGTH (l_file);