eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_INTERFACE_PKG dependencies on CSI_T_DATASTRUCTURES_GRP

Line 180: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

176: IS
177: l_trackable_parent_found boolean := FALSE;
178: l_parent_line_rec source_line_rec;
179: l_current_line_rec source_line_rec;
180: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
181: l_td_found boolean := FALSE;
182: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
183: BEGIN
184:

Line 408: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

404: --
405: PROCEDURE cascade_txn_detail(
406: p_parent_line_rec IN source_line_rec,
407: p_child_line_rec IN source_line_rec,
408: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
409: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
410: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
411: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
412: x_return_status OUT NOCOPY varchar2)

Line 409: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

405: PROCEDURE cascade_txn_detail(
406: p_parent_line_rec IN source_line_rec,
407: p_child_line_rec IN source_line_rec,
408: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
409: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
410: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
411: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
412: x_return_status OUT NOCOPY varchar2)
413: IS

Line 410: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

406: p_parent_line_rec IN source_line_rec,
407: p_child_line_rec IN source_line_rec,
408: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
409: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
410: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
411: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
412: x_return_status OUT NOCOPY varchar2)
413: IS
414:

Line 411: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

407: p_child_line_rec IN source_line_rec,
408: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
409: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
410: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
411: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
412: x_return_status OUT NOCOPY varchar2)
413: IS
414:
415: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 415: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

411: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
412: x_return_status OUT NOCOPY varchar2)
413: IS
414:
415: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
416: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
417:
418: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
419: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 416: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

412: x_return_status OUT NOCOPY varchar2)
413: IS
414:
415: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
416: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
417:
418: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
419: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
420: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 418: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

414:
415: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
416: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
417:
418: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
419: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
420: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
421: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
422: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 419: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

415: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
416: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
417:
418: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
419: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
420: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
421: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
422: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
423: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 420: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

416: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
417:
418: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
419: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
420: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
421: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
422: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
423: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
424: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 421: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

417:
418: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
419: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
420: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
421: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
422: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
423: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
424: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
425: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 422: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

418: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
419: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
420: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
421: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
422: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
423: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
424: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
425: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
426: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 423: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

419: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
420: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
421: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
422: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
423: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
424: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
425: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
426: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
427:

Line 424: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

420: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
421: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
422: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
423: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
424: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
425: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
426: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
427:
428: l_c_td_ind binary_integer;

Line 425: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

421: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
422: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
423: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
424: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
425: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
426: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
427:
428: l_c_td_ind binary_integer;
429: l_c_pt_ind binary_integer;

Line 426: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

422: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
423: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
424: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
425: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
426: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
427:
428: l_c_td_ind binary_integer;
429: l_c_pt_ind binary_integer;
430: l_c_pa_ind binary_integer;

Line 434: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

430: l_c_pa_ind binary_integer;
431: l_c_oa_ind binary_integer;
432: l_c_ea_ind binary_integer;
433:
434: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
435: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
436: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
437: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
438:

Line 435: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

431: l_c_oa_ind binary_integer;
432: l_c_ea_ind binary_integer;
433:
434: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
435: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
436: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
437: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
438:
439: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 436: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

432: l_c_ea_ind binary_integer;
433:
434: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
435: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
436: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
437: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
438:
439: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
440: l_msg_data varchar2(512);

Line 437: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

433:
434: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
435: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
436: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
437: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
438:
439: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
440: l_msg_data varchar2(512);
441: l_msg_count number;

Line 1003: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

999: p_transaction_type_id IN number,
1000: p_source_header_rec IN source_header_rec,
1001: p_source_line_rec IN source_line_rec,
1002: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1003: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1004: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1005: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1006: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1007: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 1004: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

1000: p_source_header_rec IN source_header_rec,
1001: p_source_line_rec IN source_line_rec,
1002: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1003: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1004: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1005: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1006: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1007: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1008: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 1005: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

1001: p_source_line_rec IN source_line_rec,
1002: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1003: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1004: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1005: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1006: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1007: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1008: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1009: x_return_status OUT NOCOPY varchar2)

Line 1006: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

1002: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1003: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1004: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1005: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1006: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1007: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1008: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1009: x_return_status OUT NOCOPY varchar2)
1010: IS

Line 1007: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

1003: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1004: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1005: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1006: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1007: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1008: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1009: x_return_status OUT NOCOPY varchar2)
1010: IS
1011:

Line 1251: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec, --bug 5194812, changed this param to IN OUT

1247: p_source_id IN number,
1248: p_source_header_rec IN source_header_rec,
1249: p_source_line_rec IN source_line_rec,
1250: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1251: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec, --bug 5194812, changed this param to IN OUT
1252: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1253: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1254: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1255: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 1252: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

