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 975: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

971: p_transaction_type_id IN number,
972: p_source_header_rec IN source_header_rec,
973: p_source_line_rec IN source_line_rec,
974: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
975: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
976: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
977: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
978: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
979: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 976: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

972: p_source_header_rec IN source_header_rec,
973: p_source_line_rec IN source_line_rec,
974: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
975: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
976: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
977: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
978: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
979: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
980: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 977: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

973: p_source_line_rec IN source_line_rec,
974: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
975: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
976: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
977: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
978: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
979: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
980: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
981: x_return_status OUT NOCOPY varchar2)

Line 978: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

974: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
975: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
976: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
977: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
978: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
979: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
980: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
981: x_return_status OUT NOCOPY varchar2)
982: IS

Line 979: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

975: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
976: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
977: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
978: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
979: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
980: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
981: x_return_status OUT NOCOPY varchar2)
982: IS
983:

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

1218: p_source_id IN number,
1219: p_source_header_rec IN source_header_rec,
1220: p_source_line_rec IN source_line_rec,
1221: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1222: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec, --bug 5194812, changed this param to IN OUT
1223: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1224: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1225: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1226: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 1223: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

1219: p_source_header_rec IN source_header_rec,
1220: p_source_line_rec IN source_line_rec,
1221: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1222: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec, --bug 5194812, changed this param to IN OUT
1223: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1224: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1225: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1226: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1227: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 1224: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

1220: p_source_line_rec IN source_line_rec,
1221: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1222: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec, --bug 5194812, changed this param to IN OUT
1223: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1224: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1225: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1226: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1227: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1228: x_return_status OUT NOCOPY varchar2)

Line 1225: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

1221: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1222: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec, --bug 5194812, changed this param to IN OUT
1223: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1224: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1225: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1226: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1227: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1228: x_return_status OUT NOCOPY varchar2)
1229: IS

Line 1226: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

1222: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec, --bug 5194812, changed this param to IN OUT
1223: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1224: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1225: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1226: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1227: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1228: x_return_status OUT NOCOPY varchar2)
1229: IS
1230:

Line 1242: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

1238: l_trackable_parent_found boolean := FALSE;
1239: l_parent_line_rec source_line_rec;
1240: l_child_order_line_tbl source_line_tbl;
1241:
1242: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1243: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1244:
1245: l_item_attributes_rec item_attributes_rec;
1246:

Line 1243: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

1239: l_parent_line_rec source_line_rec;
1240: l_child_order_line_tbl source_line_tbl;
1241:
1242: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1243: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1244:
1245: l_item_attributes_rec item_attributes_rec;
1246:
1247: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 1247: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

1243: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1244:
1245: l_item_attributes_rec item_attributes_rec;
1246:
1247: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1248: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1249: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1250: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1251: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 1248: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

1244:
1245: l_item_attributes_rec item_attributes_rec;
1246:
1247: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1248: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1249: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1250: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1251: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1252: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 1249: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

1245: l_item_attributes_rec item_attributes_rec;
1246:
1247: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1248: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1249: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1250: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1251: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1252: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1253: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 1250: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1246:
1247: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1248: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1249: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1250: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1251: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1252: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1253: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1254: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 1251: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

1247: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1248: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1249: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1250: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1251: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1252: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1253: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1254: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1255: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 1252: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

1248: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1249: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1250: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1251: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1252: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1253: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1254: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1255: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1256:

Line 1253: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

1249: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1250: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1251: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1252: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1253: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1254: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1255: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1256:
1257: l_split_flag varchar2(1) := fnd_api.g_false;

Line 1254: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

1250: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1251: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1252: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1253: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1254: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1255: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1256:
1257: l_split_flag varchar2(1) := fnd_api.g_false;
1258: l_split_quantity number := 1;

Line 1255: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

1251: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1252: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1253: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1254: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1255: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1256:
1257: l_split_flag varchar2(1) := fnd_api.g_false;
1258: l_split_quantity number := 1;
1259: l_split_loop number := 1;

Line 1474: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

1470: p_source_id IN number,
1471: p_source_header_rec IN source_header_rec,
1472: p_source_line_rec IN source_line_rec,
1473: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1474: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1475: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1476: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1477: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1478: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 1475: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

