DBA Data[Home] [Help]

APPS.CSI_UTL_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 90: x_pricing_attb_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

86: p_txn_line_detail_id IN NUMBER) RETURN BOOLEAN;
87:
88: PROCEDURE Get_Pricing_Attribs(
89: p_line_id IN NUMBER,
90: x_pricing_attb_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
91: x_return_status OUT NOCOPY VARCHAR2 );
92:
93: PROCEDURE split_ship_rec(
94: x_upd_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl

Line 214: p_new_instance_tbl IN csi_datastructures_pub.instance_tbl,

210:
211: PROCEDURE build_inst_ii_tbl
212: ( p_orig_inst_id IN NUMBER,
213: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
214: p_new_instance_tbl IN csi_datastructures_pub.instance_tbl,
215: x_return_status OUT NOCOPY VARCHAR2);
216:
217: PROCEDURE update_txn_line_dtl
218: ( p_source_trx_id IN NUMBER,

Line 263: x_cre_systems_rec OUT NOCOPY csi_datastructures_pub.system_rec );

259:
260:
261: PROCEDURE get_system_tbl(
262: p_txn_systems_rec IN csi_t_datastructures_grp.txn_system_rec,
263: x_cre_systems_rec OUT NOCOPY csi_datastructures_pub.system_rec );
264:
265: PROCEDURE get_org_assignment_tbl(
266: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
267: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 268: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

264:
265: PROCEDURE get_org_assignment_tbl(
266: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
267: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
268: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
269: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
270: x_return_status OUT NOCOPY VARCHAR2 );
271:
272: PROCEDURE get_ext_attribs_tbl(

Line 269: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

265: PROCEDURE get_org_assignment_tbl(
266: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
267: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
268: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
269: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
270: x_return_status OUT NOCOPY VARCHAR2 );
271:
272: PROCEDURE get_ext_attribs_tbl(
273: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,

Line 275: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

271:
272: PROCEDURE get_ext_attribs_tbl(
273: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
274: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
275: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
276: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
277: x_return_status OUT NOCOPY VARCHAR2 );
278:
279: /* Added p_trx_rec for ER 2581101 */

Line 276: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

272: PROCEDURE get_ext_attribs_tbl(
273: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
274: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
275: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
276: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
277: x_return_status OUT NOCOPY VARCHAR2 );
278:
279: /* Added p_trx_rec for ER 2581101 */
280: PROCEDURE get_ii_relation_tbl(

Line 283: p_trx_rec IN csi_datastructures_pub.transaction_rec,

279: /* Added p_trx_rec for ER 2581101 */
280: PROCEDURE get_ii_relation_tbl(
281: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
282: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
283: p_trx_rec IN csi_datastructures_pub.transaction_rec,
284: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
285: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
286: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
287: x_return_status OUT NOCOPY VARCHAR2 );

Line 285: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

281: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
282: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
283: p_trx_rec IN csi_datastructures_pub.transaction_rec,
284: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
285: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
286: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
287: x_return_status OUT NOCOPY VARCHAR2 );
288:
289: PROCEDURE rebuild_tbls(

Line 286: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

282: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
283: p_trx_rec IN csi_datastructures_pub.transaction_rec,
284: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
285: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
286: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
287: x_return_status OUT NOCOPY VARCHAR2 );
288:
289: PROCEDURE rebuild_tbls(
290: p_new_instance_id IN NUMBER,

Line 291: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,

287: x_return_status OUT NOCOPY VARCHAR2 );
288:
289: PROCEDURE rebuild_tbls(
290: p_new_instance_id IN NUMBER,
291: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
292: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
293: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
294: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
295: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

Line 292: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,

288:
289: PROCEDURE rebuild_tbls(
290: p_new_instance_id IN NUMBER,
291: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
292: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
293: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
294: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
295: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
296: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

Line 293: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

289: PROCEDURE rebuild_tbls(
290: p_new_instance_id IN NUMBER,
291: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
292: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
293: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
294: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
295: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
296: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
297: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 294: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

290: p_new_instance_id IN NUMBER,
291: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
292: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
293: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
294: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
295: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
296: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
297: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
298: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,

Line 295: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

291: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
292: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
293: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
294: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
295: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
296: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
297: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
298: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
299: x_return_status OUT NOCOPY VARCHAR2 );

Line 296: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

292: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
293: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
294: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
295: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
296: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
297: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
298: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
299: x_return_status OUT NOCOPY VARCHAR2 );
300:

Line 318: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,

314: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
315: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
316: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
317: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
318: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
319: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
320: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
321: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
322: x_return_status OUT NOCOPY VARCHAR2);

Line 319: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

315: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
316: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
317: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
318: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
319: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
320: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
321: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
322: x_return_status OUT NOCOPY VARCHAR2);
323:

Line 320: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,

316: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
317: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
318: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
319: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
320: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
321: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
322: x_return_status OUT NOCOPY VARCHAR2);
323:
324: PROCEDURE make_non_header_tbl(

Line 321: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

317: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
318: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
319: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
320: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
321: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
322: x_return_status OUT NOCOPY VARCHAR2);
323:
324: PROCEDURE make_non_header_tbl(
325: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,

Line 325: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,

321: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
322: x_return_status OUT NOCOPY VARCHAR2);
323:
324: PROCEDURE make_non_header_tbl(
325: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,
326: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
327: x_return_status OUT NOCOPY varchar2);
328:
329: PROCEDURE call_contracts_chk(

Line 326: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,

322: x_return_status OUT NOCOPY VARCHAR2);
323:
324: PROCEDURE make_non_header_tbl(
325: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,
326: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
327: x_return_status OUT NOCOPY varchar2);
328:
329: PROCEDURE call_contracts_chk(
330: p_txn_line_detail_id in number,

Line 369: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

365:
366: PROCEDURE build_child_relation(
367: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
368: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
369: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
370: x_return_status OUT NOCOPY varchar2);
371:
372: PROCEDURE get_ib_trackable_children(
373: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

Line 381: p_trx_rec in csi_datastructures_pub.transaction_rec,

377: PROCEDURE amend_contracts(
378: p_relationship_type_code in varchar2,
379: p_object_instance_id in number,
380: p_subject_instance_id in number,
381: p_trx_rec in csi_datastructures_pub.transaction_rec,
382: x_return_status OUT NOCOPY varchar2);
383:
384: PROCEDURE get_parties_and_accounts(
385: p_instance_id IN number,

Line 389: p_owner_pty_rec IN csi_datastructures_pub.party_rec,

385: p_instance_id IN number,
386: p_tld_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
387: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
388: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
389: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
390: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
391: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
392: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
393: x_i_pty_acct_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,

Line 390: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,

386: p_tld_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
387: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
388: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
389: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
390: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
391: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
392: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
393: x_i_pty_acct_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,
394: x_return_status OUT nocopy varchar2);

Line 392: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,

388: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
389: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
390: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
391: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
392: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
393: x_i_pty_acct_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,
394: x_return_status OUT nocopy varchar2);
395:
396: PROCEDURE get_unit_price_in_primary_uom(

Line 393: x_i_pty_acct_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,

389: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
390: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
391: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
392: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
393: x_i_pty_acct_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,
394: x_return_status OUT nocopy varchar2);
395:
396: PROCEDURE get_unit_price_in_primary_uom(
397: p_unit_price IN number,