DBA Data[Home] [Help]

APPS.CSI_UTL_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 92: x_pricing_attb_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

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

Line 216: p_new_instance_tbl IN csi_datastructures_pub.instance_tbl,

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

Line 265: x_cre_systems_rec OUT NOCOPY csi_datastructures_pub.system_rec );

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

Line 270: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

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

Line 271: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

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

Line 277: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

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

Line 278: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

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

Line 285: p_trx_rec IN csi_datastructures_pub.transaction_rec,

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

Line 287: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

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

Line 288: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

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

Line 293: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,

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

Line 294: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,

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

Line 295: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

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

Line 296: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

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

Line 297: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

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

Line 298: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

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

Line 320: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,

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

Line 321: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

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

Line 322: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,

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

Line 323: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

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

Line 327: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,

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

Line 328: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,

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

Line 371: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

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

Line 383: p_trx_rec in csi_datastructures_pub.transaction_rec,

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

Line 391: p_owner_pty_rec IN csi_datastructures_pub.party_rec,

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

Line 392: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,

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

Line 394: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,

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

Line 395: x_i_pty_acct_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,

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