1471: p_source_header_rec IN source_header_rec,
1472: p_source_line_rec IN source_line_rec,
1473: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1474: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1475: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1476: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1477: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1478: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1479: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 1476: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

1472: p_source_line_rec IN source_line_rec,
1473: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1474: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1475: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1476: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1477: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1478: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1479: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1480: x_return_status OUT NOCOPY varchar2)

Line 1477: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

1473: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1474: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1475: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1476: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1477: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1478: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1479: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1480: x_return_status OUT NOCOPY varchar2)
1481: IS

Line 1478: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

1474: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1475: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1476: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1477: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1478: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1479: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1480: x_return_status OUT NOCOPY varchar2)
1481: IS
1482: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 1482: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

1478: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1479: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1480: x_return_status OUT NOCOPY varchar2)
1481: IS
1482: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1483: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1484: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1485: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1486: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 1483: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

1479: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1480: x_return_status OUT NOCOPY varchar2)
1481: IS
1482: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1483: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1484: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1485: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1486: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1487: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 1484: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

1480: x_return_status OUT NOCOPY varchar2)
1481: IS
1482: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1483: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1484: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1485: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1486: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1487: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1488: l_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 1485: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

1481: IS
1482: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1483: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1484: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1485: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1486: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1487: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1488: l_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1489:

Line 1486: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1482: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1483: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1484: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1485: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1486: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1487: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1488: l_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1489:
1490: l_return_status varchar2(1);

Line 1487: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

1483: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1484: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1485: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1486: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1487: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1488: l_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1489:
1490: l_return_status varchar2(1);
1491: l_msg_count number;

Line 1488: l_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

1484: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1485: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1486: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1487: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1488: l_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1489:
1490: l_return_status varchar2(1);
1491: l_msg_count number;
1492: l_msg_data varchar2(2000);

Line 1693: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

1689: --
1690: --
1691: PROCEDURE get_cz_txn_details(
1692: p_config_session_key IN csi_utility_grp.config_session_key,
1693: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1694: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1695: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1696: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1697: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 1694: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

1690: --
1691: PROCEDURE get_cz_txn_details(
1692: p_config_session_key IN csi_utility_grp.config_session_key,
1693: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1694: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1695: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1696: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1697: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1698: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 1695: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

1691: PROCEDURE get_cz_txn_details(
1692: p_config_session_key IN csi_utility_grp.config_session_key,
1693: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1694: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1695: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1696: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1697: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1698: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1699: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 1696: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

1692: p_config_session_key IN csi_utility_grp.config_session_key,
1693: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1694: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1695: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1696: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1697: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1698: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1699: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1700: x_return_status OUT NOCOPY varchar2)

Line 1697: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

1693: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1694: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1695: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1696: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1697: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1698: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1699: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1700: x_return_status OUT NOCOPY varchar2)
1701: IS

Line 1698: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

1694: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1695: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1696: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1697: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1698: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1699: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1700: x_return_status OUT NOCOPY varchar2)
1701: IS
1702:

Line 1699: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

1695: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1696: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1697: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1698: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1699: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1700: x_return_status OUT NOCOPY varchar2)
1701: IS
1702:
1703: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 1703: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

1699: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1700: x_return_status OUT NOCOPY varchar2)
1701: IS
1702:
1703: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1704: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1705:
1706: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1707: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 1704: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

1700: x_return_status OUT NOCOPY varchar2)
1701: IS
1702:
1703: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1704: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1705:
1706: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1707: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1708: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 1706: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

1702:
1703: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1704: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1705:
1706: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1707: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1708: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1709: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1710: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 1707: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

1703: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1704: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1705:
1706: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1707: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1708: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1709: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1710: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1711: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 1708: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

1704: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1705:
1706: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1707: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1708: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1709: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1710: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1711: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1712: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 1709: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1705:
1706: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1707: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1708: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1709: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1710: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1711: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1712: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1713: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 1710: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

1706: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1707: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1708: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1709: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1710: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1711: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1712: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1713: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1714: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 1711: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

1707: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1708: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1709: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1710: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1711: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1712: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1713: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1714: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1715:

Line 1712: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

1708: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1709: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1710: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1711: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1712: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1713: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1714: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1715:
1716: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 1713: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

1709: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1710: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1711: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1712: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1713: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1714: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1715:
1716: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1717: l_msg_data varchar2(512);

Line 1714: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

