[Home] [Help]
PACKAGE: APPS.CSI_ORDER_FULFILL_PUB
Source
1 PACKAGE csi_order_fulfill_pub AS
2 /* $Header: csipiofs.pls 120.1 2005/07/12 17:53:29 brmanesh noship $*/
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 get_all_ib_trackable_children(
115 p_model_line_id IN number,
116 p_om_vld_org_id IN number,
117 x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,
118 x_return_status OUT NOCOPY varchar2);
119
120 PROCEDURE get_ib_trackable_parent(
121 p_current_line_id IN number,
122 p_om_vld_org_id IN number,
123 x_parent_line_rec OUT NOCOPY oe_order_pub.line_rec_type,
124 x_return_status OUT NOCOPY varchar2);
125
126 PROCEDURE order_fulfillment(
127 p_order_line_id IN number,
128 p_message_id IN number,
129 x_return_status OUT NOCOPY varchar2,
130 px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec);
131
132 /* over loading this routine for XNC dependency, the signature change */
133 /* that affected the xnc_ib_wf.populate_ib routine */
134
135 PROCEDURE order_fulfillment(
136 p_order_line_id IN number,
137 p_message_id IN number,
138 x_return_status OUT NOCOPY varchar2,
139 x_error_message OUT NOCOPY varchar2);
140
141 PROCEDURE process_old_order_lines(
142 errbuf OUT NOCOPY varchar2,
143 retcode OUT NOCOPY number);
144
145 PROCEDURE update_profile(
146 errbuf OUT NOCOPY varchar2,
147 retcode OUT NOCOPY number);
148
149 PROCEDURE fulfill_wf(
150 itemtype IN VARCHAR2,
151 itemkey IN VARCHAR2,
152 actid IN NUMBER,
153 funcmode IN VARCHAR2,
154 resultout IN OUT NOCOPY VARCHAR2);
155
156 PROCEDURE cz_fulfillment(
157 p_order_line_id IN number,
158 x_return_status OUT NOCOPY varchar2,
159 x_return_message OUT NOCOPY varchar2);
160
161 /*----------------------------------------------------------*/
162 /* Procedure name: Construct_txn_dtls */
163 /* Description : Procedure to create txn line details */
164 /* if it does not exist */
165 /*----------------------------------------------------------*/
166
167 PROCEDURE Construct_txn_dtls(
168 x_order_shipment_tbl IN OUT NOCOPY csi_order_ship_pub.order_shipment_tbl,
169 p_order_line_rec IN csi_order_ship_pub.order_line_rec,
170 p_trackable_parent IN boolean,
171 x_trx_line_id OUT NOCOPY NUMBER,
172 x_return_status OUT NOCOPY VARCHAR2 );
173
174
175 PROCEDURE logical_drop_ship(
176 p_mtl_txn_id IN number,
177 p_message_id IN number,
178 x_return_status OUT NOCOPY varchar2,
179 px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec);
180
181 END csi_order_fulfill_pub;