APPS.GMI_TRANS_ENGINE_PUB dependencies on IC_TRAN_PND

Line 13: | inventory Transcations For IC_TRAN_PND |

9: | GMIPTXNS.pls |
10: | |
11: | DESCRIPTION |
12: | This package contains public definitions For creation of |
13: | inventory Transcations For IC_TRAN_PND |
14: | |
15: | HISTORY |
16: | 12-JAN-2000 H.Verdding |
17: | 26_May-2000 Support for ic_tran_cmp added |

Line 18: | 15-Jul-2001 Support for adding completed txns to ic_tran_pnd added |

14: | |
15: | HISTORY |
16: | 12-JAN-2000 H.Verdding |
17: | 26_May-2000 Support for ic_tran_cmp added |
18: | 15-Jul-2001 Support for adding completed txns to ic_tran_pnd added |
19: | 25-AUG-2001 NC added line_detail_id in the ictran_rec record def. |
20: | BUG#1675561
21: | 29-Oct-2002 J. DiIorio Bug#2643440 11.5.1J - added nocopy. |
22: | 14-Aug-2003 J. DiIorio Bug#3090255 11.5.10L |

Line 48: ( trans_id IC_TRAN_PND.TRANS_ID%TYPE

44: */
45: /* A record type Definition Of A Transaction */
46:
47: TYPE ictran_rec is RECORD
48: ( trans_id IC_TRAN_PND.TRANS_ID%TYPE
49: , item_id IC_ITEM_MST.ITEM_ID%TYPE
50: , line_id IC_TRAN_PND.LINE_ID%TYPE
51: , co_code IC_TRAN_PND.CO_CODE%TYPE
52: , orgn_code IC_TRAN_PND.ORGN_CODE%TYPE

Line 50: , line_id IC_TRAN_PND.LINE_ID%TYPE

46:
47: TYPE ictran_rec is RECORD
48: ( trans_id IC_TRAN_PND.TRANS_ID%TYPE
49: , item_id IC_ITEM_MST.ITEM_ID%TYPE
50: , line_id IC_TRAN_PND.LINE_ID%TYPE
51: , co_code IC_TRAN_PND.CO_CODE%TYPE
52: , orgn_code IC_TRAN_PND.ORGN_CODE%TYPE
53: , whse_code IC_TRAN_PND.WHSE_CODE%TYPE
54: , lot_id IC_LOTS_MST.ITEM_ID%TYPE

Line 51: , co_code IC_TRAN_PND.CO_CODE%TYPE

47: TYPE ictran_rec is RECORD
48: ( trans_id IC_TRAN_PND.TRANS_ID%TYPE
49: , item_id IC_ITEM_MST.ITEM_ID%TYPE
50: , line_id IC_TRAN_PND.LINE_ID%TYPE
51: , co_code IC_TRAN_PND.CO_CODE%TYPE
52: , orgn_code IC_TRAN_PND.ORGN_CODE%TYPE
53: , whse_code IC_TRAN_PND.WHSE_CODE%TYPE
54: , lot_id IC_LOTS_MST.ITEM_ID%TYPE
55: , location IC_LOCT_MST.LOCATION%TYPE

Line 52: , orgn_code IC_TRAN_PND.ORGN_CODE%TYPE

48: ( trans_id IC_TRAN_PND.TRANS_ID%TYPE
49: , item_id IC_ITEM_MST.ITEM_ID%TYPE
50: , line_id IC_TRAN_PND.LINE_ID%TYPE
51: , co_code IC_TRAN_PND.CO_CODE%TYPE
52: , orgn_code IC_TRAN_PND.ORGN_CODE%TYPE
53: , whse_code IC_TRAN_PND.WHSE_CODE%TYPE
54: , lot_id IC_LOTS_MST.ITEM_ID%TYPE
55: , location IC_LOCT_MST.LOCATION%TYPE
56: , doc_id IC_TRAN_PND.DOC_ID%TYPE

Line 53: , whse_code IC_TRAN_PND.WHSE_CODE%TYPE

49: , item_id IC_ITEM_MST.ITEM_ID%TYPE
50: , line_id IC_TRAN_PND.LINE_ID%TYPE
51: , co_code IC_TRAN_PND.CO_CODE%TYPE
52: , orgn_code IC_TRAN_PND.ORGN_CODE%TYPE
53: , whse_code IC_TRAN_PND.WHSE_CODE%TYPE
54: , lot_id IC_LOTS_MST.ITEM_ID%TYPE
55: , location IC_LOCT_MST.LOCATION%TYPE
56: , doc_id IC_TRAN_PND.DOC_ID%TYPE
57: , doc_type SY_DOCS_MST.DOC_TYPE%TYPE

Line 56: , doc_id IC_TRAN_PND.DOC_ID%TYPE

52: , orgn_code IC_TRAN_PND.ORGN_CODE%TYPE
53: , whse_code IC_TRAN_PND.WHSE_CODE%TYPE
54: , lot_id IC_LOTS_MST.ITEM_ID%TYPE
55: , location IC_LOCT_MST.LOCATION%TYPE
56: , doc_id IC_TRAN_PND.DOC_ID%TYPE
57: , doc_type SY_DOCS_MST.DOC_TYPE%TYPE
58: , doc_line IC_TRAN_PND.DOC_LINE%TYPE
59: , line_type IC_TRAN_PND.LINE_TYPE%TYPE
60: , reason_code SY_REAS_CDS.REASON_CODE%TYPE

Line 58: , doc_line IC_TRAN_PND.DOC_LINE%TYPE

54: , lot_id IC_LOTS_MST.ITEM_ID%TYPE
55: , location IC_LOCT_MST.LOCATION%TYPE
56: , doc_id IC_TRAN_PND.DOC_ID%TYPE
57: , doc_type SY_DOCS_MST.DOC_TYPE%TYPE
58: , doc_line IC_TRAN_PND.DOC_LINE%TYPE
59: , line_type IC_TRAN_PND.LINE_TYPE%TYPE
60: , reason_code SY_REAS_CDS.REASON_CODE%TYPE
61: , trans_date IC_TRAN_PND.TRANS_DATE%TYPE
62: , trans_qty IC_TRAN_PND.TRANS_QTY%TYPE

Line 59: , line_type IC_TRAN_PND.LINE_TYPE%TYPE

55: , location IC_LOCT_MST.LOCATION%TYPE
56: , doc_id IC_TRAN_PND.DOC_ID%TYPE
57: , doc_type SY_DOCS_MST.DOC_TYPE%TYPE
58: , doc_line IC_TRAN_PND.DOC_LINE%TYPE
59: , line_type IC_TRAN_PND.LINE_TYPE%TYPE
60: , reason_code SY_REAS_CDS.REASON_CODE%TYPE
61: , trans_date IC_TRAN_PND.TRANS_DATE%TYPE
62: , trans_qty IC_TRAN_PND.TRANS_QTY%TYPE
63: , trans_qty2 IC_TRAN_PND.TRANS_QTY%TYPE

Line 61: , trans_date IC_TRAN_PND.TRANS_DATE%TYPE

57: , doc_type SY_DOCS_MST.DOC_TYPE%TYPE
58: , doc_line IC_TRAN_PND.DOC_LINE%TYPE
59: , line_type IC_TRAN_PND.LINE_TYPE%TYPE
60: , reason_code SY_REAS_CDS.REASON_CODE%TYPE
61: , trans_date IC_TRAN_PND.TRANS_DATE%TYPE
62: , trans_qty IC_TRAN_PND.TRANS_QTY%TYPE
63: , trans_qty2 IC_TRAN_PND.TRANS_QTY%TYPE
64: , qc_grade QC_GRAD_MST.QC_GRADE%TYPE
65: , lot_no IC_LOTS_MST.LOT_NO%TYPE

Line 62: , trans_qty IC_TRAN_PND.TRANS_QTY%TYPE

58: , doc_line IC_TRAN_PND.DOC_LINE%TYPE
59: , line_type IC_TRAN_PND.LINE_TYPE%TYPE
60: , reason_code SY_REAS_CDS.REASON_CODE%TYPE
61: , trans_date IC_TRAN_PND.TRANS_DATE%TYPE
62: , trans_qty IC_TRAN_PND.TRANS_QTY%TYPE
63: , trans_qty2 IC_TRAN_PND.TRANS_QTY%TYPE
64: , qc_grade QC_GRAD_MST.QC_GRADE%TYPE
65: , lot_no IC_LOTS_MST.LOT_NO%TYPE
66: , sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE

Line 63: , trans_qty2 IC_TRAN_PND.TRANS_QTY%TYPE

59: , line_type IC_TRAN_PND.LINE_TYPE%TYPE
60: , reason_code SY_REAS_CDS.REASON_CODE%TYPE
61: , trans_date IC_TRAN_PND.TRANS_DATE%TYPE
62: , trans_qty IC_TRAN_PND.TRANS_QTY%TYPE
63: , trans_qty2 IC_TRAN_PND.TRANS_QTY%TYPE
64: , qc_grade QC_GRAD_MST.QC_GRADE%TYPE
65: , lot_no IC_LOTS_MST.LOT_NO%TYPE
66: , sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE
67: , lot_status IC_LOTS_STS.LOT_STATUS%TYPE

Line 68: , trans_stat IC_TRAN_PND.TRANS_STAT%TYPE

64: , qc_grade QC_GRAD_MST.QC_GRADE%TYPE
65: , lot_no IC_LOTS_MST.LOT_NO%TYPE
66: , sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE
67: , lot_status IC_LOTS_STS.LOT_STATUS%TYPE
68: , trans_stat IC_TRAN_PND.TRANS_STAT%TYPE
69: , trans_um IC_TRAN_PND.TRANS_UM%TYPE
70: , trans_um2 IC_TRAN_PND.TRANS_UM2%TYPE
71: , staged_ind IC_TRAN_PND.staged_ind%TYPE
72: , event_id IC_TRAN_PND.event_id%TYPE

Line 69: , trans_um IC_TRAN_PND.TRANS_UM%TYPE

65: , lot_no IC_LOTS_MST.LOT_NO%TYPE
66: , sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE
67: , lot_status IC_LOTS_STS.LOT_STATUS%TYPE
68: , trans_stat IC_TRAN_PND.TRANS_STAT%TYPE
69: , trans_um IC_TRAN_PND.TRANS_UM%TYPE
70: , trans_um2 IC_TRAN_PND.TRANS_UM2%TYPE
71: , staged_ind IC_TRAN_PND.staged_ind%TYPE
72: , event_id IC_TRAN_PND.event_id%TYPE
73: , text_code IC_TRAN_PND.TEXT_CODE%TYPE

Line 70: , trans_um2 IC_TRAN_PND.TRANS_UM2%TYPE

66: , sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE
67: , lot_status IC_LOTS_STS.LOT_STATUS%TYPE
68: , trans_stat IC_TRAN_PND.TRANS_STAT%TYPE
69: , trans_um IC_TRAN_PND.TRANS_UM%TYPE
70: , trans_um2 IC_TRAN_PND.TRANS_UM2%TYPE
71: , staged_ind IC_TRAN_PND.staged_ind%TYPE
72: , event_id IC_TRAN_PND.event_id%TYPE
73: , text_code IC_TRAN_PND.TEXT_CODE%TYPE
74: , user_id FND_USER.USER_ID%TYPE

Line 71: , staged_ind IC_TRAN_PND.staged_ind%TYPE

67: , lot_status IC_LOTS_STS.LOT_STATUS%TYPE
68: , trans_stat IC_TRAN_PND.TRANS_STAT%TYPE
69: , trans_um IC_TRAN_PND.TRANS_UM%TYPE
70: , trans_um2 IC_TRAN_PND.TRANS_UM2%TYPE
71: , staged_ind IC_TRAN_PND.staged_ind%TYPE
72: , event_id IC_TRAN_PND.event_id%TYPE
73: , text_code IC_TRAN_PND.TEXT_CODE%TYPE
74: , user_id FND_USER.USER_ID%TYPE
75: , create_lot_index NUMBER

Line 72: , event_id IC_TRAN_PND.event_id%TYPE

68: , trans_stat IC_TRAN_PND.TRANS_STAT%TYPE
69: , trans_um IC_TRAN_PND.TRANS_UM%TYPE
70: , trans_um2 IC_TRAN_PND.TRANS_UM2%TYPE
71: , staged_ind IC_TRAN_PND.staged_ind%TYPE
72: , event_id IC_TRAN_PND.event_id%TYPE
73: , text_code IC_TRAN_PND.TEXT_CODE%TYPE
74: , user_id FND_USER.USER_ID%TYPE
75: , create_lot_index NUMBER
76: , non_inv NUMBER

Line 73: , text_code IC_TRAN_PND.TEXT_CODE%TYPE

69: , trans_um IC_TRAN_PND.TRANS_UM%TYPE
70: , trans_um2 IC_TRAN_PND.TRANS_UM2%TYPE
71: , staged_ind IC_TRAN_PND.staged_ind%TYPE
72: , event_id IC_TRAN_PND.event_id%TYPE
73: , text_code IC_TRAN_PND.TEXT_CODE%TYPE
74: , user_id FND_USER.USER_ID%TYPE
75: , create_lot_index NUMBER
76: , non_inv NUMBER
77: , line_detail_id NUMBER

Line 78: , intorder_posted_ind IC_TRAN_PND.INTORDER_POSTED_IND%TYPE

74: , user_id FND_USER.USER_ID%TYPE
75: , create_lot_index NUMBER
76: , non_inv NUMBER
77: , line_detail_id NUMBER
78: , intorder_posted_ind IC_TRAN_PND.INTORDER_POSTED_IND%TYPE
79: , reverse_id IC_TRAN_PND.REVERSE_ID%TYPE --BUG#3526733
80: );
81:
82: /* Define Procedures And Functions : */

Line 79: , reverse_id IC_TRAN_PND.REVERSE_ID%TYPE --BUG#3526733

75: , create_lot_index NUMBER
76: , non_inv NUMBER
77: , line_detail_id NUMBER
78: , intorder_posted_ind IC_TRAN_PND.INTORDER_POSTED_IND%TYPE
79: , reverse_id IC_TRAN_PND.REVERSE_ID%TYPE --BUG#3526733
80: );
81:
82: /* Define Procedures And Functions : */
83:

Line 92: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

88: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
89: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
90: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
91: /* , x_tran_rec OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec_out */
92: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
93: , x_return_status OUT NOCOPY VARCHAR2
94: , x_msg_count OUT NOCOPY NUMBER
95: , x_msg_data OUT NOCOPY VARCHAR2
96: );

Line 119: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

115: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
116: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
117: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
118: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
119: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
120: /* , x_tran_rec OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec_out */
121: , x_return_status OUT NOCOPY VARCHAR2
122: , x_msg_count OUT NOCOPY NUMBER
123: , x_msg_data OUT NOCOPY VARCHAR2

Line 132: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

128: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
129: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
130: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
131: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
132: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
133: /* , x_tran_rec OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec_out */
134: , x_return_status OUT NOCOPY VARCHAR2
135: , x_msg_count OUT NOCOPY NUMBER
136: , x_msg_data OUT NOCOPY VARCHAR2

Line 149: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

145: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
146: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
147: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
148: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
149: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
150: /* , x_tran_rec OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec_out */
151: , x_return_status OUT NOCOPY VARCHAR2
152: , x_msg_count OUT NOCOPY NUMBER
153: , x_msg_data OUT NOCOPY VARCHAR2