1710: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1711: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1712: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1713: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1714: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1715:
1716: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1717: l_msg_data varchar2(512);
1718: l_msg_count number;

Line 1858: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

1854: --
1855: --
1856: PROCEDURE get_all_txn_rltns_for_order(
1857: p_header_id IN number,
1858: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1859: x_return_status OUT NOCOPY varchar2)
1860: IS
1861:
1862: -- get_cz_txn_details variable

Line 1863: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

1859: x_return_status OUT NOCOPY varchar2)
1860: IS
1861:
1862: -- get_cz_txn_details variable
1863: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1864: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1865: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1866: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1867: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 1864: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

1860: IS
1861:
1862: -- get_cz_txn_details variable
1863: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1864: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1865: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1866: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1867: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1868: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 1865: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

1861:
1862: -- get_cz_txn_details variable
1863: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1864: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1865: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1866: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1867: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1868: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1869: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 1866: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

1862: -- get_cz_txn_details variable
1863: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1864: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1865: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1866: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1867: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1868: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1869: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1870:

Line 1867: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

1863: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1864: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1865: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1866: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1867: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1868: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1869: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1870:
1871: l_order_session_keys csi_utility_grp.config_session_keys;

Line 1868: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1864: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1865: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1866: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1867: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1868: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1869: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1870:
1871: l_order_session_keys csi_utility_grp.config_session_keys;
1872: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 1869: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

1865: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1866: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1867: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1868: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1869: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1870:
1871: l_order_session_keys csi_utility_grp.config_session_keys;
1872: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1873:

Line 1934: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

1930: --
1931: PROCEDURE filter_relations(
1932: p_instance_key IN csi_utility_grp.config_instance_key,
1933: p_transaction_line_id IN number,
1934: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1935: x_return_status OUT NOCOPY varchar2)
1936: IS
1937:
1938: l_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 1938: l_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1934: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1935: x_return_status OUT NOCOPY varchar2)
1936: IS
1937:
1938: l_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1939: l_new_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1940: l_o_ind binary_integer := 0;
1941: l_n_ind binary_integer := 0;
1942: l_subject_object_flag varchar2(1);

Line 1939: l_new_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1935: x_return_status OUT NOCOPY varchar2)
1936: IS
1937:
1938: l_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1939: l_new_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1940: l_o_ind binary_integer := 0;
1941: l_n_ind binary_integer := 0;
1942: l_subject_object_flag varchar2(1);
1943: l_instance_found boolean := FALSE;

Line 2111: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

2107: --
2108: PROCEDURE get_cz_relations(
2109: p_source_header_rec IN source_header_rec,
2110: p_source_line_rec IN source_line_rec,
2111: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2112: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2113: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2114: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2115: x_return_status OUT NOCOPY varchar2)

Line 2112: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

2108: PROCEDURE get_cz_relations(
2109: p_source_header_rec IN source_header_rec,
2110: p_source_line_rec IN source_line_rec,
2111: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2112: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2113: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2114: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2115: x_return_status OUT NOCOPY varchar2)
2116: IS

Line 2113: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

2109: p_source_header_rec IN source_header_rec,
2110: p_source_line_rec IN source_line_rec,
2111: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2112: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2113: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2114: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2115: x_return_status OUT NOCOPY varchar2)
2116: IS
2117:

Line 2114: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

2110: p_source_line_rec IN source_line_rec,
2111: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2112: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2113: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2114: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2115: x_return_status OUT NOCOPY varchar2)
2116: IS
2117:
2118: l_line_session_key csi_utility_grp.config_session_key;

Line 2121: l_src_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;

2117:
2118: l_line_session_key csi_utility_grp.config_session_key;
2119:
2120: l_src_instance_key csi_utility_grp.config_instance_key;
2121: l_src_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2122: l_src_tld_index binary_integer := 0;
2123: l_source_identified boolean := FALSE;
2124:
2125: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 2125: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

2121: l_src_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2122: l_src_tld_index binary_integer := 0;
2123: l_source_identified boolean := FALSE;
2124:
2125: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2126: l_n_td_ind binary_integer := 0;
2127:
2128: l_filtered_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2129:

Line 2128: l_filtered_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

2124:
2125: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2126: l_n_td_ind binary_integer := 0;
2127:
2128: l_filtered_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2129:
2130: -- get txn details variables
2131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2132: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 2131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

