[Home] [Help]
PACKAGE: APPS.DPP_EXECUTIONPROCESS_PVT
Source
1 PACKAGE DPP_EXECUTIONPROCESS_PVT AUTHID CURRENT_USER AS
2 /* $Header: dppexpps.pls 120.5 2009/08/20 04:54:36 anbbalas noship $ */
3
4 -- Package name : DPP_EXECUTIONPROCESS_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 ---------------------------------------------------------------------
11 -- PROCEDURE
12 -- Populate_ExecutionProcess
13 --
14 -- PURPOSE
15 -- Populate Execution Process as soon as the transaction is created
16 --
17 -- PARAMETERS
18 --
19 -- NOTES
20 -- 1.
21 -- 2.
22 ----------------------------------------------------------------------
23 PROCEDURE populate_ExecutionProcess(
24 p_api_version_number IN NUMBER,
25 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26 p_commit IN VARCHAR2 := FND_API.G_FALSE,
27 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 p_org_id IN NUMBER,
32 p_txn_hdr_id IN NUMBER,
33 p_txn_number IN VARCHAR2,
34 p_vendor_id IN NUMBER,
35 p_vendor_site_id IN NUMBER
36 );
37
38 ---------------------------------------------------------------------
39 -- PROCEDURE
40 -- InsertExecProcesses
41 --
42 -- PURPOSE
43 -- Insert Execution Process as soon as the transaction is created
44 --
45 -- PARAMETERS
46 --
47 -- NOTES
48 -- 1.
49 -- 2.
50 ----------------------------------------------------------------------
51 PROCEDURE InsertExecProcesses(
52 p_txn_hdr_id IN NUMBER,
53 p_org_id IN NUMBER,
54 p_supp_trd_prfl_id IN NUMBER,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2
58 );
59
60
61 ---------------------------------------------------------------------
62 -- PROCEDURE
63 -- Initiate_ExecutionProcess
64 --
65 -- PURPOSE
66 -- Initiate Execution Process
67 --
68 -- PARAMETERS
69 --
70 -- NOTES
71 -- 1.
72 -- 2.
73 ----------------------------------------------------------------------
74
75 PROCEDURE Initiate_ExecutionProcess(
76 errbuf OUT NOCOPY VARCHAR2,
77 retcode OUT NOCOPY VARCHAR2,
78 p_in_org_id IN NUMBER,
79 p_in_txn_number IN VARCHAR2
80 );
81
82 ---------------------------------------------------------------------
83 -- PROCEDURE
84 -- Initiate_Notification_Process
85 --
86 -- PURPOSE
87 -- Initiates all the notification processes only.
88 --
89 ----------------------------------------------------------------------
90 PROCEDURE Initiate_Notification_Process(errbuf OUT NOCOPY VARCHAR2,
91 retcode OUT NOCOPY VARCHAR2,
92 p_in_org_id IN NUMBER
93 );
94
95 ---------------------------------------------------------------------
96 -- PROCEDURE
97 -- Change_Status
98 --
99 -- PURPOSE
100 -- Future dated Transactions will be moved from Active to Pending Adjustment
101 -- status on the effective date. Further, Work Flow notification will be sent to
102 -- the creator of the transactions.
103 --
104 -- PARAMETERS
105 -- p_in_org_id - operating unit
106 --
107 -- NOTES
108 ---------------------------------------------------------------------
109 PROCEDURE Change_Status (
110 errbuf OUT NOCOPY VARCHAR2
111 ,retcode OUT NOCOPY VARCHAR2
112 ,p_in_org_id IN NUMBER);
113
114 ---------------------------------------------------------------------
115 -- PROCEDURE
116 -- approve_transaction
117 --
118 -- PURPOSE
119 -- This procedure will directly update the transaction status to
120 -- APPROVED without going through the AME approval and initiate the
121 -- automated execution processes
122 --
123 -- PARAMETERS
124 --
125 -- NOTES
126 -- 1.
127 -- 2.
128 ----------------------------------------------------------------------
129 PROCEDURE approve_transaction(
130 p_api_version_number IN NUMBER,
131 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
132 p_commit IN VARCHAR2 := FND_API.G_FALSE,
133 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_txn_hdr_id IN NUMBER
138 );
139
140 ---------------------------------------------------------------------
141 -- PROCEDURE
142 -- update_status
143 --
144 -- PURPOSE
145 -- This procedure will update the transaction status of a particular
146 -- Price Protection transaction.
147 --
148 -- PARAMETERS
149 --
150 -- NOTES
151 -- 1.
152 -- 2.
153 ----------------------------------------------------------------------
154 PROCEDURE update_status(
155 p_api_version_number IN NUMBER,
156 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157 p_commit IN VARCHAR2 := FND_API.G_FALSE,
158 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_txn_hdr_id IN NUMBER,
163 p_to_status IN VARCHAR2
164 );
165
166 ---------------------------------------------------------------------
167 -- PROCEDURE
168 -- Update_HeaderLog
169 --
170 -- PURPOSE
171 -- This procedure will update the transaction header log of a particular
172 -- Price Protection transaction.
173 --
174 -- PARAMETERS
175 --
176 -- NOTES
177 -- 1.
178 -- 2.
179 ----------------------------------------------------------------------
180 PROCEDURE Update_HeaderLog(
181 p_api_version_number IN NUMBER,
182 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
183 p_commit IN VARCHAR2 := FND_API.G_FALSE,
184 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_transaction_header_id IN NUMBER
189 );
190
191 END DPP_EXECUTIONPROCESS_PVT;