1248: p_source_header_rec IN source_header_rec,
1249: p_source_line_rec IN source_line_rec,
1250: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1251: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec, --bug 5194812, changed this param to IN OUT
1252: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1253: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1254: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1255: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1256: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 1253: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

1249: p_source_line_rec IN source_line_rec,
1250: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1251: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec, --bug 5194812, changed this param to IN OUT
1252: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1253: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1254: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1255: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1256: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1257: x_return_status OUT NOCOPY varchar2)

Line 1254: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

1250: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1251: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec, --bug 5194812, changed this param to IN OUT
1252: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1253: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1254: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1255: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1256: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1257: x_return_status OUT NOCOPY varchar2)
1258: IS

Line 1255: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

1251: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec, --bug 5194812, changed this param to IN OUT
1252: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1253: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1254: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1255: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1256: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1257: x_return_status OUT NOCOPY varchar2)
1258: IS
1259:

Line 1271: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

1267: l_trackable_parent_found boolean := FALSE;
1268: l_parent_line_rec source_line_rec;
1269: l_child_order_line_tbl source_line_tbl;
1270:
1271: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1272: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1273:
1274: l_item_attributes_rec item_attributes_rec;
1275:

Line 1272: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

1268: l_parent_line_rec source_line_rec;
1269: l_child_order_line_tbl source_line_tbl;
1270:
1271: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1272: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1273:
1274: l_item_attributes_rec item_attributes_rec;
1275:
1276: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 1276: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

1272: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1273:
1274: l_item_attributes_rec item_attributes_rec;
1275:
1276: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1277: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1278: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1279: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1280: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 1277: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

1273:
1274: l_item_attributes_rec item_attributes_rec;
1275:
1276: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1277: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1278: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1279: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1280: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1281: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 1278: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

1274: l_item_attributes_rec item_attributes_rec;
1275:
1276: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1277: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1278: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1279: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1280: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1281: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 1279: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1275:
1276: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1277: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1278: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1279: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1280: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1281: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 1280: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

1276: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1277: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1278: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1279: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1280: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1281: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1284: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 1281: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

1277: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1278: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1279: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1280: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1281: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1284: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1285:

Line 1282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

1278: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1279: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1280: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1281: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1284: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1285:
1286: l_split_flag varchar2(1) := fnd_api.g_false;

Line 1283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

1279: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1280: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1281: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1284: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1285:
1286: l_split_flag varchar2(1) := fnd_api.g_false;
1287: l_split_quantity number := 1;

Line 1284: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

1280: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1281: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1284: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1285:
1286: l_split_flag varchar2(1) := fnd_api.g_false;
1287: l_split_quantity number := 1;
1288: l_split_loop number := 1;

Line 1503: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

1499: p_source_id IN number,
1500: p_source_header_rec IN source_header_rec,
1501: p_source_line_rec IN source_line_rec,
1502: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1503: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1504: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1505: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1506: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1507: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 1504: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

1500: p_source_header_rec IN source_header_rec,
1501: p_source_line_rec IN source_line_rec,
1502: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1503: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1504: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1505: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1506: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1507: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1508: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 1505: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

1501: p_source_line_rec IN source_line_rec,
1502: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1503: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1504: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1505: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1506: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1507: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1508: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1509: x_return_status OUT NOCOPY varchar2)

Line 1506: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

1502: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1503: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1504: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1505: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1506: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1507: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1508: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1509: x_return_status OUT NOCOPY varchar2)
1510: IS

Line 1507: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

1503: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1504: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1505: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1506: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1507: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1508: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1509: x_return_status OUT NOCOPY varchar2)
1510: IS
1511: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 1511: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

1507: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1508: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1509: x_return_status OUT NOCOPY varchar2)
1510: IS
1511: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1512: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1513: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1514: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1515: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 1512: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

1508: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1509: x_return_status OUT NOCOPY varchar2)
1510: IS
1511: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1512: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1513: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1514: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1515: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1516: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 1513: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

1509: x_return_status OUT NOCOPY varchar2)
1510: IS
1511: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1512: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1513: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1514: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1515: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1516: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1517: l_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 1514: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

1510: IS
1511: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1512: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1513: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1514: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1515: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1516: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1517: l_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1518:

Line 1515: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1511: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1512: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1513: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1514: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1515: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1516: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1517: l_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1518:
1519: l_return_status varchar2(1);

Line 1516: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

1512: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1513: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1514: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1515: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1516: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1517: l_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1518:
1519: l_return_status varchar2(1);
1520: l_msg_count number;

Line 1517: l_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

1513: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1514: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1515: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1516: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1517: l_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1518:
1519: l_return_status varchar2(1);
1520: l_msg_count number;
1521: l_msg_data varchar2(2000);

Line 1722: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