2127:
2128: l_filtered_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2129:
2130: -- get txn details variables
2131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2132: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2133: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2134: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2135: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 2132: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

2128: l_filtered_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2129:
2130: -- get txn details variables
2131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2132: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2133: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2134: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2135: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 2133: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

2129:
2130: -- get txn details variables
2131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2132: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2133: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2134: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2135: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2137: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 2134: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

2130: -- get txn details variables
2131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2132: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2133: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2134: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2135: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2137: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2138:

Line 2135: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

2131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2132: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2133: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2134: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2135: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2137: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2138:
2139: l_ord_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 2136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

2132: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2133: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2134: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2135: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2137: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2138:
2139: l_ord_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2140:

Line 2137: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

2133: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2134: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2135: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2137: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2138:
2139: l_ord_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2140:
2141: l_return_status varchar2(1);

Line 2139: l_ord_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

2135: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2137: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2138:
2139: l_ord_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2140:
2141: l_return_status varchar2(1);
2142: l_return_message varchar2(2000);
2143:

Line 2454: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

2450: --
2451: --
2452: PROCEDURE get_om_relations(
2453: p_source_line_rec IN source_line_rec,
2454: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2455: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2456: x_return_status OUT NOCOPY varchar2)
2457: IS
2458:

Line 2455: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

2451: --
2452: PROCEDURE get_om_relations(
2453: p_source_line_rec IN source_line_rec,
2454: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2455: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2456: x_return_status OUT NOCOPY varchar2)
2457: IS
2458:
2459: l_parent_found boolean := FALSE;

Line 2532: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

2528: p_source_id IN number,
2529: p_source_table IN varchar2,
2530: p_source_header_rec IN source_header_rec,
2531: p_source_line_rec IN source_line_rec,
2532: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2533: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2534: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2535: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2536: x_return_status OUT NOCOPY varchar2)

Line 2533: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

2529: p_source_table IN varchar2,
2530: p_source_header_rec IN source_header_rec,
2531: p_source_line_rec IN source_line_rec,
2532: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2533: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2534: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2535: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2536: x_return_status OUT NOCOPY varchar2)
2537: IS

Line 2534: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

2530: p_source_header_rec IN source_header_rec,
2531: p_source_line_rec IN source_line_rec,
2532: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2533: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2534: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2535: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2536: x_return_status OUT NOCOPY varchar2)
2537: IS
2538:

Line 2535: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

2531: p_source_line_rec IN source_line_rec,
2532: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2533: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2534: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2535: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2536: x_return_status OUT NOCOPY varchar2)
2537: IS
2538:
2539: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 2539: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

2535: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2536: x_return_status OUT NOCOPY varchar2)
2537: IS
2538:
2539: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2540: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2541:
2542: l_return_status varchar2(1);
2543: l_msg_count number;

Line 2540: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

2536: x_return_status OUT NOCOPY varchar2)
2537: IS
2538:
2539: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2540: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2541:
2542: l_return_status varchar2(1);
2543: l_msg_count number;
2544: l_msg_data varchar2(2000);

Line 2600: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

2596: p_source_id IN number,
2597: p_source_table IN varchar2,
2598: p_source_header_rec IN source_header_rec,
2599: p_source_line_rec IN source_line_rec,
2600: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2601: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2602: x_return_status OUT NOCOPY varchar2)
2603: IS
2604: BEGIN

Line 2601: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

2597: p_source_table IN varchar2,
2598: p_source_header_rec IN source_header_rec,
2599: p_source_line_rec IN source_line_rec,
2600: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2601: x_txn_eav_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2602: x_return_status OUT NOCOPY varchar2)
2603: IS
2604: BEGIN
2605: x_return_status := fnd_api.g_ret_sts_success;

Line 3205: p_txn_line_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,

