DBA Data[Home] [Help]

APPS.GMIGAPI dependencies on IC_ITEM_CPG

Line 27: | x_ic_item_cpg_row OUT ic_item_cpg%ROWTYPE - The ic_item_cpg row |

23: | p_commit IN VARCHAR2 - Commit Indicator |
24: | p_validation_level IN VARCHAR2 - Validation Level Indicator |
25: | p_item_rec IN item_rec_typ - Item details |
26: | x_ic_item_mst_row OUT ic_item_mst%ROWTYPE - The ic_item_mst row |
27: | x_ic_item_cpg_row OUT ic_item_cpg%ROWTYPE - The ic_item_cpg row |
28: | x_return_status OUT VARCHAR2 - Return Status |
29: | x_msg_count OUT NUMBER - Number of messages |
30: | x_msg_data OUT VARCHAR2 - Messages in encoded format |
31: | |

Line 50: , x_ic_item_cpg_row OUT NOCOPY ic_item_cpg%ROWTYPE

46: , p_commit IN VARCHAR2 := FND_API.G_FALSE
47: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
48: , p_item_rec IN GMIGAPI.item_rec_typ
49: , x_ic_item_mst_row OUT NOCOPY ic_item_mst%ROWTYPE
50: , x_ic_item_cpg_row OUT NOCOPY ic_item_cpg%ROWTYPE
51: , x_return_status OUT NOCOPY VARCHAR2
52: , x_msg_count OUT NOCOPY NUMBER
53: , x_msg_data OUT NOCOPY VARCHAR2
54: )

Line 84: , x_ic_item_cpg_row => x_ic_item_cpg_row

80: ( p_api_version => p_api_version
81: , p_validation_level => p_validation_level
82: , p_item_rec => p_item_rec
83: , x_ic_item_mst_row => x_ic_item_mst_row
84: , x_ic_item_cpg_row => x_ic_item_cpg_row
85: , x_return_status => x_return_status
86: , x_msg_count => x_msg_count
87: , x_msg_data => x_msg_data
88: );

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

103: -- added check for lot_ctl instead
104: IF x_ic_item_mst_row.lot_ctl = 1
105: THEN
106: /* ic_item_mst created OK. Copy the allocated item_id. */
107: x_ic_item_cpg_row.item_id := x_ic_item_mst_row.item_id;
108: IF GMIVDBL.ic_item_cpg_insert(x_ic_item_cpg_row, x_ic_item_cpg_row)
109: THEN
110: NULL;
111: ELSE

Line 108: IF GMIVDBL.ic_item_cpg_insert(x_ic_item_cpg_row, x_ic_item_cpg_row)

104: IF x_ic_item_mst_row.lot_ctl = 1
105: THEN
106: /* ic_item_mst created OK. Copy the allocated item_id. */
107: x_ic_item_cpg_row.item_id := x_ic_item_mst_row.item_id;
108: IF GMIVDBL.ic_item_cpg_insert(x_ic_item_cpg_row, x_ic_item_cpg_row)
109: THEN
110: NULL;
111: ELSE
112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 130: , p_ic_item_cpg_row => x_ic_item_cpg_row

126: , p_commit => FND_API.G_FALSE
127: , p_validation_level=> FND_API.G_VALID_LEVEL_NONE
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

Line 217: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE

213: , p_commit IN VARCHAR2 := FND_API.G_FALSE
214: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
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

Line 249: , p_ic_item_cpg_row => p_ic_item_cpg_row

245: ( p_api_version => p_api_version
246: , p_validation_level => p_validation_level
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

Line 468: | p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE |

464: | p_commit IN VARCHAR2 - Commit Indicator |
465: | p_validation_level IN VARCHAR2 - Validation Level Indicator |
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 |

Line 519: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE

515: , p_commit IN VARCHAR2 := FND_API.G_FALSE
516: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
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

Line 604: , p_ic_item_cpg_row => p_ic_item_cpg_row

600: ( p_api_version => p_api_version
601: , p_validation_level => p_validation_level
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

Line 654: , p_ic_item_cpg_row => p_ic_item_cpg_row

650: , p_commit => FND_API.G_FALSE
651: , p_validation_level=> FND_API.G_VALID_LEVEL_FULL
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

Line 985: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE

981: , p_commit IN VARCHAR2
982: , p_validation_level IN NUMBER
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