1718: --
1719: --
1720: PROCEDURE get_cz_txn_details(
1721: p_config_session_key IN csi_utility_grp.config_session_key,
1722: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1723: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1724: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1725: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1726: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 1723: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

1719: --
1720: PROCEDURE get_cz_txn_details(
1721: p_config_session_key IN csi_utility_grp.config_session_key,
1722: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1723: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1724: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1725: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1726: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1727: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 1724: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

1720: PROCEDURE get_cz_txn_details(
1721: p_config_session_key IN csi_utility_grp.config_session_key,
1722: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1723: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1724: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1725: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1726: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1727: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1728: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 1725: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

1721: p_config_session_key IN csi_utility_grp.config_session_key,
1722: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1723: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1724: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1725: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1726: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1727: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1728: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1729: x_return_status OUT NOCOPY varchar2)

Line 1726: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

1722: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1723: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1724: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1725: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1726: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1727: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1728: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1729: x_return_status OUT NOCOPY varchar2)
1730: IS

Line 1727: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

1723: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1724: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1725: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1726: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1727: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1728: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1729: x_return_status OUT NOCOPY varchar2)
1730: IS
1731:

Line 1728: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

1724: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1725: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1726: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1727: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1728: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1729: x_return_status OUT NOCOPY varchar2)
1730: IS
1731:
1732: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 1732: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

1728: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1729: x_return_status OUT NOCOPY varchar2)
1730: IS
1731:
1732: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1733: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1734:
1735: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1736: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 1733: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

1729: x_return_status OUT NOCOPY varchar2)
1730: IS
1731:
1732: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1733: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1734:
1735: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1736: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1737: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 1735: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

1731:
1732: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1733: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1734:
1735: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1736: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1737: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1738: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1739: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 1736: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

1732: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1733: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1734:
1735: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1736: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1737: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1738: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1739: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1740: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 1737: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

1733: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1734:
1735: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1736: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1737: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1738: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1739: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1740: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1741: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 1738: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1734:
1735: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1736: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1737: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1738: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1739: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1740: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1741: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1742: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 1739: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

1735: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1736: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1737: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1738: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1739: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1740: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1741: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1742: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1743: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 1740: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

1736: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1737: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1738: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1739: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1740: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1741: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1742: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1743: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1744:

Line 1741: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

1737: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1738: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1739: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1740: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1741: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1742: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1743: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1744:
1745: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 1742: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

1738: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1739: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1740: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1741: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1742: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1743: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1744:
1745: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1746: l_msg_data varchar2(512);

Line 1743: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

1739: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1740: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1741: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1742: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1743: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1744:
1745: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1746: l_msg_data varchar2(512);
1747: l_msg_count number;

Line 1887: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

1883: --
1884: --
1885: PROCEDURE get_all_txn_rltns_for_order(
1886: p_header_id IN number,
1887: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1888: x_return_status OUT NOCOPY varchar2)
1889: IS
1890:
1891: -- get_cz_txn_details variable

Line 1892: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

1888: x_return_status OUT NOCOPY varchar2)
1889: IS
1890:
1891: -- get_cz_txn_details variable
1892: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1893: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1894: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1895: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1896: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 1893: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

1889: IS
1890:
1891: -- get_cz_txn_details variable
1892: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1893: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1894: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1895: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1896: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1897: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 1894: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

1890:
1891: -- get_cz_txn_details variable
1892: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1893: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1894: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1895: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1896: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1897: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1898: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 1895: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

1891: -- get_cz_txn_details variable
1892: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1893: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1894: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1895: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1896: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1897: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1898: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1899:

Line 1896: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

1892: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1893: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1894: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1895: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1896: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1897: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1898: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1899:
1900: l_order_session_keys csi_utility_grp.config_session_keys;

Line 1897: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1893: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1894: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1895: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1896: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1897: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1898: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1899:
1900: l_order_session_keys csi_utility_grp.config_session_keys;
1901: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 1898: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

1894: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1895: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1896: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1897: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1898: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1899:
1900: l_order_session_keys csi_utility_grp.config_session_keys;
1901: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1902:

Line 1963: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

1959: --
1960: PROCEDURE filter_relations(
1961: p_instance_key IN csi_utility_grp.config_instance_key,
1962: p_transaction_line_id IN number,
1963: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1964: x_return_status OUT NOCOPY varchar2)
1965: IS
1966:
1967: l_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 1967: l_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1963: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1964: x_return_status OUT NOCOPY varchar2)
1965: IS
1966:
1967: l_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1968: l_new_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1969: l_o_ind binary_integer := 0;
1970: l_n_ind binary_integer := 0;
1971: l_subject_object_flag varchar2(1);

Line 1968: l_new_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1964: x_return_status OUT NOCOPY varchar2)
1965: IS
1966:
1967: l_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1968: l_new_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1969: l_o_ind binary_integer := 0;
1970: l_n_ind binary_integer := 0;
1971: l_subject_object_flag varchar2(1);
1972: l_instance_found boolean := FALSE;