3201: PROCEDURE build_instance_set(
3202: p_index IN binary_integer,
3203: p_source_line_rec IN csi_interface_pkg.source_line_rec,
3204: p_item_attrib_rec IN item_attributes_rec,
3205: p_txn_line_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3206: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3207: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3208: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3209: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 3206: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

3202: p_index IN binary_integer,
3203: p_source_line_rec IN csi_interface_pkg.source_line_rec,
3204: p_item_attrib_rec IN item_attributes_rec,
3205: p_txn_line_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3206: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3207: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3208: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3209: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3210: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 3207: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

3203: p_source_line_rec IN csi_interface_pkg.source_line_rec,
3204: p_item_attrib_rec IN item_attributes_rec,
3205: p_txn_line_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3206: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3207: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3208: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3209: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3210: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3211: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,

Line 3208: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,

3204: p_item_attrib_rec IN item_attributes_rec,
3205: p_txn_line_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3206: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3207: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3208: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3209: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3210: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3211: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3212: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,

Line 3209: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

3205: p_txn_line_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3206: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3207: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3208: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3209: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3210: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3211: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3212: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
3213: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

Line 3864: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,

3860: x_return_status := fnd_api.g_ret_sts_error;
3861: END validate_and_derive_ids;
3862:
3863: PROCEDURE build_relationship_tbl(
3864: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
3865: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
3866: x_c_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3867: x_u_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3868: x_return_status OUT NOCOPY varchar2)

Line 3865: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

3861: END validate_and_derive_ids;
3862:
3863: PROCEDURE build_relationship_tbl(
3864: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
3865: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
3866: x_c_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3867: x_u_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3868: x_return_status OUT NOCOPY varchar2)
3869: IS

Line 3871: l_r_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

3867: x_u_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3868: x_return_status OUT NOCOPY varchar2)
3869: IS
3870:
3871: l_r_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3872: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3873:
3874: l_sub_instance_id number;
3875: l_obj_instance_id number;

Line 3872: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

3868: x_return_status OUT NOCOPY varchar2)
3869: IS
3870:
3871: l_r_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3872: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3873:
3874: l_sub_instance_id number;
3875: l_obj_instance_id number;
3876: l_rel_end_date date;

Line 4028: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,

4024: x_return_status := fnd_api.g_ret_sts_success;
4025: END build_relationship_tbl;
4026:
4027: PROCEDURE update_td_status(
4028: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
4029: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4030: p_processing_status IN varchar2,
4031: x_return_status OUT NOCOPY varchar2)
4032: IS

Line 4029: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

4025: END build_relationship_tbl;
4026:
4027: PROCEDURE update_td_status(
4028: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
4029: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4030: p_processing_status IN varchar2,
4031: x_return_status OUT NOCOPY varchar2)
4032: IS
4033:

Line 4034: l_tl_rec csi_t_datastructures_grp.txn_line_rec;

4030: p_processing_status IN varchar2,
4031: x_return_status OUT NOCOPY varchar2)
4032: IS
4033:
4034: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
4035: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4036: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4037: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4038: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 4035: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

4031: x_return_status OUT NOCOPY varchar2)
4032: IS
4033:
4034: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
4035: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4036: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4037: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4038: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4039: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 4036: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

4032: IS
4033:
4034: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
4035: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4036: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4037: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4038: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4039: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4040: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 4037: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

4033:
4034: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
4035: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4036: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4037: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4038: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4039: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4040: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4041:

Line 4038: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

4034: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
4035: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4036: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4037: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4038: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4039: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4040: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4041:
4042: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 4039: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

4035: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4036: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4037: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4038: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4039: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4040: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4041:
4042: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4043: l_msg_count number;

Line 4040: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

4036: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4037: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4038: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4039: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4040: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4041:
4042: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4043: l_msg_count number;
4044: l_msg_data varchar2(2000);

Line 4102: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

4098: PROCEDURE interface_ib(
4099: p_source_header_rec IN csi_interface_pkg.source_header_rec,
4100: p_source_line_rec IN csi_interface_pkg.source_line_rec,
4101: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4102: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4103: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4104: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4105: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4106: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 4103: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

4099: p_source_header_rec IN csi_interface_pkg.source_header_rec,
4100: p_source_line_rec IN csi_interface_pkg.source_line_rec,
4101: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4102: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4103: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4104: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4105: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4106: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4107: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 4104: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

4100: p_source_line_rec IN csi_interface_pkg.source_line_rec,
4101: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4102: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4103: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4104: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4105: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4106: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4107: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4108: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 4105: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

4101: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4102: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4103: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4104: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4105: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4106: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4107: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4108: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4109: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 4106: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

4102: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4103: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4104: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4105: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4106: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4107: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4108: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4109: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
4110: x_return_status OUT NOCOPY varchar2,

Line 4107: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

4103: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4104: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4105: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4106: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4107: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4108: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4109: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
4110: x_return_status OUT NOCOPY varchar2,
4111: x_return_message OUT NOCOPY varchar2)

