1 PACKAGE GML_BATCH_OM_RES_PVT AUTHID CURRENT_USER AS
2 /* $Header: GMLORESS.pls 115.4 2004/01/29 22:44:04 nchekuri noship $
3 +=========================================================================+
4 | Copyright (c) 2000 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 +=========================================================================+
8 | FILENAME |
9 | GMIURSVS.pls |
10 | |
11 | DESCRIPTION |
12 | This package contains private utilities relating to OPM |
13 | reservation. |
14 | |
15 | |
16 | HISTORY |
17 | Aug-18-2003 Liping Gao Created |
18 +=========================================================================+
19 API Name : GML_BATCH_OM_RES_PVT
20 Type : Private
21 Function : This package contains Private Utilities procedures used to
22 OPM reservation for a batch.
23 Pre-reqs : N/A
24 Parameters: Per function
25
26 Current Vers : 1.0
27
28 */
29
30
31 PROCEDURE create_reservation_from_FPO
32 (
33 P_FPO_batch_id IN NUMBER
34 , P_New_batch_id IN NUMBER
35 , X_return_status OUT NOCOPY VARCHAR2
36 , X_msg_cont OUT NOCOPY NUMBER
37 , X_msg_data OUT NOCOPY VARCHAR2
38 );
39 PROCEDURE create_allocations
40 (
41 P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
42 , P_gme_om_rule_rec IN GML_BATCH_OM_UTIL.gme_om_rule_rec
43 , P_Gme_trans_row IN ic_tran_pnd%rowtype
44 , X_return_status OUT NOCOPY VARCHAR2
45 , X_msg_cont OUT NOCOPY NUMBER
46 , X_msg_data OUT NOCOPY VARCHAR2
47 );
48 PROCEDURE cancel_alloc_for_trans
49 (
50 P_Batch_trans_id IN NUMBER Default null
51 , X_return_status OUT NOCOPY VARCHAR2
52 , X_msg_cont OUT NOCOPY NUMBER
53 , X_msg_data OUT NOCOPY VARCHAR2
54 );
55 PROCEDURE cancel_alloc_for_batch
56 (
57 P_Batch_id IN NUMBER Default null
58 , X_return_status OUT NOCOPY VARCHAR2
59 , X_msg_cont OUT NOCOPY NUMBER
60 , X_msg_data OUT NOCOPY VARCHAR2
61 );
62 PROCEDURE cancel_alloc_for_batch_line
63 (
64 P_Batch_line_id IN NUMBER Default null
65 , X_return_status OUT NOCOPY VARCHAR2
66 , X_msg_cont OUT NOCOPY NUMBER
67 , X_msg_data OUT NOCOPY VARCHAR2
68 );
69 PROCEDURE cancel_res_for_batch_line
70 (
71 P_Batch_line_id IN NUMBER default null
72 , P_whse_code IN VARCHAR2 default null
73 , X_return_status OUT NOCOPY VARCHAR2
74 , X_msg_cont OUT NOCOPY NUMBER
75 , X_msg_data OUT NOCOPY VARCHAR2
76 ) ;
77 PROCEDURE cancel_res_for_so_line
78 (
79 P_so_line_id IN NUMBER default null
80 , X_return_status OUT NOCOPY VARCHAR2
81 , X_msg_cont OUT NOCOPY NUMBER
82 , X_msg_data OUT NOCOPY VARCHAR2
83 ) ;
84 PROCEDURE cancel_res_for_batch
85 (
86 P_Batch_id IN NUMBER default null
87 , X_return_status OUT NOCOPY VARCHAR2
88 , X_msg_cont OUT NOCOPY NUMBER
89 , X_msg_data OUT NOCOPY VARCHAR2
90 ) ;
91 PROCEDURE cancel_batch
92 (
93 P_Batch_id IN NUMBER
94 , X_return_status OUT NOCOPY VARCHAR2
95 , X_msg_cont OUT NOCOPY NUMBER
96 , X_msg_data OUT NOCOPY VARCHAR2
97 );
98 PROCEDURE notify_CSR
99 (
100 P_Batch_id IN NUMBER default null
101 , P_Batch_line_id IN NUMBER default null
102 , P_So_line_id IN NUMBER default null
103 , P_batch_trans_id IN NUMBER default null
104 , P_whse_code IN VARCHAR2 default null
105 , P_action_code IN VARCHAR2
106 , X_return_status OUT NOCOPY VARCHAR2
107 , X_msg_cont OUT NOCOPY NUMBER
108 , X_msg_data OUT NOCOPY VARCHAR2
109 );
110 PROCEDURE regenerate_alloc
111 (
112 P_alloc_history_rec IN GML_BATCH_OM_UTIL.alloc_history_rec
113 , x_return_status OUT NOCOPY VARCHAR2
114 );
115 PROCEDURE process_om_reservations
116 (
117 P_from_batch_id IN NUMBER default null
118 , P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
119 , P_Gme_trans_row IN ic_tran_pnd%rowtype
120 , P_batch_action IN VARCHAR2
121 , x_return_status OUT NOCOPY VARCHAR2
122 );
123 PROCEDURE split_reservations
124 ( p_old_delivery_detail_id IN NUMBER
125 , p_new_delivery_detail_id IN NUMBER
126 , p_old_source_line_id IN NUMBER
127 , p_new_source_line_id IN NUMBER
128 , p_qty_to_split IN NUMBER
129 , p_qty2_to_split IN NUMBER
130 , p_orig_qty IN NUMBER
131 , p_orig_qty2 IN NUMBER
132 , p_action IN VARCHAR2
133 , x_return_status OUT NOCOPY VARCHAR2
134 , x_msg_count OUT NOCOPY NUMBER
135 , x_msg_data OUT NOCOPY VARCHAR2
136 ) ;
137
138 PROCEDURE split_reservations_from_om
139 ( p_old_source_line_id IN NUMBER
140 , p_new_source_line_id IN NUMBER
141 , p_qty_to_split IN NUMBER -- remaining qty to the old line_id
142 , p_qty2_to_split IN NUMBER -- remaining qty2 to the old line_id
143 , p_orig_qty IN NUMBER
144 , p_orig_qty2 IN NUMBER
145 , x_return_status OUT NOCOPY VARCHAR2
146 , x_msg_count OUT NOCOPY NUMBER
147 , x_msg_data OUT NOCOPY VARCHAR2
148 );
149
150 PROCEDURE check_gmeres_for_so_line
151 ( p_so_line_id IN NUMBER
152 , p_delivery_detail_id IN NUMBER
153 , x_return_status OUT NOCOPY VARCHAR2
154 );
155
156 PROCEDURE pick_confirm
157 (
158 P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
159 , P_Gme_trans_row IN ic_tran_pnd%rowtype
160 , X_return_status OUT NOCOPY VARCHAR2
161 , X_msg_cont OUT NOCOPY NUMBER
162 , X_msg_data OUT NOCOPY VARCHAR2
163 );
164
165 END GML_BATCH_OM_RES_PVT;