DBA Data[Home] [Help]

APPS.GMDQC0_WF_P dependencies on IC_TRAN_PND

Line 5: -- called via trigger on IC_TRAN_CMP,IC_TRAN_PND

1: PACKAGE BODY gmdqc0_wf_p AS
2: /* $Header: GMDQC0B.pls 115.4 2002/04/18 14:58:20 pkm ship $ */
3: PROCEDURE init_wf (
4: -- procedure to initialize and run Workflow
5: -- called via trigger on IC_TRAN_CMP,IC_TRAN_PND
6:
7: p_trans_id IN VARCHAR2,
8: p_orgn_code IN ic_tran_pnd.orgn_code%TYPE ,
9: p_whse_code IN ic_tran_pnd.whse_code%TYPE ,

Line 8: p_orgn_code IN ic_tran_pnd.orgn_code%TYPE ,

4: -- procedure to initialize and run Workflow
5: -- called via trigger on IC_TRAN_CMP,IC_TRAN_PND
6:
7: p_trans_id IN VARCHAR2,
8: p_orgn_code IN ic_tran_pnd.orgn_code%TYPE ,
9: p_whse_code IN ic_tran_pnd.whse_code%TYPE ,
10: p_item_id IN ic_tran_pnd.item_id%TYPE ,
11: p_doc_type IN ic_tran_pnd.doc_type%TYPE ,
12: p_doc_id IN ic_tran_pnd.doc_id%TYPE,

Line 9: p_whse_code IN ic_tran_pnd.whse_code%TYPE ,

5: -- called via trigger on IC_TRAN_CMP,IC_TRAN_PND
6:
7: p_trans_id IN VARCHAR2,
8: p_orgn_code IN ic_tran_pnd.orgn_code%TYPE ,
9: p_whse_code IN ic_tran_pnd.whse_code%TYPE ,
10: p_item_id IN ic_tran_pnd.item_id%TYPE ,
11: p_doc_type IN ic_tran_pnd.doc_type%TYPE ,
12: p_doc_id IN ic_tran_pnd.doc_id%TYPE,
13: p_lot_id IN ic_tran_pnd.lot_id%TYPE,

Line 10: p_item_id IN ic_tran_pnd.item_id%TYPE ,

6:
7: p_trans_id IN VARCHAR2,
8: p_orgn_code IN ic_tran_pnd.orgn_code%TYPE ,
9: p_whse_code IN ic_tran_pnd.whse_code%TYPE ,
10: p_item_id IN ic_tran_pnd.item_id%TYPE ,
11: p_doc_type IN ic_tran_pnd.doc_type%TYPE ,
12: p_doc_id IN ic_tran_pnd.doc_id%TYPE,
13: p_lot_id IN ic_tran_pnd.lot_id%TYPE,
14: p_trans_qty IN NUMBER

Line 11: p_doc_type IN ic_tran_pnd.doc_type%TYPE ,

7: p_trans_id IN VARCHAR2,
8: p_orgn_code IN ic_tran_pnd.orgn_code%TYPE ,
9: p_whse_code IN ic_tran_pnd.whse_code%TYPE ,
10: p_item_id IN ic_tran_pnd.item_id%TYPE ,
11: p_doc_type IN ic_tran_pnd.doc_type%TYPE ,
12: p_doc_id IN ic_tran_pnd.doc_id%TYPE,
13: p_lot_id IN ic_tran_pnd.lot_id%TYPE,
14: p_trans_qty IN NUMBER
15:

Line 12: p_doc_id IN ic_tran_pnd.doc_id%TYPE,

8: p_orgn_code IN ic_tran_pnd.orgn_code%TYPE ,
9: p_whse_code IN ic_tran_pnd.whse_code%TYPE ,
10: p_item_id IN ic_tran_pnd.item_id%TYPE ,
11: p_doc_type IN ic_tran_pnd.doc_type%TYPE ,
12: p_doc_id IN ic_tran_pnd.doc_id%TYPE,
13: p_lot_id IN ic_tran_pnd.lot_id%TYPE,
14: p_trans_qty IN NUMBER
15:
16: )

Line 13: p_lot_id IN ic_tran_pnd.lot_id%TYPE,

9: p_whse_code IN ic_tran_pnd.whse_code%TYPE ,
10: p_item_id IN ic_tran_pnd.item_id%TYPE ,
11: p_doc_type IN ic_tran_pnd.doc_type%TYPE ,
12: p_doc_id IN ic_tran_pnd.doc_id%TYPE,
13: p_lot_id IN ic_tran_pnd.lot_id%TYPE,
14: p_trans_qty IN NUMBER
15:
16: )
17:

Line 139: l_doc_id ic_tran_pnd.doc_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'DOC_ID');

135: l_process_name VARCHAR2(80):='GMDQC0_PROCESS';
136: l_activity_name VARCHAR2(100):='SELECT_ROLE';
137: /* Begin Bug#2250274 Praveen Reddy */
138: /* Added variables l_doc_id and l_doc_no*/
139: l_doc_id ic_tran_pnd.doc_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'DOC_ID');
140: l_doc_no VARCHAR2(40);
141: /* End Bug#2250274*/
142: BEGIN
143: IF (p_funcmode = 'RUN') THEN