Line 4108: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

4104: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4105: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4106: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4107: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4108: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4109: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
4110: x_return_status OUT NOCOPY varchar2,
4111: x_return_message OUT NOCOPY varchar2)
4112: IS

Line 4148: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

4144:
4145: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4146: l_u_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4147:
4148: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4149: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4150:
4151: -- explode bom variables
4152: l_bom_std_item_rec csi_datastructures_pub.instance_rec;

Line 4149: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

4145: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4146: l_u_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4147:
4148: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4149: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4150:
4151: -- explode bom variables
4152: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
4153: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;

Line 5609: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

5605: x_return_status := fnd_api.g_ret_sts_error;
5606: END decrement_inventory_instances;
5607:
5608: PROCEDURE initialize_txn_details(
5609: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5610: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5611: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5612: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5613: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 5610: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

5606: END decrement_inventory_instances;
5607:
5608: PROCEDURE initialize_txn_details(
5609: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5610: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5611: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5612: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5613: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5614: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 5611: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

5607:
5608: PROCEDURE initialize_txn_details(
5609: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5610: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5611: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5612: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5613: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5614: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5615: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)

Line 5612: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

5608: PROCEDURE initialize_txn_details(
5609: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5610: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5611: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5612: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5613: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5614: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5615: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)
5616: IS

Line 5613: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

5609: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5610: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5611: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5612: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5613: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5614: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5615: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)
5616: IS
5617: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 5614: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

5610: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5611: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5612: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5613: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5614: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5615: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)
5616: IS
5617: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5618: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 5615: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)

5611: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5612: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5613: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5614: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5615: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)
5616: IS
5617: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5618: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5619: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 5617: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

5613: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5614: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5615: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)
5616: IS
5617: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5618: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5619: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5620: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5621: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 5618: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5614: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5615: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)
5616: IS
5617: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5618: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5619: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5620: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5621: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5622: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 5619: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

5615: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl)
5616: IS
5617: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5618: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5619: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5620: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5621: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5622: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5623: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 5620: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

5616: IS
5617: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5618: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5619: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5620: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5621: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5622: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5623: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5624: BEGIN

Line 5621: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

5617: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5618: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5619: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5620: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5621: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5622: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5623: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5624: BEGIN
5625: api_log('initialize_txn_details');

Line 5622: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

5618: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5619: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5620: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5621: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5622: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5623: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5624: BEGIN
5625: api_log('initialize_txn_details');
5626: px_txn_line_rec := l_txn_line_rec;

Line 5623: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

5619: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5620: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5621: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5622: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5623: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5624: BEGIN
5625: api_log('initialize_txn_details');
5626: px_txn_line_rec := l_txn_line_rec;
5627: px_txn_line_dtl_tbl := l_txn_line_dtl_tbl;

Line 5637: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

5633: END initialize_txn_details;
5634:
5635:
5636: PROCEDURE pre_process_txn_line_dtl(
5637: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5638: p_item_attrib_rec IN item_attributes_rec,
5639: x_return_status OUT NOCOPY varchar2)
5640: IS
5641: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 5641: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5637: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5638: p_item_attrib_rec IN item_attributes_rec,
5639: x_return_status OUT NOCOPY varchar2)
5640: IS
5641: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5642: BEGIN
5643: x_return_status := fnd_api.g_ret_sts_success;
5644: api_log('pre_process_txn_line_dtl');
5645: l_tld_tbl := px_txn_line_dtl_tbl;

Line 5676: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

5672: x_return_status := fnd_api.g_ret_sts_error;
5673: END pre_process_txn_line_dtl;
5674:
5675: PROCEDURE split_tld_one_each(
5676: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5677: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5678: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5679: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5680: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 5677: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

5673: END pre_process_txn_line_dtl;
5674:
5675: PROCEDURE split_tld_one_each(
5676: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5677: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5678: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5679: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5680: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5681: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 5678: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

5674:
5675: PROCEDURE split_tld_one_each(
5676: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5677: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5678: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5679: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5680: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5681: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5682: x_return_status OUT NOCOPY varchar2)

Line 5679: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

5675: PROCEDURE split_tld_one_each(
5676: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5677: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5678: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5679: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5680: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5681: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5682: x_return_status OUT NOCOPY varchar2)
5683: IS

Line 5680: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

5676: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5677: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5678: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5679: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5680: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5681: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5682: x_return_status OUT NOCOPY varchar2)
5683: IS
5684: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 5681: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

5677: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5678: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5679: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5680: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5681: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5682: x_return_status OUT NOCOPY varchar2)
5683: IS
5684: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5685: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 5684: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5680: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5681: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5682: x_return_status OUT NOCOPY varchar2)
5683: IS
5684: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5685: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5686: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5687: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5688: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 5685: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

5681: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5682: x_return_status OUT NOCOPY varchar2)
5683: IS
5684: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5685: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5686: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5687: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5688: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5689: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 5686: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

5682: x_return_status OUT NOCOPY varchar2)
5683: IS
5684: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5685: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5686: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5687: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5688: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5689: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5690:

Line 5687: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

5683: IS
5684: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5685: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5686: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5687: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5688: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5689: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5690:
5691: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 5688: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

5684: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5685: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5686: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5687: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5688: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5689: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5690:
5691: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5692: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 5689: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

5685: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5686: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5687: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5688: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5689: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5690:
5691: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5692: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5693: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 5691: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5687: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5688: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5689: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5690:
5691: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5692: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5693: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5694: s_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5695: s_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 5692: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

5688: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5689: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5690:
5691: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5692: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5693: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5694: s_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5695: s_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5696: s_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 5693: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

5689: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5690:
5691: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5692: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5693: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5694: s_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5695: s_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5696: s_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5697:

Line 5694: s_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

5690:
5691: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5692: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5693: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5694: s_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5695: s_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5696: s_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5697:
5698: l_tld_ind binary_integer := 0; -- new index

Line 5695: s_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

5691: s_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5692: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5693: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5694: s_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5695: s_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5696: s_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5697:
5698: l_tld_ind binary_integer := 0; -- new index
5699: l_pd_ind binary_integer := 0;

Line 5696: s_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

5692: s_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5693: s_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5694: s_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5695: s_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5696: s_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5697:
5698: l_tld_ind binary_integer := 0; -- new index
5699: l_pd_ind binary_integer := 0;
5700: l_pa_ind binary_integer := 0;

Line 5764: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

5760: END split_tld_one_each;
5761:
5762: PROCEDURE sync_serials(
5763: p_mtl_txn_tbl IN mtl_txn_tbl,
5764: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5765: x_return_status OUT NOCOPY varchar2)
5766: IS
5767: l_mtl_tbl mtl_txn_tbl;
5768: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 5768: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5764: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5765: x_return_status OUT NOCOPY varchar2)
5766: IS
5767: l_mtl_tbl mtl_txn_tbl;
5768: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5769: l_m_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5770: l_m_ind binary_integer := 0;
5771: BEGIN
5772: x_return_status := fnd_api.g_ret_sts_success;

Line 5769: l_m_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5765: x_return_status OUT NOCOPY varchar2)
5766: IS
5767: l_mtl_tbl mtl_txn_tbl;
5768: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5769: l_m_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5770: l_m_ind binary_integer := 0;
5771: BEGIN
5772: x_return_status := fnd_api.g_ret_sts_success;
5773: api_log('sync_serials');

Line 5870: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

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

Line 5874: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

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

Line 5875: l_m_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5871: x_return_status OUT NOCOPY varchar2)
5872: IS
5873: l_mtl_tbl mtl_txn_tbl;
5874: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5875: l_m_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5876: l_m_ind binary_integer := 0;
5877:
5878: t_n_ind binary_integer := 0;
5879: l_remain_qty number := 0;

Line 6010: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

6006:
6007: PROCEDURE sync_txn_dtl_and_mtl_txn(
6008: p_mtl_txn_tbl IN mtl_txn_tbl,
6009: p_item_attrib_rec IN item_attributes_rec,
6010: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6011: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6012: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6013: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
6014: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 6011: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

6007: PROCEDURE sync_txn_dtl_and_mtl_txn(
6008: p_mtl_txn_tbl IN mtl_txn_tbl,
6009: p_item_attrib_rec IN item_attributes_rec,
6010: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6011: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6012: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6013: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
6014: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
6015: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 6012: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

6008: p_mtl_txn_tbl IN mtl_txn_tbl,
6009: p_item_attrib_rec IN item_attributes_rec,
6010: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6011: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6012: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6013: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
6014: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
6015: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6016: x_return_status OUT NOCOPY varchar2)

Line 6013: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

6009: p_item_attrib_rec IN item_attributes_rec,
6010: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6011: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6012: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6013: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
6014: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
6015: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6016: x_return_status OUT NOCOPY varchar2)
6017: IS

