120: p_source_id IN number,
121: p_source_header_rec IN source_header_rec,
122: p_source_line_rec IN source_line_rec,
123: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
124: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
125: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
126: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
127: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
128: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
121: p_source_header_rec IN source_header_rec,
122: p_source_line_rec IN source_line_rec,
123: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
124: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
125: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
126: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
127: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
128: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
129: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
122: p_source_line_rec IN source_line_rec,
123: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
124: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
125: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
126: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
127: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
128: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
129: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
130: x_return_status OUT NOCOPY varchar2);
123: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
124: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
125: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
126: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
127: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
128: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
129: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
130: x_return_status OUT NOCOPY varchar2);
131:
124: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
125: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
126: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
127: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
128: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
129: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
130: x_return_status OUT NOCOPY varchar2);
131:
132:
146: p_source_id IN number,
147: p_source_header_rec IN source_header_rec,
148: p_source_line_rec IN source_line_rec,
149: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
150: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
151: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
152: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
153: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
154: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
147: p_source_header_rec IN source_header_rec,
148: p_source_line_rec IN source_line_rec,
149: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
150: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
151: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
152: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
153: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
154: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
155: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
148: p_source_line_rec IN source_line_rec,
149: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
150: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
151: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
152: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
153: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
154: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
155: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
156: x_return_status OUT NOCOPY varchar2);
149: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
150: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
151: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
152: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
153: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
154: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
155: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
156: x_return_status OUT NOCOPY varchar2);
157:
150: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
151: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
152: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
153: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
154: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
155: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
156: x_return_status OUT NOCOPY varchar2);
157:
158:
157:
158:
159: PROCEDURE get_cz_txn_details(
160: p_config_session_key IN csi_utility_grp.config_session_key,
161: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
162: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
163: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
164: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
165: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
158:
159: PROCEDURE get_cz_txn_details(
160: p_config_session_key IN csi_utility_grp.config_session_key,
161: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
162: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
163: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
164: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
165: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
166: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
159: PROCEDURE get_cz_txn_details(
160: p_config_session_key IN csi_utility_grp.config_session_key,
161: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
162: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
163: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
164: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
165: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
166: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
167: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
160: p_config_session_key IN csi_utility_grp.config_session_key,
161: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
162: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
163: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
164: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
165: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
166: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
167: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
168: x_return_status OUT NOCOPY varchar2);
161: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
162: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
163: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
164: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
165: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
166: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
167: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
168: x_return_status OUT NOCOPY varchar2);
169:
162: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
163: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
164: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
165: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
166: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
167: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
168: x_return_status OUT NOCOPY varchar2);
169:
170: PROCEDURE get_config_keys_for_order(
163: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
164: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
165: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
166: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
167: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
168: x_return_status OUT NOCOPY varchar2);
169:
170: PROCEDURE get_config_keys_for_order(
171: p_header_id IN number,
174:
175: PROCEDURE get_cz_relations(
176: p_source_header_rec IN source_header_rec,
177: p_source_line_rec IN source_line_rec,
178: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
179: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
180: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
181: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
182: x_return_status OUT NOCOPY varchar2);
175: PROCEDURE get_cz_relations(
176: p_source_header_rec IN source_header_rec,
177: p_source_line_rec IN source_line_rec,
178: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
179: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
180: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
181: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
182: x_return_status OUT NOCOPY varchar2);
183:
176: p_source_header_rec IN source_header_rec,
177: p_source_line_rec IN source_line_rec,
178: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
179: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
180: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
181: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
182: x_return_status OUT NOCOPY varchar2);
183:
184: /* this routine takes the source line info and the current entered source txn
177: p_source_line_rec IN source_line_rec,
178: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
179: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
180: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
181: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
182: x_return_status OUT NOCOPY varchar2);
183:
184: /* this routine takes the source line info and the current entered source txn
185: line detail info and builds the non source relation based on the source table
199: p_source_id IN number,
200: p_source_table IN varchar2,
201: p_source_header_rec IN source_header_rec,
202: p_source_line_rec IN source_line_rec,
203: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
204: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
205: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
206: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
207: x_return_status OUT NOCOPY varchar2);
200: p_source_table IN varchar2,
201: p_source_header_rec IN source_header_rec,
202: p_source_line_rec IN source_line_rec,
203: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
204: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
205: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
206: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
207: x_return_status OUT NOCOPY varchar2);
208:
201: p_source_header_rec IN source_header_rec,
202: p_source_line_rec IN source_line_rec,
203: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
204: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
205: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
206: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
207: x_return_status OUT NOCOPY varchar2);
208:
209: PROCEDURE get_extended_attrib_values(
202: p_source_line_rec IN source_line_rec,
203: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
204: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
205: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
206: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
207: x_return_status OUT NOCOPY varchar2);
208:
209: PROCEDURE get_extended_attrib_values(
210: p_source_id IN number,
210: p_source_id IN number,
211: p_source_table IN varchar2,
212: p_source_header_rec IN source_header_rec,
213: p_source_line_rec IN source_line_rec,
214: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
215: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
216: x_return_status OUT NOCOPY varchar2);
217:
218: PROCEDURE get_order_line_source_info(
211: p_source_table IN varchar2,
212: p_source_header_rec IN source_header_rec,
213: p_source_line_rec IN source_line_rec,
214: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
215: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
216: x_return_status OUT NOCOPY varchar2);
217:
218: PROCEDURE get_order_line_source_info(
219: p_order_line_id IN number,
250: PROCEDURE interface_ib(
251: p_source_header_rec IN csi_interface_pkg.source_header_rec,
252: p_source_line_rec IN csi_interface_pkg.source_line_rec,
253: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
254: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
255: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
256: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
257: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
258: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
251: p_source_header_rec IN csi_interface_pkg.source_header_rec,
252: p_source_line_rec IN csi_interface_pkg.source_line_rec,
253: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
254: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
255: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
256: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
257: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
258: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
259: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
252: p_source_line_rec IN csi_interface_pkg.source_line_rec,
253: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
254: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
255: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
256: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
257: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
258: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
259: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
260: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
253: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
254: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
255: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
256: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
257: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
258: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
259: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
260: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
261: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
254: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
255: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
256: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
257: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
258: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
259: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
260: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
261: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
262: x_return_status OUT NOCOPY varchar2,
255: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
256: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
257: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
258: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
259: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
260: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
261: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
262: x_return_status OUT NOCOPY varchar2,
263: x_return_message OUT NOCOPY varchar2);
256: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
257: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
258: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
259: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
260: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
261: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
262: x_return_status OUT NOCOPY varchar2,
263: x_return_message OUT NOCOPY varchar2);
264:
326:
327: PROCEDURE sync_txn_dtl_and_mtl_txn(
328: p_mtl_txn_tbl IN mtl_txn_tbl,
329: p_item_attrib_rec IN item_attributes_rec,
330: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
331: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
332: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
333: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
334: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
327: PROCEDURE sync_txn_dtl_and_mtl_txn(
328: p_mtl_txn_tbl IN mtl_txn_tbl,
329: p_item_attrib_rec IN item_attributes_rec,
330: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
331: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
332: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
333: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
334: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
335: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
328: p_mtl_txn_tbl IN mtl_txn_tbl,
329: p_item_attrib_rec IN item_attributes_rec,
330: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
331: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
332: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
333: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
334: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
335: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
336: x_return_status OUT NOCOPY varchar2);
329: p_item_attrib_rec IN item_attributes_rec,
330: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
331: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
332: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
333: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
334: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
335: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
336: x_return_status OUT NOCOPY varchar2);
337:
330: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
331: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
332: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
333: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
334: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
335: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
336: x_return_status OUT NOCOPY varchar2);
337:
338: FUNCTION check_standard_bom_pc(
331: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
332: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
333: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
334: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
335: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
336: x_return_status OUT NOCOPY varchar2);
337:
338: FUNCTION check_standard_bom_pc(
339: p_instance_id IN NUMBER,
341: p_bom_item_type IN NUMBER)
342: RETURN boolean;
343:
344: PROCEDURE build_relationship_tbl(
345: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
346: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
347: x_c_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
348: x_u_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
349: x_return_status OUT NOCOPY varchar2);
342: RETURN boolean;
343:
344: PROCEDURE build_relationship_tbl(
345: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
346: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
347: x_c_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
348: x_u_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
349: x_return_status OUT NOCOPY varchar2);
350: