APPS.GMP_DESPATCH_LOAD_RPT_PKG dependencies on GMP_RESDISP_XML_TEMP

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

267:
268: qryctx := dbms_xmlgen.newcontext(x_stmt);
269: result1 := DBMS_XMLGEN.getXML(qryCtx);
270:
271: INSERT INTO GMP_RESDISP_XML_TEMP (RESDISP_XML_RPT_ID,RESULT) VALUES (resdisp_rpt_id, result1);
272: DBMS_XMLGEN.closeContext(qryCtx);
273:
274: COMMIT;
275:

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

436:
437: qryctx := dbms_xmlgen.newcontext(x_stmt1);
438: result1 := DBMS_XMLGEN.getXML(qryCtx);
439:
440: INSERT INTO GMP_RESDISP_XML_TEMP (RESDISP_XML_RPT_ID,RESULT) VALUES (resdisp_rpt_id, result1);
441: DBMS_XMLGEN.closeContext(qryCtx);
442:
443:
444: COMMIT;

Line 657: DELETE FROM GMP_RESDISP_XML_TEMP WHERE RESDISP_XML_RPT_ID = p_sequence_num;

653: DEV_STATUS => l_dev_status,
654: MESSAGE => l_message
655: );
656:
657: DELETE FROM GMP_RESDISP_XML_TEMP WHERE RESDISP_XML_RPT_ID = p_sequence_num;
658:
659: /* Bug: 6609251 Vpedarla added a NULL parameters for the submition of the FND request for XDOREPPB */
660: l_req_id := FND_REQUEST.SUBMIT_REQUEST('XDO','XDOREPPB','', '',FALSE,'',
661: l_conc_id,554,G_template,

Line 701: FROM GMP_RESDISP_XML_TEMP

697:
698: BEGIN
699:
700: SELECT RESULT INTO l_file
701: FROM GMP_RESDISP_XML_TEMP
702: WHERE RESDISP_XML_RPT_ID = p_sequence_num;
703:
704: l_limit:= 1;
705: