DBA Data[Home] [Help]

APPS.GMIGUTL dependencies on IC_ITEM_CPG

Line 185: | x_ic_item_cpg OUT RECORD - Record containing ic_item_cpg |

181: | |
182: | PARAMETERS |
183: | p_item_no IN ic_item_mst.item_no%TYPE - the key to select upon |
184: | x_ic_item_mst OUT RECORD - Record containing ic_item_mst |
185: | x_ic_item_cpg OUT RECORD - Record containing ic_item_cpg |
186: | |
187: | HISTORY |
188: +=========================================================================+
189: */

Line 193: , x_ic_item_cpg_row OUT NOCOPY ic_item_cpg%ROWTYPE

189: */
190: PROCEDURE Get_Item
191: ( p_item_no IN ic_item_mst.item_no%TYPE
192: , x_ic_item_mst_row OUT NOCOPY ic_item_mst%ROWTYPE
193: , x_ic_item_cpg_row OUT NOCOPY ic_item_cpg%ROWTYPE
194: )
195: IS
196: BEGIN
197:

Line 203: x_ic_item_cpg_row.item_id := x_ic_item_mst_row.item_id;

199:
200: IF GMIVDBL.ic_item_mst_select(x_ic_item_mst_row, x_ic_item_mst_row)
201: THEN
202: -- Jatinder - B3158806 Removed the CPG install check.
203: x_ic_item_cpg_row.item_id := x_ic_item_mst_row.item_id;
204: IF GMIVDBL.ic_item_cpg_select(x_ic_item_cpg_row, x_ic_item_cpg_row) THEN
205: RETURN;
206: END IF;
207: RETURN;

Line 204: IF GMIVDBL.ic_item_cpg_select(x_ic_item_cpg_row, x_ic_item_cpg_row) THEN

200: IF GMIVDBL.ic_item_mst_select(x_ic_item_mst_row, x_ic_item_mst_row)
201: THEN
202: -- Jatinder - B3158806 Removed the CPG install check.
203: x_ic_item_cpg_row.item_id := x_ic_item_mst_row.item_id;
204: IF GMIVDBL.ic_item_cpg_select(x_ic_item_cpg_row, x_ic_item_cpg_row) THEN
205: RETURN;
206: END IF;
207: RETURN;
208: END IF;