Line 2140: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

2136: --
2137: PROCEDURE get_cz_relations(
2138: p_source_header_rec IN source_header_rec,
2139: p_source_line_rec IN source_line_rec,
2140: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2141: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2142: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2143: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2144: x_return_status OUT NOCOPY varchar2)

Line 2141: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

2137: PROCEDURE get_cz_relations(
2138: p_source_header_rec IN source_header_rec,
2139: p_source_line_rec IN source_line_rec,
2140: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2141: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2142: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2143: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2144: x_return_status OUT NOCOPY varchar2)
2145: IS

Line 2142: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

2138: p_source_header_rec IN source_header_rec,
2139: p_source_line_rec IN source_line_rec,
2140: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2141: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2142: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2143: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2144: x_return_status OUT NOCOPY varchar2)
2145: IS
2146:

Line 2143: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

2139: p_source_line_rec IN source_line_rec,
2140: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2141: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2142: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2143: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2144: x_return_status OUT NOCOPY varchar2)
2145: IS
2146:
2147: l_line_session_key csi_utility_grp.config_session_key;

Line 2150: l_src_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;

2146:
2147: l_line_session_key csi_utility_grp.config_session_key;
2148:
2149: l_src_instance_key csi_utility_grp.config_instance_key;
2150: l_src_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2151: l_src_tld_index binary_integer := 0;
2152: l_source_identified boolean := FALSE;
2153:
2154: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 2154: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

2150: l_src_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2151: l_src_tld_index binary_integer := 0;
2152: l_source_identified boolean := FALSE;
2153:
2154: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2155: l_n_td_ind binary_integer := 0;
2156:
2157: l_filtered_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2158:

Line 2157: l_filtered_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

2153:
2154: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2155: l_n_td_ind binary_integer := 0;
2156:
2157: l_filtered_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2158:
2159: -- get txn details variables
2160: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2161: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 2160: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

2156:
2157: l_filtered_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2158:
2159: -- get txn details variables
2160: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2161: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2162: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2163: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2164: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 2161: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

2157: l_filtered_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2158:
2159: -- get txn details variables
2160: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2161: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2162: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2163: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2164: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2165: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 2162: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

2158:
2159: -- get txn details variables
2160: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2161: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2162: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2163: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2164: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2165: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2166: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 2163: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

2159: -- get txn details variables
2160: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2161: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2162: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2163: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2164: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2165: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2166: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2167:

Line 2164: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

2160: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2161: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2162: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2163: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2164: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2165: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2166: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2167:
2168: l_ord_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 2165: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

2161: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2162: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2163: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2164: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2165: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2166: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2167:
2168: l_ord_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2169:

Line 2166: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

2162: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2163: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2164: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2165: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2166: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2167:
2168: l_ord_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2169:
2170: l_return_status varchar2(1);

Line 2168: l_ord_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

2164: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2165: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2166: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2167:
2168: l_ord_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2169:
2170: l_return_status varchar2(1);
2171: l_return_message varchar2(2000);
2172:

Line 2488: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

2484: --
2485: --
2486: PROCEDURE get_om_relations(
2487: p_source_line_rec IN source_line_rec,
2488: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2489: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2490: x_return_status OUT NOCOPY varchar2)
2491: IS
2492:

Line 2489: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

2485: --
2486: PROCEDURE get_om_relations(
2487: p_source_line_rec IN source_line_rec,
2488: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2489: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2490: x_return_status OUT NOCOPY varchar2)
2491: IS
2492:
2493: l_parent_found boolean := FALSE;

Line 2566: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

2562: p_source_id IN number,
2563: p_source_table IN varchar2,
2564: p_source_header_rec IN source_header_rec,
2565: p_source_line_rec IN source_line_rec,
2566: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2567: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2568: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2569: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2570: x_return_status OUT NOCOPY varchar2)

Line 2567: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

2563: p_source_table IN varchar2,
2564: p_source_header_rec IN source_header_rec,
2565: p_source_line_rec IN source_line_rec,
2566: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2567: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2568: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2569: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2570: x_return_status OUT NOCOPY varchar2)
2571: IS

Line 2568: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

2564: p_source_header_rec IN source_header_rec,
2565: p_source_line_rec IN source_line_rec,
2566: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2567: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2568: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2569: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2570: x_return_status OUT NOCOPY varchar2)
2571: IS
2572:

Line 2569: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

2565: p_source_line_rec IN source_line_rec,
2566: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2567: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2568: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2569: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2570: x_return_status OUT NOCOPY varchar2)
2571: IS
2572:
2573: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 2573: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

