APPS.GMI_LOT_TRACE_PKG dependencies on GMI_LOT_TRACE

Line 1: PACKAGE BODY GMI_Lot_trace_pkg AS

1: PACKAGE BODY GMI_Lot_trace_pkg AS
2: /* $Header: GMILGENB.pls 115.6 2003/11/19 08:32:36 gmangari ship $ */
3: PROCEDURE exp_lot(pitem_id number,plot_id number, lvl number,comp_no IN OUT NOCOPY number,View_flag number,trace_id number) IS
4: lot_tab lot_tab_typ;
5: i number := 1;

Line 7: INSERT INTO GMI_LOT_TRACE (LOT_TRACE_ID

3: PROCEDURE exp_lot(pitem_id number,plot_id number, lvl number,comp_no IN OUT NOCOPY number,View_flag number,trace_id number) IS
4: lot_tab lot_tab_typ;
5: i number := 1;
6: BEGIN
7: INSERT INTO GMI_LOT_TRACE (LOT_TRACE_ID
8: ,ITEM_ID
9: ,LOT_ID
10: ,COMP_NO
11: ,LEVEL_NO

Line 21: GMI_Lot_trace_pkg.EXP_lot1(pitem_id,plot_id,2,comp_no,view_flag,trace_id,i,lot_tab);

17: 1,
18: null);
19: comp_no :=1;
20: lot_tab(i) := plot_id;
21: GMI_Lot_trace_pkg.EXP_lot1(pitem_id,plot_id,2,comp_no,view_flag,trace_id,i,lot_tab);
22: END;
23:
24: PROCEDURE exp_lot1(pitem_id number,
25: plot_id number,

Line 104: INSERT INTO GMI_LOT_TRACE (LOT_TRACE_ID

100: END IF;
101: j := j + 1;
102: END LOOP;
103: IF cir_flg <> CIR_REF THEN
104: INSERT INTO GMI_LOT_TRACE (LOT_TRACE_ID
105: ,ITEM_ID
106: ,LOT_ID
107: ,COMP_NO
108: ,LEVEL_NO

Line 116: GMI_Lot_trace_pkg.exp_lot1(v_item_id,v_lot_id,lvl+1,comp_no,view_flag,trace_id,i,lot_tab);

112: v_lot_id,
113: comp_no,
114: lvl,
115: null);
116: GMI_Lot_trace_pkg.exp_lot1(v_item_id,v_lot_id,lvl+1,comp_no,view_flag,trace_id,i,lot_tab);
117: ELSE
118: INSERT INTO GMI_LOT_TRACE (LOT_TRACE_ID
119: ,ITEM_ID
120: ,LOT_ID

Line 118: INSERT INTO GMI_LOT_TRACE (LOT_TRACE_ID

114: lvl,
115: null);
116: GMI_Lot_trace_pkg.exp_lot1(v_item_id,v_lot_id,lvl+1,comp_no,view_flag,trace_id,i,lot_tab);
117: ELSE
118: INSERT INTO GMI_LOT_TRACE (LOT_TRACE_ID
119: ,ITEM_ID
120: ,LOT_ID
121: ,COMP_NO
122: ,LEVEL_NO

Line 132: INSERT INTO GMI_LOT_TRACE (LOT_TRACE_ID

128: lvl,
129: '*');
130: END IF;
131: ELSE
132: INSERT INTO GMI_LOT_TRACE (LOT_TRACE_ID
133: ,ITEM_ID
134: ,LOT_ID
135: ,COMP_NO
136: ,LEVEL_NO