[Home] [Help]
PACKAGE: APPS.GMI_TRANS_ENGINE_PUB
Source
1 PACKAGE GMI_TRANS_ENGINE_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMIPTXNS.pls 115.15 2004/04/16 05:26:56 mkalyani ship $
3 +=========================================================================+
4 | Copyright (c) 2000 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 +=========================================================================+
8 | FILENAME |
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 |
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 |
23 | Added field intorder_posted_ind. |
24 | 14-APR-2004 V.Anitha BUG#3526733 |
25 | Added reverse_id column to the Record ictran_rec. |
26 +=========================================================================+
27 API Name : GMI_TRANS_ENGINE_PUB
28 Type : Public
29 Function : This package contains public procedures used to create
30 inventory transactions.
31 Pre-reqs : N/A
32 Parameters: Per function
33
34 Current Vers : 1.0
35
36 Previous Vers : 1.0
37
38 Initial Vers : 1.0
39 Notes
40 */
41
42 /* Create Record definition For Transaction
43 API specific parameters to be presented in SQL RECORD format
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
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
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
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
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
84
85 PROCEDURE CREATE_PENDING_TRANSACTION
86 ( p_api_version IN NUMBER
87 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
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 );
97
98
99 PROCEDURE CREATE_COMPLETED_TRANSACTION
100 ( p_api_version IN NUMBER
101 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
102 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
103 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
104 , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
105 , x_tran_row OUT NOCOPY IC_TRAN_CMP%ROWTYPE
106 , x_return_status OUT NOCOPY VARCHAR2
107 , x_msg_count OUT NOCOPY NUMBER
108 , x_msg_data OUT NOCOPY VARCHAR2
109 , p_table_name IN VARCHAR2 DEFAULT 'IC_TRAN_CMP'
110 );
111
112
113 PROCEDURE DELETE_PENDING_TRANSACTION
114 ( p_api_version IN NUMBER
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
124 );
125
126 PROCEDURE UPDATE_PENDING_TRANSACTION
127 ( p_api_version IN NUMBER
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
137 );
138
139
140 /* - For This Version Put Completed In Same File
141 */
142
143 PROCEDURE UPDATE_PENDING_TO_COMPLETED
144 ( p_api_version IN NUMBER
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
154 );
155
156
157 FUNCTION check_missing
158 (
159 p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
160 )
161 RETURN BOOLEAN;
162
163 END GMI_TRANS_ENGINE_PUB;