2569: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2570: x_return_status OUT NOCOPY varchar2)
2571: IS
2572:
2573: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2574: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2575:
2576: l_return_status varchar2(1);
2577: l_msg_count number;

Line 2574: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

2570: x_return_status OUT NOCOPY varchar2)
2571: IS
2572:
2573: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2574: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2575:
2576: l_return_status varchar2(1);
2577: l_msg_count number;
2578: l_msg_data varchar2(2000);

Line 2634: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

2630: p_source_id IN number,
2631: p_source_table IN varchar2,
2632: p_source_header_rec IN source_header_rec,
2633: p_source_line_rec IN source_line_rec,
2634: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2635: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2636: x_return_status OUT NOCOPY varchar2)
2637: IS
2638: BEGIN

Line 2635: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

2631: p_source_table IN varchar2,
2632: p_source_header_rec IN source_header_rec,
2633: p_source_line_rec IN source_line_rec,
2634: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2635: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2636: x_return_status OUT NOCOPY varchar2)
2637: IS
2638: BEGIN
2639: x_return_status := fnd_api.g_ret_sts_success;

Line 3240: p_txn_line_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,

3236: p_index IN binary_integer,
3237: p_source_line_rec IN csi_interface_pkg.source_line_rec,
3238: p_item_attrib_rec IN item_attributes_rec,
3239: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
3240: p_txn_line_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3241: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3242: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3243: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3244: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 3241: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

3237: p_source_line_rec IN csi_interface_pkg.source_line_rec,
3238: p_item_attrib_rec IN item_attributes_rec,
3239: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
3240: p_txn_line_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3241: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3242: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3243: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3244: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3245: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 3242: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

3238: p_item_attrib_rec IN item_attributes_rec,
3239: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
3240: p_txn_line_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3241: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3242: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3243: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3244: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3245: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3246: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,

Line 3243: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,

3239: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
3240: p_txn_line_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3241: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3242: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3243: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3244: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3245: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3246: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3247: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,

Line 3244: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

3240: p_txn_line_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3241: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3242: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3243: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3244: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3245: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3246: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3247: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
3248: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

Line 3956: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,

3952: x_return_status := fnd_api.g_ret_sts_error;
3953: END validate_and_derive_ids;
3954:
3955: PROCEDURE build_relationship_tbl(
3956: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
3957: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
3958: x_c_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3959: x_u_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3960: x_return_status OUT NOCOPY varchar2)

Line 3957: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

3953: END validate_and_derive_ids;
3954:
3955: PROCEDURE build_relationship_tbl(
3956: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
3957: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
3958: x_c_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3959: x_u_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3960: x_return_status OUT NOCOPY varchar2)
3961: IS

Line 3963: l_r_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

3959: x_u_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3960: x_return_status OUT NOCOPY varchar2)
3961: IS
3962:
3963: l_r_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3964: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3965:
3966: l_sub_instance_id number;
3967: l_obj_instance_id number;

Line 3964: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

3960: x_return_status OUT NOCOPY varchar2)
3961: IS
3962:
3963: l_r_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3964: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3965:
3966: l_sub_instance_id number;
3967: l_obj_instance_id number;
3968: l_rel_end_date date;

Line 4120: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,

4116: x_return_status := fnd_api.g_ret_sts_success;
4117: END build_relationship_tbl;
4118:
4119: PROCEDURE update_td_status(
4120: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
4121: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4122: p_processing_status IN varchar2,
4123: x_return_status OUT NOCOPY varchar2)
4124: IS

Line 4121: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

4117: END build_relationship_tbl;
4118:
4119: PROCEDURE update_td_status(
4120: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
4121: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4122: p_processing_status IN varchar2,
4123: x_return_status OUT NOCOPY varchar2)
4124: IS
4125:

Line 4126: l_tl_rec csi_t_datastructures_grp.txn_line_rec;

4122: p_processing_status IN varchar2,
4123: x_return_status OUT NOCOPY varchar2)
4124: IS
4125:
4126: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
4127: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4128: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4129: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4130: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 4127: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

4123: x_return_status OUT NOCOPY varchar2)
4124: IS
4125:
4126: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
4127: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4128: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4129: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4130: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4131: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 4128: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

4124: IS
4125:
4126: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
4127: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4128: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4129: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4130: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4131: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4132: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 4129: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

4125:
4126: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
4127: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4128: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4129: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4130: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4131: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4132: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4133:

Line 4130: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

4126: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
4127: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4128: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4129: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4130: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4131: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4132: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4133:
4134: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 4131: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

4127: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4128: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4129: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4130: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4131: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4132: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4133:
4134: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4135: l_msg_count number;

Line 4132: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

4128: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4129: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4130: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4131: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4132: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4133:
4134: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4135: l_msg_count number;
4136: l_msg_data varchar2(2000);

Line 4194: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