Line 6014: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

6010: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6011: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6012: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6013: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
6014: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
6015: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6016: x_return_status OUT NOCOPY varchar2)
6017: IS
6018: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 6015: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

6011: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6012: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6013: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
6014: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
6015: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6016: x_return_status OUT NOCOPY varchar2)
6017: IS
6018: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6019: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 6018: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

6014: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
6015: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6016: x_return_status OUT NOCOPY varchar2)
6017: IS
6018: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6019: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6020: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6021: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6022: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 6019: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

6015: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6016: x_return_status OUT NOCOPY varchar2)
6017: IS
6018: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6019: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6020: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6021: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6022: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6023: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 6020: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

6016: x_return_status OUT NOCOPY varchar2)
6017: IS
6018: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6019: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6020: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6021: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6022: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6023: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6024: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 6021: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

6017: IS
6018: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6019: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6020: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6021: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6022: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6023: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6024: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6025: BEGIN

Line 6022: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

6018: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6019: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6020: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6021: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6022: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6023: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6024: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6025: BEGIN
6026: x_return_status := fnd_api.g_ret_sts_success;

Line 6023: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

6019: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6020: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6021: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6022: l_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6023: l_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6024: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6025: BEGIN
6026: x_return_status := fnd_api.g_ret_sts_success;
6027: api_log('sync_txn_dtl_and_mtl_txn');

Line 6098: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

6094:
6095:
6096: PROCEDURE default_owner_pty_and_acct(
6097: p_instance_id IN number,
6098: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6099: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6100: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6101: x_return_status OUT NOCOPY varchar2)
6102: IS

Line 6099: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

6095:
6096: PROCEDURE default_owner_pty_and_acct(
6097: p_instance_id IN number,
6098: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6099: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6100: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6101: x_return_status OUT NOCOPY varchar2)
6102: IS
6103: l_owner_party_acct_id number;

Line 6100: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

6096: PROCEDURE default_owner_pty_and_acct(
6097: p_instance_id IN number,
6098: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6099: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
6100: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
6101: x_return_status OUT NOCOPY varchar2)
6102: IS
6103: l_owner_party_acct_id number;
6104: l_owner_party_id number;

Line 6184: l_tl_rec csi_t_datastructures_grp.txn_line_rec;

6180: l_src_instance_key csi_utility_grp.config_instance_key;
6181:
6182: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6183:
6184: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
6185: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6186: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6187: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6188: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 6185: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

6181:
6182: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6183:
6184: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
6185: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6186: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6187: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6188: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6189: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 6186: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

6182: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6183:
6184: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
6185: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6186: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6187: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6188: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6189: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6190: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 6187: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

6183:
6184: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
6185: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6186: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6187: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6188: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6189: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6190: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6191: l_pr_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 6188: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

6184: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
6185: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6186: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6187: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6188: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6189: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6190: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6191: l_pr_tbl csi_datastructures_pub.pricing_attribs_tbl;
6192: l_sy_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 6189: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

6185: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6186: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6187: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6188: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6189: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6190: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6191: l_pr_tbl csi_datastructures_pub.pricing_attribs_tbl;
6192: l_sy_tbl csi_t_datastructures_grp.txn_systems_tbl;
6193:

Line 6190: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

6186: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6187: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6188: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6189: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6190: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6191: l_pr_tbl csi_datastructures_pub.pricing_attribs_tbl;
6192: l_sy_tbl csi_t_datastructures_grp.txn_systems_tbl;
6193:
6194: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 6192: l_sy_tbl csi_t_datastructures_grp.txn_systems_tbl;

6188: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6189: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6190: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6191: l_pr_tbl csi_datastructures_pub.pricing_attribs_tbl;
6192: l_sy_tbl csi_t_datastructures_grp.txn_systems_tbl;
6193:
6194: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6195: l_return_message varchar2(2000);
6196: