12: | reservation. |
13: | |
14: | -- Init_wf() |
15: | -- Check_event() |
16: | -- Insert_gml_batch_so_workflow() |
17: | |
18: | HISTORY |
19: | 10-Oct-2003 nchekuri Created |
20: | |
282: , itemkey => l_itemkey );
283:
284: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf After Start Process');
285:
286: /* Insert the workflow/batch/so information into Gml_batch_so_workflow table for
287: future reference. */
288:
289: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Before Insert Record');
290:
287: future reference. */
288:
289: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Before Insert Record');
290:
291: INSERT_GML_BATCH_SO_WORKFLOW(
292: l_itemtype
293: , l_itemkey
294: , p_so_header_id
295: , p_so_line_id
337:
338: END check_event;
339:
340:
341: PROCEDURE INSERT_GML_BATCH_SO_WORKFLOW(
342: p_itemtype IN VARCHAR2
343: , p_itemkey IN VARCHAR2
344: , p_so_header_id IN NUMBER
345: , p_so_line_id IN NUMBER
350: l_wf_item_id NUMBER;
351:
352: BEGIN
353:
354: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW..... ');
355:
356: SELECT GML_BATCH_SO_WORKFLOW_S.nextval
357: INTO l_wf_item_id FROM DUAL;
358:
352: BEGIN
353:
354: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW..... ');
355:
356: SELECT GML_BATCH_SO_WORKFLOW_S.nextval
357: INTO l_wf_item_id FROM DUAL;
358:
359: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW Before Insert ');
360:
355:
356: SELECT GML_BATCH_SO_WORKFLOW_S.nextval
357: INTO l_wf_item_id FROM DUAL;
358:
359: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW Before Insert ');
360:
361: INSERT INTO Gml_batch_so_workflow (
362: WF_ITEM_ID
363: , WF_ITEM_TYPE
357: INTO l_wf_item_id FROM DUAL;
358:
359: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW Before Insert ');
360:
361: INSERT INTO Gml_batch_so_workflow (
362: WF_ITEM_ID
363: , WF_ITEM_TYPE
364: , WF_ITEM_KEY
365: , SO_HEADER_ID
384: , fnd_global.user_id
385: , sysdate
386: , fnd_global.user_id);
387:
388: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW After Insert ');
389:
390: EXCEPTION
391:
392: WHEN OTHERS THEN
389:
390: EXCEPTION
391:
392: WHEN OTHERS THEN
393: GMI_RESERVATION_UTIL.PrintLn('WARNING! GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW OTHERS Exception ');
394: NULL;
395:
396: END INSERT_GML_BATCH_SO_WORKFLOW;
397:
392: WHEN OTHERS THEN
393: GMI_RESERVATION_UTIL.PrintLn('WARNING! GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW OTHERS Exception ');
394: NULL;
395:
396: END INSERT_GML_BATCH_SO_WORKFLOW;
397:
398:
399: END GML_BATCH_WORKFLOW_PKG;