DBA Data[Home] [Help]

APPS.GML_BATCH_WORKFLOW_PKG dependencies on GML_BATCH_SO_WORKFLOW

Line 16: | -- Insert_gml_batch_so_workflow() |

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: | |

Line 286: /* Insert the workflow/batch/so information into Gml_batch_so_workflow table for

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:

Line 291: INSERT_GML_BATCH_SO_WORKFLOW(

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

Line 341: PROCEDURE INSERT_GML_BATCH_SO_WORKFLOW(

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

Line 354: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW..... ');

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:

Line 356: SELECT GML_BATCH_SO_WORKFLOW_S.nextval

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:

Line 359: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW Before Insert ');

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

Line 361: INSERT INTO Gml_batch_so_workflow (

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

Line 388: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW After Insert ');

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

Line 393: GMI_RESERVATION_UTIL.PrintLn('WARNING! GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW OTHERS Exception ');

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:

Line 396: END INSERT_GML_BATCH_SO_WORKFLOW;

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;