eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMIGAPI dependencies on IC_LOTS_CPG

Line 60: l_ic_lots_cpg_row ic_lots_cpg%ROWTYPE;

56: l_api_name VARCHAR2(30) := 'G_Create_Item';
57: l_lot_rec GMIGAPI.lot_rec_typ;
58: l_return_status NUMBER;
59: l_ic_lots_mst_row ic_lots_mst%ROWTYPE;
60: l_ic_lots_cpg_row ic_lots_cpg%ROWTYPE;
61: BEGIN
62:
63: /* Standard call to check for call compatibility. */
64:

Line 132: , x_ic_lots_cpg_row => l_ic_lots_cpg_row

128: , p_lot_rec => l_lot_rec
129: , p_ic_item_mst_row => x_ic_item_mst_row
130: , p_ic_item_cpg_row => x_ic_item_cpg_row
131: , x_ic_lots_mst_row => l_ic_lots_mst_row
132: , x_ic_lots_cpg_row => l_ic_lots_cpg_row
133: , x_return_status => x_return_status
134: , x_msg_count => x_msg_count
135: , x_msg_data => x_msg_data
136: );

Line 219: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE

215: , p_lot_rec IN lot_rec_typ
216: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
217: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
218: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
219: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
220: , x_return_status OUT NOCOPY VARCHAR2
221: , x_msg_count OUT NOCOPY NUMBER
222: , x_msg_data OUT NOCOPY VARCHAR2
223: )

Line 251: , x_ic_lots_cpg_row => x_ic_lots_cpg_row

247: , p_lot_rec => p_lot_rec
248: , p_ic_item_mst_row => p_ic_item_mst_row
249: , p_ic_item_cpg_row => p_ic_item_cpg_row
250: , x_ic_lots_mst_row => x_ic_lots_mst_row
251: , x_ic_lots_cpg_row => x_ic_lots_cpg_row
252: , x_return_status => x_return_status
253: , x_msg_count => x_msg_count
254: , x_msg_data => x_msg_data
255: );

Line 265: x_ic_lots_cpg_row.lot_id := x_ic_lots_mst_row.lot_id;

261:
262: IF GMIVDBL.ic_lots_mst_insert(x_ic_lots_mst_row, x_ic_lots_mst_row)
263: THEN
264: -- Jatinder - B3158806 - Removed SY$CPG_INSTALL check
265: x_ic_lots_cpg_row.lot_id := x_ic_lots_mst_row.lot_id;
266: IF GMIVDBL.ic_lots_cpg_insert(x_ic_lots_cpg_row, x_ic_lots_cpg_row)
267: THEN
268: NULL;
269: ELSE

Line 266: IF GMIVDBL.ic_lots_cpg_insert(x_ic_lots_cpg_row, x_ic_lots_cpg_row)

262: IF GMIVDBL.ic_lots_mst_insert(x_ic_lots_mst_row, x_ic_lots_mst_row)
263: THEN
264: -- Jatinder - B3158806 - Removed SY$CPG_INSTALL check
265: x_ic_lots_cpg_row.lot_id := x_ic_lots_mst_row.lot_id;
266: IF GMIVDBL.ic_lots_cpg_insert(x_ic_lots_cpg_row, x_ic_lots_cpg_row)
267: THEN
268: NULL;
269: ELSE
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 470: | p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE |

466: | p_qty_rec IN GMIGAPI.qty_rec_typ - Quantity details |
467: | p_ic_item_mst_row IN ic_item_mst%ROWTYPE |
468: | p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE |
469: | p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE |
470: | p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE |
471: | x_ic_jrnl_mst_row OUT ic_jrnl_mst%ROWTYPE |
472: | x_ic_adjs_jnl_row1 OUT ic_adjs_jnl%ROWTYPE |
473: | x_ic_adjs_jnl_row2 OUT ic_adjs_jnl%ROWTYPE |
474: | x_return_status OUT VARCHAR2 - Return Status |

Line 521: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE

517: , p_qty_rec IN GMIGAPI.qty_rec_typ
518: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
519: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
520: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
521: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
522: , x_ic_jrnl_mst_row OUT NOCOPY ic_jrnl_mst%ROWTYPE
523: , x_ic_adjs_jnl_row1 OUT NOCOPY ic_adjs_jnl%ROWTYPE
524: , x_ic_adjs_jnl_row2 OUT NOCOPY ic_adjs_jnl%ROWTYPE
525: , x_return_status OUT NOCOPY VARCHAR2

Line 531: l_ic_lots_cpg_row ic_lots_cpg%ROWTYPE;

527: , x_msg_data OUT NOCOPY VARCHAR2
528: )
529: IS
530: l_ic_lots_mst_row ic_lots_mst%ROWTYPE;
531: l_ic_lots_cpg_row ic_lots_cpg%ROWTYPE;
532: l_lot_rec GMIGAPI.lot_rec_typ;
533: l_tran_row1 ic_tran_cmp%ROWTYPE;
534: l_tran_row2 ic_tran_cmp%ROWTYPE;
535: l_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

Line 606: , p_ic_lots_cpg_row => p_ic_lots_cpg_row

602: , p_qty_rec => p_qty_rec
603: , p_ic_item_mst_row => p_ic_item_mst_row
604: , p_ic_item_cpg_row => p_ic_item_cpg_row
605: , p_ic_lots_mst_row => p_ic_lots_mst_row
606: , p_ic_lots_cpg_row => p_ic_lots_cpg_row
607: , x_ic_jrnl_mst_row => x_ic_jrnl_mst_row
608: , x_ic_adjs_jnl_row1 => x_ic_adjs_jnl_row1
609: , x_ic_adjs_jnl_row2 => x_ic_adjs_jnl_row2
610: , x_return_status => x_return_status

Line 643: , l_ic_lots_cpg_row

639: ( p_ic_item_mst_row.item_id
640: , p_qty_rec.lot_no
641: , p_qty_rec.sublot_no
642: , l_ic_lots_mst_row
643: , l_ic_lots_cpg_row
644: );
645:
646: IF l_ic_lots_mst_row.lot_id IS NULL
647: THEN

Line 656: , x_ic_lots_cpg_row => l_ic_lots_cpg_row

652: , p_lot_rec => l_lot_rec
653: , p_ic_item_mst_row => p_ic_item_mst_row
654: , p_ic_item_cpg_row => p_ic_item_cpg_row
655: , x_ic_lots_mst_row => l_ic_lots_mst_row
656: , x_ic_lots_cpg_row => l_ic_lots_cpg_row
657: , x_return_status => x_return_status
658: , x_msg_count => x_msg_count
659: , x_msg_data => x_msg_data
660: );

Line 987: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE

983: , p_xfer_rec IN GMIGAPI.xfer_rec_typ
984: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
985: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
986: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
987: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
988: , p_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE
989: , x_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE
990: , x_return_status OUT NOCOPY VARCHAR2
991: , x_msg_count OUT NOCOPY NUMBER