4190: PROCEDURE interface_ib(
4191: p_source_header_rec IN csi_interface_pkg.source_header_rec,
4192: p_source_line_rec IN csi_interface_pkg.source_line_rec,
4193: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4194: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4195: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4196: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4197: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4198: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 4195: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

4191: p_source_header_rec IN csi_interface_pkg.source_header_rec,
4192: p_source_line_rec IN csi_interface_pkg.source_line_rec,
4193: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4194: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4195: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4196: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4197: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4198: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4199: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 4196: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

4192: p_source_line_rec IN csi_interface_pkg.source_line_rec,
4193: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4194: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4195: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4196: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4197: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4198: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4199: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4200: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 4197: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

4193: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4194: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4195: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4196: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4197: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4198: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4199: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4200: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4201: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 4198: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

4194: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4195: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4196: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4197: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4198: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4199: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4200: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4201: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
4202: x_return_status OUT NOCOPY varchar2,

Line 4199: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

4195: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4196: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4197: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4198: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4199: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4200: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4201: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
4202: x_return_status OUT NOCOPY varchar2,
4203: x_return_message OUT NOCOPY varchar2)

Line 4200: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

4196: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4197: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4198: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4199: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4200: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4201: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
4202: x_return_status OUT NOCOPY varchar2,
4203: x_return_message OUT NOCOPY varchar2)
4204: IS

Line 4240: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

4236:
4237: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4238: l_u_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4239:
4240: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4241: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4242:
4243: -- explode bom variables
4244: l_bom_std_item_rec csi_datastructures_pub.instance_rec;

Line 4241: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

4237: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4238: l_u_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4239:
4240: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4241: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4242:
4243: -- explode bom variables
4244: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
4245: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;

Line 5716: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

5712: x_return_status := fnd_api.g_ret_sts_error;
5713: END decrement_inventory_instances;
5714:
5715: PROCEDURE initialize_txn_details(
5716: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5717: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5718: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5719: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5720: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 5717: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

5713: END decrement_inventory_instances;
5714:
5715: PROCEDURE initialize_txn_details(
5716: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5717: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5718: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5719: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5720: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5721: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 5718: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

5714:
5715: PROCEDURE initialize_txn_details(
5716: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5717: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5718: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5719: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5720: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5721: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5722: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)

Line 5719: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

5715: PROCEDURE initialize_txn_details(
5716: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5717: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5718: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5719: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5720: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5721: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5722: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)
5723: IS

Line 5720: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

5716: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5717: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5718: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5719: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5720: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5721: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5722: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)
5723: IS
5724: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 5721: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

5717: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5718: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5719: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5720: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5721: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5722: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)
5723: IS
5724: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5725: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 5722: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)

5718: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5719: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5720: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5721: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5722: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)
5723: IS
5724: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5725: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5726: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 5724: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

5720: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5721: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5722: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)
5723: IS
5724: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5725: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5726: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5727: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5728: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 5725: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5721: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5722: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)
5723: IS
5724: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5725: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5726: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5727: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5728: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5729: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 5726: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

5722: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)
5723: IS
5724: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5725: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5726: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5727: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5728: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5729: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5730: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 5727: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

5723: IS
5724: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5725: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5726: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5727: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5728: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5729: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5730: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5731: BEGIN

Line 5728: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

5724: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5725: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5726: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5727: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5728: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5729: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5730: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5731: BEGIN
5732: api_log('initialize_txn_details');

Line 5729: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

5725: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5726: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5727: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5728: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5729: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5730: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5731: BEGIN
5732: api_log('initialize_txn_details');
5733: px_txn_line_rec := l_txn_line_rec;

Line 5730: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

5726: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5727: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5728: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5729: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5730: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5731: BEGIN
5732: api_log('initialize_txn_details');
5733: px_txn_line_rec := l_txn_line_rec;
5734: px_txn_line_dtl_tbl := l_txn_line_dtl_tbl;

Line 5744: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

5740: END initialize_txn_details;
5741:
5742:
5743: PROCEDURE pre_process_txn_line_dtl(
5744: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5745: p_item_attrib_rec IN item_attributes_rec,
5746: x_return_status OUT NOCOPY varchar2)
5747: IS
5748: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 5748: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5744: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5745: p_item_attrib_rec IN item_attributes_rec,
5746: x_return_status OUT NOCOPY varchar2)
5747: IS
5748: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5749: BEGIN
5750: x_return_status := fnd_api.g_ret_sts_success;
5751: api_log('pre_process_txn_line_dtl');
5752: l_tld_tbl := px_txn_line_dtl_tbl;

Line 5783: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

