[Home] [Help]
PACKAGE: APPS.GMI_TRANS_ENGINE_PVT
Source
1 PACKAGE GMI_TRANS_ENGINE_PVT AUTHID CURRENT_USER AS
2 /* $Header: GMIVTXNS.pls 115.11 2002/11/05 18:40:48 jdiiorio ship $
3 +=========================================================================+
4 | Copyright (c) 2000 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 +=========================================================================+
8 | FILENAME |
9 | GMIVTXNS.pls |
10 | |
11 | DESCRIPTION |
12 | This package contains private definitions For creation of |
13 | inventory Transcations For IC_TRAN_PND |
14 | |
15 | HISTORY |
16 | 12-JAN-2000 H.Verdding |
17 | 26-May-2000 P.J.Schofield |
18 | Added support for ic_tran_cmp |
19 | 14-JUN-2001 H.Verdding |
20 | Added Function check_close_period B1834369 |
21 | 04-NOV-2002 J.DiIorio BUG#2643440 11.5.1J |
22 | Added nocopy. |
23 +=========================================================================+
24 API Name : GMI_TRANS_ENGINE_PVT
25 Type : Public
26 Function : This package contains private procedures used to create
27 inventory transactions.
28 Pre-reqs : N/A
29 Parameters: Per function
30
31 Current Vers : 1.0
32
33 Previous Vers : 1.0
34
35 Initial Vers : 1.0
36 Notes
37
38 */
39 /* Define Procedures And Functions : */
40
41
42 PROCEDURE CREATE_PENDING_TRANSACTION
43 ( p_api_version IN NUMBER
44 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
45 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
46 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
47 , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
48 , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
49 , x_return_status OUT NOCOPY VARCHAR2
50 , x_msg_count OUT NOCOPY NUMBER
51 , x_msg_data OUT NOCOPY VARCHAR2
52 );
53
54 PROCEDURE CREATE_COMPLETED_TRANSACTION
55 ( p_api_version IN NUMBER
56 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
57 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
58 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
59 , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
60 , x_tran_row OUT NOCOPY IC_TRAN_CMP%ROWTYPE
61 , x_return_status OUT NOCOPY VARCHAR2
62 , x_msg_count OUT NOCOPY NUMBER
63 , x_msg_data OUT NOCOPY VARCHAR2
64 , p_table_name IN VARCHAR2 DEFAULT 'IC_TRAN_CMP'
65 );
66
67 PROCEDURE DELETE_PENDING_TRANSACTION
68 ( p_api_version IN NUMBER
69 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
70 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
71 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
72 , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
73 , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
74 , x_return_status OUT NOCOPY VARCHAR2
75 , x_msg_count OUT NOCOPY NUMBER
76 , x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE UPDATE_PENDING_TRANSACTION
80 ( p_api_version IN NUMBER
81 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
82 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
83 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
84 , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
85 , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
86 , x_return_status OUT NOCOPY VARCHAR2
87 , x_msg_count OUT NOCOPY NUMBER
88 , x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91 PROCEDURE UPDATE_PENDING_TO_COMPLETED
92 ( p_api_version IN NUMBER
93 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
94 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
95 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
96 , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
97 , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
98 , x_return_status OUT NOCOPY VARCHAR2
99 , x_msg_count OUT NOCOPY NUMBER
100 , x_msg_data OUT NOCOPY VARCHAR2
101 );
102
103 PROCEDURE PENDING_TRANSACTION_BUILD
104 ( p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
105 , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
106 , x_return_status OUT NOCOPY VARCHAR2
107 );
108
109 PROCEDURE COMPLETED_TRANSACTION_BUILD
110 ( p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
111 , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
112 , x_return_status OUT NOCOPY VARCHAR2
113 );
114
115 Procedure SET_DEFAULTS
116 ( p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
117 , x_tran_rec OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec
118 );
119
120 FUNCTION CLOSE_PERIOD_CHECK
121 ( p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
122 , p_retry_flag IN NUMBER
123 , x_tran_rec IN OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec
124 )
125 RETURN BOOLEAN;
126
127
128 END GMI_TRANS_ENGINE_PVT;