APPS.GMI_GLOBAL_GRP dependencies on IC_LOTS_CPG

Line 30: --| IC_LOTS_CPG |

26: --| |
27: --| HISTORY |
28: --| 01-OCT-1998 M.Godfrey Created |
29: --| 16-AUG-1999 Liz Enstone B965832(3) Remove query on |
30: --| IC_LOTS_CPG |
31: --| 25-OCT-2002 Joe DiIorio Bug#2643330 - added nocopy. |
32: --+==========================================================================+
33: -- Body end of comments
34:

Line 124: --| x_ic_lots_cpg OUT RECORD - Record containing ic_lots_cpg |

120: --| p_item_id IN NUMBER - Item ID of lot to be retrieved |
121: --| p_lot_no IN VARCHAR2(32) - Lot number of lot to be retrieved |
122: --| p_sublot_no IN VARCHAR2(32) - Sublot number to be retrieved |
123: --| x_ic_lots_mst OUT RECORD - Record containing ic_lots_mst |
124: --| x_ic_lots_cpg OUT RECORD - Record containing ic_lots_cpg |
125: --| |
126: --| HISTORY |
127: --| 01-OCT-1998 M.Godfrey Created |
128: --+=========================================================================+

Line 134: , x_ic_lots_cpg OUT NOCOPY ic_lots_cpg%ROWTYPE

130: ( p_item_id IN ic_lots_mst.item_id%TYPE
131: , p_lot_no IN ic_lots_mst.lot_no%TYPE
132: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
133: , x_ic_lots_mst OUT NOCOPY ic_lots_mst%ROWTYPE
134: , x_ic_lots_cpg OUT NOCOPY ic_lots_cpg%ROWTYPE
135: )
136: IS
137: CURSOR ic_lots_mst_c1 IS
138: SELECT

Line 148: CURSOR ic_lots_cpg_c1(v_lot_id ic_lots_mst.lot_id%TYPE) IS

144: AND ( sublot_no = p_sublot_no OR
145: sublot_no is NULL)
146: AND item_id = p_item_id;
147:
148: CURSOR ic_lots_cpg_c1(v_lot_id ic_lots_mst.lot_id%TYPE) IS
149: SELECT
150: *
151: FROM
152: ic_lots_cpg

Line 152: ic_lots_cpg

148: CURSOR ic_lots_cpg_c1(v_lot_id ic_lots_mst.lot_id%TYPE) IS
149: SELECT
150: *
151: FROM
152: ic_lots_cpg
153: WHERE
154: lot_id = v_lot_id;
155:
156: l_ic_lots_mst ic_lots_mst%ROWTYPE;

Line 170: --OPEN ic_lots_cpg_c1(l_ic_lots_mst.lot_id);

166: x_ic_lots_mst.lot_id := -1;
167: ELSE
168: x_ic_lots_mst := l_ic_lots_mst;
169: --B965832(3) Get rid of this select
170: --OPEN ic_lots_cpg_c1(l_ic_lots_mst.lot_id);
171: --FETCH ic_lots_cpg_c1 INTO x_ic_lots_cpg;
172: --IF (ic_lots_cpg_c1%NOTFOUND)
173: --THEN
174: -- x_ic_lots_mst.lot_id := -1;

Line 171: --FETCH ic_lots_cpg_c1 INTO x_ic_lots_cpg;

167: ELSE
168: x_ic_lots_mst := l_ic_lots_mst;
169: --B965832(3) Get rid of this select
170: --OPEN ic_lots_cpg_c1(l_ic_lots_mst.lot_id);
171: --FETCH ic_lots_cpg_c1 INTO x_ic_lots_cpg;
172: --IF (ic_lots_cpg_c1%NOTFOUND)
173: --THEN
174: -- x_ic_lots_mst.lot_id := -1;
175: -- END IF;

Line 172: --IF (ic_lots_cpg_c1%NOTFOUND)

168: x_ic_lots_mst := l_ic_lots_mst;
169: --B965832(3) Get rid of this select
170: --OPEN ic_lots_cpg_c1(l_ic_lots_mst.lot_id);
171: --FETCH ic_lots_cpg_c1 INTO x_ic_lots_cpg;
172: --IF (ic_lots_cpg_c1%NOTFOUND)
173: --THEN
174: -- x_ic_lots_mst.lot_id := -1;
175: -- END IF;
176: -- CLOSE ic_lots_cpg_c1;

Line 176: -- CLOSE ic_lots_cpg_c1;

172: --IF (ic_lots_cpg_c1%NOTFOUND)
173: --THEN
174: -- x_ic_lots_mst.lot_id := -1;
175: -- END IF;
176: -- CLOSE ic_lots_cpg_c1;
177: --B965832(3) End
178: END IF;
179:
180: CLOSE ic_lots_mst_c1;