5779: x_return_status := fnd_api.g_ret_sts_error;
5780: END pre_process_txn_line_dtl;
5781:
5782: PROCEDURE split_tld_one_each(
5783: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5784: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5785: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5786: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5787: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 5784: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

5780: END pre_process_txn_line_dtl;
5781:
5782: PROCEDURE split_tld_one_each(
5783: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5784: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5785: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5786: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5787: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5788: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 5785: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

5781:
5782: PROCEDURE split_tld_one_each(
5783: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5784: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5785: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5786: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5787: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5788: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5789: x_return_status OUT NOCOPY varchar2)

Line 5786: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

5782: PROCEDURE split_tld_one_each(
5783: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5784: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5785: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5786: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5787: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5788: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5789: x_return_status OUT NOCOPY varchar2)
5790: IS

Line 5787: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

5783: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5784: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5785: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5786: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5787: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5788: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5789: x_return_status OUT NOCOPY varchar2)
5790: IS
5791: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 5788: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

5784: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5785: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5786: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5787: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5788: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5789: x_return_status OUT NOCOPY varchar2)
5790: IS
5791: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5792: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 5791: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5787: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5788: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5789: x_return_status OUT NOCOPY varchar2)
5790: IS
5791: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5792: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5793: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5794: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5795: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 5792: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

5788: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5789: x_return_status OUT NOCOPY varchar2)
5790: IS
5791: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5792: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5793: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5794: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5795: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5796: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 5793: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

5789: x_return_status OUT NOCOPY varchar2)
5790: IS
5791: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5792: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5793: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5794: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5795: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5796: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5797:

Line 5794: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

5790: IS
5791: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5792: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5793: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5794: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5795: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5796: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5797:
5798: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 5795: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

5791: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5792: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5793: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5794: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5795: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5796: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5797:
5798: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5799: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 5796: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

5792: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5793: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5794: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5795: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5796: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5797:
5798: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5799: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5800: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 5798: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5794: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5795: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5796: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5797:
5798: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5799: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5800: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5801: s_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5802: s_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 5799: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

5795: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5796: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5797:
5798: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5799: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5800: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5801: s_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5802: s_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5803: s_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 5800: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

5796: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5797:
5798: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5799: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5800: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5801: s_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5802: s_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5803: s_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5804:

Line 5801: s_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

5797:
5798: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5799: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5800: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5801: s_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5802: s_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5803: s_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5804:
5805: l_tld_ind binary_integer := 0; -- new index

Line 5802: s_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

5798: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5799: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5800: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5801: s_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5802: s_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5803: s_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5804:
5805: l_tld_ind binary_integer := 0; -- new index
5806: l_pd_ind binary_integer := 0;

Line 5803: s_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

5799: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5800: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5801: s_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5802: s_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5803: s_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5804:
5805: l_tld_ind binary_integer := 0; -- new index
5806: l_pd_ind binary_integer := 0;
5807: l_pa_ind binary_integer := 0;

Line 5871: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

5867: END split_tld_one_each;
5868:
5869: PROCEDURE sync_serials(
5870: p_mtl_txn_tbl IN mtl_txn_tbl,
5871: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5872: x_return_status OUT NOCOPY varchar2)
5873: IS
5874: l_mtl_tbl mtl_txn_tbl;
5875: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 5875: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5871: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5872: x_return_status OUT NOCOPY varchar2)
5873: IS
5874: l_mtl_tbl mtl_txn_tbl;
5875: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5876: l_m_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5877: l_m_ind binary_integer := 0;
5878: BEGIN
5879: x_return_status := fnd_api.g_ret_sts_success;

Line 5876: l_m_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5872: x_return_status OUT NOCOPY varchar2)
5873: IS
5874: l_mtl_tbl mtl_txn_tbl;
5875: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5876: l_m_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5877: l_m_ind binary_integer := 0;
5878: BEGIN
5879: x_return_status := fnd_api.g_ret_sts_success;
5880: api_log('sync_serials');

Line 5977: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

5973: END sync_serials;
5974:
5975: PROCEDURE sync_lots(
5976: p_mtl_txn_tbl IN mtl_txn_tbl,
5977: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5978: x_return_status OUT NOCOPY varchar2)
5979: IS
5980: l_mtl_tbl mtl_txn_tbl;
5981: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 5981: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5977: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5978: x_return_status OUT NOCOPY varchar2)
5979: IS
5980: l_mtl_tbl mtl_txn_tbl;
5981: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5982: l_m_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5983: l_m_ind binary_integer := 0;
5984:
5985: t_n_ind binary_integer := 0;

Line 5982: l_m_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5978: x_return_status OUT NOCOPY varchar2)
5979: IS
5980: l_mtl_tbl mtl_txn_tbl;
5981: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5982: l_m_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5983: l_m_ind binary_integer := 0;
5984:
5985: t_n_ind binary_integer := 0;
5986: l_remain_qty number := 0;

Line 6117: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

