APPS.GMIGUTL dependencies on IC_ITEM_MST

Line 180: | This procedure is used to retrieve all details from ic_item_mst |

176: | USAGE |
177: | Used to retrieve item master details |
178: | |
179: | DESCRIPTION |
180: | This procedure is used to retrieve all details from ic_item_mst |
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 |

Line 183: | p_item_no IN ic_item_mst.item_no%TYPE - the key to select upon |

179: | DESCRIPTION |
180: | This procedure is used to retrieve all details from ic_item_mst |
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 |

Line 184: | x_ic_item_mst OUT RECORD - Record containing ic_item_mst |

180: | This procedure is used to retrieve all details from ic_item_mst |
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: +=========================================================================+

Line 191: ( p_item_no IN ic_item_mst.item_no%TYPE

187: | HISTORY |
188: +=========================================================================+
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

Line 192: , x_ic_item_mst_row OUT NOCOPY ic_item_mst%ROWTYPE

188: +=========================================================================+
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

Line 198: x_ic_item_mst_row.item_no := p_item_no;

194: )
195: IS
196: BEGIN
197:
198: x_ic_item_mst_row.item_no := p_item_no;
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.

Line 200: IF GMIVDBL.ic_item_mst_select(x_ic_item_mst_row, x_ic_item_mst_row)

196: BEGIN
197:
198: x_ic_item_mst_row.item_no := p_item_no;
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

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 214: x_ic_item_mst_row.item_no := NULL;

210: RAISE FND_API.G_EXC_ERROR;
211:
212: EXCEPTION
213: WHEN OTHERS THEN
214: x_ic_item_mst_row.item_no := NULL;
215:
216: END Get_Item;
217:
218: /* +=========================================================================+