[Home] [Help]
PACKAGE: APPS.CSI_ORDER_FULFILL_PUB
Source
1 PACKAGE csi_order_fulfill_pub AUTHID CURRENT_USER AS
2 /* $Header: csipiofs.pls 120.6 2011/06/23 12:30:15 dsingire ship $*/
3
4 g_pkg_name varchar2(30) := 'csi_order_fulfill_pub';
5
6 TYPE config_rec IS RECORD(
7 line_id number,
8 item_id number,
9 ship_organization_id number,
10 order_quantity number,
11 split_from_line_id number,
12 serial_code number,
13 make_flag varchar2(1), -- Y=Make else Buy
14 config_wip_job_id number,
15 config_wip_org_id number,
16 request_id number,
17 sub_model_flag varchar2(1), -- Y=order line is of a submodel
18 sub_model_line_id number,
19 sub_model_wip_supply_type number,
20 sub_config_item_id number,
21 sub_model_serial_code number,
22 sub_config_wip_job_id number,
23 sub_config_wip_org_id number,
24 sub_config_make_flag varchar2(1)); -- Y=Make else Buy
25
26 TYPE sub_type_rec IS RECORD(
27 transaction_type_id number,
28 sub_type_id number,
29 src_change_owner varchar2(1),
30 src_change_owner_code varchar2(1),
31 src_status_id number,
32 src_reference_reqd varchar2(1),
33 src_return_reqd varchar2(1),
34 nsrc_change_owner varchar2(1),
35 nsrc_change_owner_code varchar2(1),
36 nsrc_status_id number,
37 nsrc_reference_reqd varchar2(1),
38 nsrc_return_reqd varchar2(1));
39
40 TYPE config_serial_inst_rec IS RECORD(
41 serial_number varchar2(30),
42 instance_id number,
43 location_type_code varchar2(30),
44 ship_flag varchar2(1),
45 reship_flag varchar2(1),
46 wip_config_flag varchar2(1),
47 relationship_id number,
48 relationship_ovn number);
49
50 TYPE config_serial_inst_tbl IS TABLE OF config_serial_inst_rec INDEX BY binary_integer;
51
52 TYPE parent_instance IS RECORD(
53 item_id number,
54 instance_id number,
55 quantity number,
56 serial_number varchar2(80),
57 allocated_flag varchar2(1),
58 alloc_count number,
59 relationship_id number,
60 relationship_ovn number);
61
62 TYPE parent_instances IS TABLE OF parent_instance INDEX BY binary_integer;
63
64 TYPE wip_instance IS RECORD(
65 instance_id number,
66 quantity number,
67 serial_number varchar2(80),
68 location_type_code varchar2(80),
69 instance_usage_code varchar2(80),
70 allocated_flag varchar2(1));
71
72 TYPE wip_instances IS TABLE OF wip_instance INDEX BY binary_integer;
73
74 TYPE parent_child_map_rec IS RECORD(
75 object_tld_id number,
76 subject_tld_id number,
77 object_instance_id number,
78 subject_instance_id number);
79
80 TYPE parent_child_map_tbl IS TABLE OF parent_child_map_rec INDEX BY binary_integer;
81
82 TYPE default_info_rec is RECORD(
83 om_vld_org_id number,
84 sub_type_id number,
85 src_change_owner varchar2(1),
86 src_change_owner_code varchar2(1),
87 src_status_id number,
88 owner_party_acct_id number,
89 owner_party_id number,
90 current_party_site_id number,
91 install_party_site_id number,
92 identified_item_type varchar2(30),
93 ownership_cascade_at_txn varchar2(1),
94 internal_party_id number,
95 freeze_date date,
96 cascade_owner_flag varchar2(1),
97 split_flag varchar2(1),
98 ratio_split_flag varchar2(1),
99 split_ratio number,
100 transaction_line_id number,
101 primary_uom_code varchar2(30));
102
103 /* ---------------------------------------------------------------------- */
104 /* To get the next level IB trackable OE children. This routine is used */
105 /* to identify children for building the relationships */
106 /* ---------------------------------------------------------------------- */
107
108 PROCEDURE get_ib_trackable_children(
109 p_current_line_id IN number,
110 p_om_vld_org_id IN number,
111 x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,
112 x_return_status OUT NOCOPY varchar2);
113
114 PROCEDURE build_child_relation_lines (
115 p_order_line_rec IN oe_order_lines_all%ROWTYPE,
116 p_child_line_tbl IN oe_order_pub.line_tbl_type,
117 px_default_info_rec IN OUT NOCOPY default_info_rec,
118 px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
119 x_return_status OUT NOCOPY varchar2);
120
121 PROCEDURE get_all_ib_trackable_children(
122 p_model_line_id IN number,
123 p_om_vld_org_id IN number,
124 x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,
125 x_return_status OUT NOCOPY varchar2);
126
127 PROCEDURE get_ib_trackable_parent(
128 p_current_line_id IN number,
129 p_om_vld_org_id IN number,
130 x_parent_line_rec OUT NOCOPY oe_order_pub.line_rec_type,
131 x_return_status OUT NOCOPY varchar2);
132
133 PROCEDURE order_fulfillment(
134 p_order_line_id IN number,
135 p_message_id IN number,
136 x_return_status OUT NOCOPY varchar2,
137 px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec);
138
139 /* over loading this routine for XNC dependency, the signature change */
140 /* that affected the xnc_ib_wf.populate_ib routine */
141
142 PROCEDURE order_fulfillment(
143 p_order_line_id IN number,
144 p_message_id IN number,
145 x_return_status OUT NOCOPY varchar2,
146 x_error_message OUT NOCOPY varchar2);
147
148 /*Added procedure for bug 10329599
149 This procedure will get the Children of option item which are issues to WIP job*/
150 PROCEDURE build_option_child_line_tbl
151 (
152 p_option_item_id IN NUMBER
153 ,p_organization_id IN NUMBER
154 ,p_wip_job_id IN NUMBER
155 ,p_explosion_level IN NUMBER
156 ,p_phantom_option_item_ord_qty IN NUMBER --Added for bug 12673745
157 ,x_child_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type
158 ,x_return_status OUT NOCOPY VARCHAR2
159 );
160
161 -- Bug 10329599
162 PROCEDURE get_job_for_config_line(
163 p_config_rec IN config_rec,
164 x_wip_entity_id OUT nocopy number,
165 x_wip_organization_id OUT nocopy number,
166 x_request_id OUT nocopy number);
167
168 -- Bug 10329599
169 PROCEDURE get_wip_info_from_txn(
170 px_config_rec IN OUT nocopy config_rec);
171
172 PROCEDURE get_phantom_option_expl_flag(
173 p_option_expl_flag OUT NOCOPY VARCHAR2
174 );
175
176 PROCEDURE process_old_order_lines(
177 errbuf OUT NOCOPY varchar2,
178 retcode OUT NOCOPY number);
179
180 PROCEDURE update_profile(
181 errbuf OUT NOCOPY varchar2,
182 retcode OUT NOCOPY number);
183
184 PROCEDURE fulfill_wf(
185 itemtype IN VARCHAR2,
186 itemkey IN VARCHAR2,
187 actid IN NUMBER,
188 funcmode IN VARCHAR2,
189 resultout IN OUT NOCOPY VARCHAR2);
190
191 PROCEDURE cz_fulfillment(
192 p_order_line_id IN number,
193 x_return_status OUT NOCOPY varchar2,
194 x_return_message OUT NOCOPY varchar2);
195
196 /*----------------------------------------------------------*/
197 /* Procedure name: Construct_txn_dtls */
198 /* Description : Procedure to create txn line details */
199 /* if it does not exist */
200 /*----------------------------------------------------------*/
201
202 PROCEDURE Construct_txn_dtls(
203 x_order_shipment_tbl IN OUT NOCOPY csi_order_ship_pub.order_shipment_tbl,
204 p_order_line_rec IN csi_order_ship_pub.order_line_rec,
205 p_trackable_parent IN boolean,
206 x_trx_line_id OUT NOCOPY NUMBER,
207 x_return_status OUT NOCOPY VARCHAR2 );
208
209
210 PROCEDURE logical_drop_ship(
211 p_mtl_txn_id IN number,
212 p_message_id IN number,
213 x_return_status OUT NOCOPY varchar2,
214 px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec);
215
216 END csi_order_fulfill_pub;