6113:
6114: PROCEDURE sync_txn_dtl_and_mtl_txn(
6115: p_mtl_txn_tbl IN mtl_txn_tbl,
6116: p_item_attrib_rec IN item_attributes_rec,
6117: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6118: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6119: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6120: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
6121: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 6118: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

6114: PROCEDURE sync_txn_dtl_and_mtl_txn(
6115: p_mtl_txn_tbl IN mtl_txn_tbl,
6116: p_item_attrib_rec IN item_attributes_rec,
6117: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6118: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6119: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6120: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
6121: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
6122: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 6119: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

6115: p_mtl_txn_tbl IN mtl_txn_tbl,
6116: p_item_attrib_rec IN item_attributes_rec,
6117: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6118: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6119: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6120: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
6121: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
6122: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6123: x_return_status OUT NOCOPY varchar2)

Line 6120: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

6116: p_item_attrib_rec IN item_attributes_rec,
6117: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6118: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6119: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6120: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
6121: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
6122: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6123: x_return_status OUT NOCOPY varchar2)
6124: IS

Line 6121: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

6117: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6118: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6119: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6120: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
6121: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
6122: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6123: x_return_status OUT NOCOPY varchar2)
6124: IS
6125: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 6122: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

6118: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6119: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6120: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
6121: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
6122: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6123: x_return_status OUT NOCOPY varchar2)
6124: IS
6125: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6126: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 6125: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

6121: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
6122: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6123: x_return_status OUT NOCOPY varchar2)
6124: IS
6125: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6126: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6127: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6128: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6129: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 6126: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

6122: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6123: x_return_status OUT NOCOPY varchar2)
6124: IS
6125: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6126: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6127: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6128: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6129: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6130: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 6127: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

6123: x_return_status OUT NOCOPY varchar2)
6124: IS
6125: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6126: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6127: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6128: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6129: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6130: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6131: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 6128: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

6124: IS
6125: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6126: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6127: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6128: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6129: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6130: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6131: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6132: BEGIN

Line 6129: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

6125: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6126: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6127: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6128: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6129: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6130: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6131: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6132: BEGIN
6133: x_return_status := fnd_api.g_ret_sts_success;

Line 6130: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

6126: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6127: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6128: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6129: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6130: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6131: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6132: BEGIN
6133: x_return_status := fnd_api.g_ret_sts_success;
6134: api_log('sync_txn_dtl_and_mtl_txn');

Line 6205: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

6201:
6202:
6203: PROCEDURE default_owner_pty_and_acct(
6204: p_instance_id IN number,
6205: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6206: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6207: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6208: x_return_status OUT NOCOPY varchar2)
6209: IS

Line 6206: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

6202:
6203: PROCEDURE default_owner_pty_and_acct(
6204: p_instance_id IN number,
6205: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6206: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6207: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6208: x_return_status OUT NOCOPY varchar2)
6209: IS
6210: l_owner_party_acct_id number;

Line 6207: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

6203: PROCEDURE default_owner_pty_and_acct(
6204: p_instance_id IN number,
6205: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6206: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6207: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6208: x_return_status OUT NOCOPY varchar2)
6209: IS
6210: l_owner_party_acct_id number;
6211: l_owner_party_id number;

Line 6291: l_tl_rec csi_t_datastructures_grp.txn_line_rec;

6287: l_src_instance_key csi_utility_grp.config_instance_key;
6288:
6289: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6290:
6291: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
6292: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6293: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6294: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6295: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 6292: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

6288:
6289: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6290:
6291: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
6292: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6293: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6294: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6295: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6296: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 6293: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

6289: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6290:
6291: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
6292: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6293: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6294: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6295: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6296: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6297: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 6294: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

6290:
6291: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
6292: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6293: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6294: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6295: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6296: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6297: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6298: l_pr_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 6295: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

6291: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
6292: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6293: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6294: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6295: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6296: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6297: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6298: l_pr_tbl csi_datastructures_pub.pricing_attribs_tbl;
6299: l_sy_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 6296: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

6292: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6293: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6294: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6295: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6296: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6297: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6298: l_pr_tbl csi_datastructures_pub.pricing_attribs_tbl;
6299: l_sy_tbl csi_t_datastructures_grp.txn_systems_tbl;
6300:

Line 6297: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

6293: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6294: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6295: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6296: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6297: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6298: l_pr_tbl csi_datastructures_pub.pricing_attribs_tbl;
6299: l_sy_tbl csi_t_datastructures_grp.txn_systems_tbl;
6300:
6301: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 6299: l_sy_tbl csi_t_datastructures_grp.txn_systems_tbl;

6295: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6296: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6297: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6298: l_pr_tbl csi_datastructures_pub.pricing_attribs_tbl;
6299: l_sy_tbl csi_t_datastructures_grp.txn_systems_tbl;
6300:
6301: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6302: l_return_message varchar2(2000);
6303: