[Home] [Help]
419:
420: PROCEDURE create_dflt_txn_dtls(
421: p_order_line_rec IN oe_order_lines_all%rowtype,
422: px_default_info_rec IN OUT nocopy default_info_rec,
423: x_txn_line_rec OUT nocopy csi_t_datastructures_grp.txn_line_rec,
424: x_tld_tbl OUT nocopy csi_t_datastructures_grp.txn_line_detail_tbl,
425: x_tiir_tbl OUT nocopy csi_t_datastructures_grp.txn_ii_rltns_tbl,
426: x_return_status OUT nocopy varchar2)
427: IS
420: PROCEDURE create_dflt_txn_dtls(
421: p_order_line_rec IN oe_order_lines_all%rowtype,
422: px_default_info_rec IN OUT nocopy default_info_rec,
423: x_txn_line_rec OUT nocopy csi_t_datastructures_grp.txn_line_rec,
424: x_tld_tbl OUT nocopy csi_t_datastructures_grp.txn_line_detail_tbl,
425: x_tiir_tbl OUT nocopy csi_t_datastructures_grp.txn_ii_rltns_tbl,
426: x_return_status OUT nocopy varchar2)
427: IS
428:
421: p_order_line_rec IN oe_order_lines_all%rowtype,
422: px_default_info_rec IN OUT nocopy default_info_rec,
423: x_txn_line_rec OUT nocopy csi_t_datastructures_grp.txn_line_rec,
424: x_tld_tbl OUT nocopy csi_t_datastructures_grp.txn_line_detail_tbl,
425: x_tiir_tbl OUT nocopy csi_t_datastructures_grp.txn_ii_rltns_tbl,
426: x_return_status OUT nocopy varchar2)
427: IS
428:
429: c_tl_rec csi_t_datastructures_grp.txn_line_rec;
425: x_tiir_tbl OUT nocopy csi_t_datastructures_grp.txn_ii_rltns_tbl,
426: x_return_status OUT nocopy varchar2)
427: IS
428:
429: c_tl_rec csi_t_datastructures_grp.txn_line_rec;
430: c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
431: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
432: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
433: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
426: x_return_status OUT nocopy varchar2)
427: IS
428:
429: c_tl_rec csi_t_datastructures_grp.txn_line_rec;
430: c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
431: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
432: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
433: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
434: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
427: IS
428:
429: c_tl_rec csi_t_datastructures_grp.txn_line_rec;
430: c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
431: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
432: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
433: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
434: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
435: c_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
428:
429: c_tl_rec csi_t_datastructures_grp.txn_line_rec;
430: c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
431: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
432: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
433: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
434: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
435: c_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
436: c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
429: c_tl_rec csi_t_datastructures_grp.txn_line_rec;
430: c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
431: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
432: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
433: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
434: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
435: c_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
436: c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
437:
430: c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
431: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
432: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
433: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
434: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
435: c_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
436: c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
437:
438: l_loop_count number := 1;
431: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
432: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
433: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
434: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
435: c_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
436: c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
437:
438: l_loop_count number := 1;
439: l_quantity number;
432: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
433: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
434: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
435: c_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
436: c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
437:
438: l_loop_count number := 1;
439: l_quantity number;
440:
1581: END get_txn_sub_type_id;
1582:
1583: /* This routine splits the transaction details in to quantity one each */
1584: PROCEDURE split_txn_dtls(
1585: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
1586: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
1587: x_return_status OUT NOCOPY varchar2)
1588: IS
1589: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1582:
1583: /* This routine splits the transaction details in to quantity one each */
1584: PROCEDURE split_txn_dtls(
1585: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
1586: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
1587: x_return_status OUT NOCOPY varchar2)
1588: IS
1589: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1590: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1585: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
1586: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
1587: x_return_status OUT NOCOPY varchar2)
1588: IS
1589: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1590: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1591:
1592: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1593: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1586: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
1587: x_return_status OUT NOCOPY varchar2)
1588: IS
1589: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1590: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1591:
1592: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1593: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1594: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1588: IS
1589: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1590: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1591:
1592: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1593: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1594: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1595: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1596: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1589: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1590: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1591:
1592: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1593: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1594: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1595: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1596: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1597: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1590: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1591:
1592: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1593: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1594: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1595: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1596: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1597: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1598: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1591:
1592: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1593: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1594: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1595: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1596: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1597: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1598: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1599: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1592: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1593: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1594: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1595: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1596: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1597: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1598: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1599: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1600: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1593: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1594: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1595: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1596: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1597: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1598: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1599: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1600: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1601: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1594: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1595: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1596: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1597: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1598: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1599: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1600: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1601: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1602:
1595: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1596: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1597: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1598: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1599: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1600: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1601: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1602:
1603: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1596: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1597: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1598: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1599: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1600: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1601: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1602:
1603: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1604: l_split_count number;
1597: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1598: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1599: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1600: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1601: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1602:
1603: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1604: l_split_count number;
1605:
1599: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1600: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1601: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1602:
1603: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1604: l_split_count number;
1605:
1606: l_c_pty_ind binary_integer;
1607: l_c_pa_ind binary_integer;
1735: END split_txn_dtls;
1736:
1737: PROCEDURE split_txn_dtls_with_ratio(
1738: p_quantity_ratio IN number,
1739: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1740: x_return_status OUT NOCOPY varchar2)
1741: IS
1742:
1743: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1739: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1740: x_return_status OUT NOCOPY varchar2)
1741: IS
1742:
1743: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1744: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1745:
1746: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1747: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1740: x_return_status OUT NOCOPY varchar2)
1741: IS
1742:
1743: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1744: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1745:
1746: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1747: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1748: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1742:
1743: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1744: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1745:
1746: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1747: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1748: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1749: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1750: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1743: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1744: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1745:
1746: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1747: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1748: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1749: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1750: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1751: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1744: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1745:
1746: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1747: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1748: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1749: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1750: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1751: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1752: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1745:
1746: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1747: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1748: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1749: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1750: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1751: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1752: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1753: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1746: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1747: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1748: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1749: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1750: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1751: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1752: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1753: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1754: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1747: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1748: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1749: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1750: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1751: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1752: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1753: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1754: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1755: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1748: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1749: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1750: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1751: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1752: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1753: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1754: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1755: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1756:
1749: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1750: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1751: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1752: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1753: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1754: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1755: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1756:
1757: l_td_quantity number;
1750: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1751: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1752: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1753: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1754: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1755: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1756:
1757: l_td_quantity number;
1758:
1751: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1752: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1753: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1754: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1755: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1756:
1757: l_td_quantity number;
1758:
1759: l_o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1755: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1756:
1757: l_td_quantity number;
1758:
1759: l_o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1760: l_o_ind binary_integer := 0;
1761:
1762: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1763: l_msg_count number;
2049: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
2050: l_g_time_stamp date;
2051:
2052: -- create_txn_line_dtls variables
2053: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2054: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2055: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2056: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2057: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2050: l_g_time_stamp date;
2051:
2052: -- create_txn_line_dtls variables
2053: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2054: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2055: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2056: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2057: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2058: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2051:
2052: -- create_txn_line_dtls variables
2053: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2054: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2055: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2056: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2057: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2058: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2059:
2052: -- create_txn_line_dtls variables
2053: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2054: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2055: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2056: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2057: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2058: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2059:
2060: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2053: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2054: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2055: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2056: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2057: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2058: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2059:
2060: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2061: l_msg_count number;
2054: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2055: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2056: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2057: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2058: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2059:
2060: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2061: l_msg_count number;
2062: l_msg_data varchar2(4000);
2158: p_source_table IN varchar2,
2159: p_source_id IN number,
2160: p_source_flag IN varchar2,
2161: p_processing_status IN varchar2,
2162: x_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2163: x_return_status OUT NOCOPY varchar2)
2164: IS
2165:
2166: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2162: x_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2163: x_return_status OUT NOCOPY varchar2)
2164: IS
2165:
2166: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2167: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2168:
2169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2163: x_return_status OUT NOCOPY varchar2)
2164: IS
2165:
2166: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2167: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2168:
2169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2165:
2166: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2167: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2168:
2169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2166: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2167: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2168:
2169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2167: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2168:
2169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2175: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2168:
2169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2175: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2176: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2175: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2176: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2177: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2175: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2176: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2177: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2178:
2171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2175: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2176: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2177: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2178:
2179: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2175: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2176: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2177: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2178:
2179: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2180: l_msg_data varchar2(2000);
2173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2175: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2176: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2177: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2178:
2179: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2180: l_msg_data varchar2(2000);
2181: l_msg_count number;
2437: PROCEDURE convert_wip_instance_to_cp(
2438: p_instance_id IN number,
2439: p_order_hdr_rec IN oe_order_headers_all%rowtype,
2440: p_order_line_rec IN oe_order_lines_all%rowtype,
2441: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
2442: px_default_info_rec IN OUT nocopy default_info_rec,
2443: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2444: x_return_status OUT NOCOPY varchar2)
2445: IS
2462: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2463: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2464: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2465:
2466: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2467: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2468: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2469: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2470: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2463: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2464: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2465:
2466: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2467: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2468: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2469: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2470: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2471: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2464: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2465:
2466: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2467: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2468: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2469: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2470: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2471: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2472: l_upd_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2465:
2466: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2467: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2468: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2469: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2470: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2471: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2472: l_upd_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2473: l_upd_order_line_rec csi_order_ship_pub.order_line_rec;
2466: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2467: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2468: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2469: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2470: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2471: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2472: l_upd_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2473: l_upd_order_line_rec csi_order_ship_pub.order_line_rec;
2474: l_tld_found VARCHAR2(1);
2467: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2468: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2469: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2470: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2471: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2472: l_upd_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2473: l_upd_order_line_rec csi_order_ship_pub.order_line_rec;
2474: l_tld_found VARCHAR2(1);
2475:
2468: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2469: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2470: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2471: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2472: l_upd_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2473: l_upd_order_line_rec csi_order_ship_pub.order_line_rec;
2474: l_tld_found VARCHAR2(1);
2475:
2476: l_instance_party_id number;
2496:
2497: -- Modification for bug 4091371
2498: PROCEDURE get_info_from_tld(
2499: p_instance_id IN number,
2500: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2501: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2502: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2503: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
2504: x_sub_type_id OUT nocopy number,
2497: -- Modification for bug 4091371
2498: PROCEDURE get_info_from_tld(
2499: p_instance_id IN number,
2500: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2501: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2502: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2503: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
2504: x_sub_type_id OUT nocopy number,
2505: x_cascade_owner_flag OUT nocopy varchar2,
2498: PROCEDURE get_info_from_tld(
2499: p_instance_id IN number,
2500: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2501: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2502: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2503: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
2504: x_sub_type_id OUT nocopy number,
2505: x_cascade_owner_flag OUT nocopy varchar2,
2506: x_tld_found OUT NOCOPY VARCHAR2 )
2499: p_instance_id IN number,
2500: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2501: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2502: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2503: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
2504: x_sub_type_id OUT nocopy number,
2505: x_cascade_owner_flag OUT nocopy varchar2,
2506: x_tld_found OUT NOCOPY VARCHAR2 )
2507: IS
2506: x_tld_found OUT NOCOPY VARCHAR2 )
2507: IS
2508: l_tld_found VARCHAR2(1) := fnd_api.g_false;
2509: l_txn_line_detail_id NUMBER;
2510: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2511: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2512: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2513: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2514: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2507: IS
2508: l_tld_found VARCHAR2(1) := fnd_api.g_false;
2509: l_txn_line_detail_id NUMBER;
2510: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2511: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2512: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2513: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2514: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2515: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2508: l_tld_found VARCHAR2(1) := fnd_api.g_false;
2509: l_txn_line_detail_id NUMBER;
2510: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2511: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2512: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2513: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2514: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2515: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2516: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2509: l_txn_line_detail_id NUMBER;
2510: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2511: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2512: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2513: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2514: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2515: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2516: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2517: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2510: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2511: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2512: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2513: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2514: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2515: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2516: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2517: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2518: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2511: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2512: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2513: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2514: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2515: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2516: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2517: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2518: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2519: l_msg_count number;
2512: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2513: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2514: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2515: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2516: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2517: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2518: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2519: l_msg_count number;
2520: l_msg_data varchar2(2000);
2513: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2514: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2515: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2516: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2517: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2518: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2519: l_msg_count number;
2520: l_msg_data varchar2(2000);
2521:
4108: l_config_instances config_serial_inst_tbl;
4109:
4110: l_order_hdr_rec oe_order_headers_all%rowtype;
4111: l_order_line_rec oe_order_lines_all%rowtype;
4112: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4113:
4114: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4115:
4116: BEGIN
4527: PROCEDURE stamp_om_line_for_options(
4528: p_order_hdr_rec IN oe_order_headers_all%rowtype,
4529: p_order_line_rec IN oe_order_lines_all%rowtype,
4530: p_wip_instances IN wip_instances,
4531: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4532: px_default_info_rec IN OUT nocopy default_info_rec,
4533: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4534: x_return_status OUT nocopy varchar2)
4535: IS
4761: x_return_status := fnd_api.g_ret_sts_error;
4762: END mark_and_get_config;
4763:
4764: PROCEDURE mark_and_get_src_tld(
4765: px_src_tld_tbl IN OUT nocopy csi_t_datastructures_grp.txn_line_detail_tbl,
4766: x_src_tld_rec OUT nocopy csi_t_datastructures_grp.txn_line_detail_rec,
4767: x_return_status OUT nocopy varchar2)
4768: IS
4769: px_ind binary_integer := 0;
4762: END mark_and_get_config;
4763:
4764: PROCEDURE mark_and_get_src_tld(
4765: px_src_tld_tbl IN OUT nocopy csi_t_datastructures_grp.txn_line_detail_tbl,
4766: x_src_tld_rec OUT nocopy csi_t_datastructures_grp.txn_line_detail_rec,
4767: x_return_status OUT nocopy varchar2)
4768: IS
4769: px_ind binary_integer := 0;
4770: BEGIN
5416: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5417: x_return_status OUT nocopy varchar2)
5418: IS
5419:
5420: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5421: l_temp_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5422:
5423: l_config_class_ratio number;
5424:
5417: x_return_status OUT nocopy varchar2)
5418: IS
5419:
5420: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5421: l_temp_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5422:
5423: l_config_class_ratio number;
5424:
5425: lp_ind binary_integer := 0;
5435:
5436: l_config_ns_tld_id number;
5437: l_sub_config_ns_tld_id number;
5438:
5439: l_oc_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5440:
5441: oct_ind binary_integer := 0;
5442: l_oc_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5443:
5438:
5439: l_oc_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5440:
5441: oct_ind binary_integer := 0;
5442: l_oc_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5443:
5444: l_ii_rltns_qry_rec csi_datastructures_pub.relationship_query_rec;
5445: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5446: l_temp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5457:
5458: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
5459: l_instance_id_lst csi_datastructures_pub.id_tbl;
5460:
5461: l_t_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5462: l_wip_processing boolean := FALSE;
5463: l_non_wip_child_line_tbl oe_order_pub.line_tbl_type;
5464: l_child_ind binary_integer := 0;
5465:
6202:
6203: -- child order line instances should get hooked in to the ib trackable parent order line
6204: PROCEDURE build_parent_relation(
6205: p_order_line_rec IN oe_order_lines_all%rowtype,
6206: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6207: p_split_flag IN varchar2,
6208: p_identified_item_type IN varchar2,
6209: p_config_rec IN config_rec,
6210: p_config_instances IN config_serial_inst_tbl,
6219:
6220: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6221: l_instance_tbl csi_datastructures_pub.instance_tbl;
6222:
6223: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6224: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6225:
6226: l_parent_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
6227: l_child_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
6220: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6221: l_instance_tbl csi_datastructures_pub.instance_tbl;
6222:
6223: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6224: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6225:
6226: l_parent_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
6227: l_child_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
6228: l_ns_tld_id number;
6223: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6224: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6225:
6226: l_parent_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
6227: l_child_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
6228: l_ns_tld_id number;
6229:
6230: l_qty_ratio number;
6231:
6613:
6614: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6615: l_instance_tbl csi_datastructures_pub.instance_tbl;
6616: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6617: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6618:
6619: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6620: l_object_id number;
6621: l_subject_id number;
6615: l_instance_tbl csi_datastructures_pub.instance_tbl;
6616: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6617: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6618:
6619: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6620: l_object_id number;
6621: l_subject_id number;
6622: l_ns_tld_id number;
6623:
6864:
6865: -- builds relation to the next level
6866: PROCEDURE build_child_relation(
6867: p_order_line_rec IN oe_order_lines_all%ROWTYPE,
6868: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6869: p_identified_item_type IN varchar2,
6870: px_default_info_rec IN OUT NOCOPY default_info_rec,
6871: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6872: x_return_status OUT NOCOPY varchar2)
6880: l_instance_tbl csi_datastructures_pub.instance_tbl;
6881: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6882:
6883:
6884: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6885:
6886: l_child_line_tbl oe_order_pub.line_tbl_type;
6887: l_grand_child_line_tbl oe_order_pub.line_tbl_type;
6888: l_qty_ratio number;
6893:
6894: l_ns_tld_id number;
6895: l_object_id number;
6896: l_subject_id number;
6897: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6898:
6899: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6900: l_msg_data varchar2(2000);
6901: l_msg_count number;
7149: PROCEDURE process_ato_option_nsrl(
7150: p_order_hdr_rec IN oe_order_headers_all%rowtype,
7151: p_order_line_rec IN oe_order_lines_all%rowtype,
7152: p_config_rec IN config_rec,
7153: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
7154: px_default_info_rec IN OUT nocopy default_info_rec,
7155: x_return_status OUT nocopy Varchar2)
7156: IS
7157:
7530: p_order_hdr_rec IN oe_order_headers_all%rowtype,
7531: p_order_line_rec IN oe_order_lines_all%rowtype,
7532: p_config_rec IN config_rec,
7533: p_config_instances IN config_serial_inst_tbl,
7534: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
7535: px_default_info_rec IN OUT nocopy default_info_rec,
7536: x_return_status OUT nocopy varchar2)
7537: IS
7538:
7883: IS
7884:
7885: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7886: l_wip_processing boolean := TRUE;
7887: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7888: l_transaction_line_id number;
7889: l_mdl_ordered_qty number;
7890: l_model_hierarchy varchar2(100);
7891: l_qty_ratio number; --declared for bug5096435
8031: x_return_status := fnd_api.g_ret_sts_error;
8032: END process_ato_option_from_wip;
8033:
8034: PROCEDURE get_source_tlds(
8035: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
8036: x_src_tld_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
8037: x_src_tld_total_qty OUT NOCOPY number)
8038: IS
8039: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8032: END process_ato_option_from_wip;
8033:
8034: PROCEDURE get_source_tlds(
8035: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
8036: x_src_tld_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
8037: x_src_tld_total_qty OUT NOCOPY number)
8038: IS
8039: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8040: l_src_ind binary_integer := 0;
8035: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
8036: x_src_tld_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
8037: x_src_tld_total_qty OUT NOCOPY number)
8038: IS
8039: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8040: l_src_ind binary_integer := 0;
8041: l_src_tld_total_qty number := 0;
8042: BEGIN
8043: IF p_tld_tbl.COUNT > 0 THEN
8058:
8059: PROCEDURE demo_fulfillment(
8060: p_txn_type_id IN number,
8061: p_order_line_rec IN oe_order_lines_all%rowtype,
8062: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
8063: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
8064: x_return_status OUT nocopy varchar2)
8065: IS
8066:
8065: IS
8066:
8067: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8068:
8069: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8070: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8071:
8072: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8073: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8066:
8067: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8068:
8069: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8070: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8071:
8072: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8073: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8074: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8068:
8069: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8070: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8071:
8072: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8073: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8074: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8075: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8076: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8069: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8070: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8071:
8072: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8073: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8074: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8075: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8076: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8077: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8070: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8071:
8072: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8073: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8074: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8075: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8076: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8077: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8078: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8071:
8072: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8073: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8074: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8075: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8076: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8077: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8078: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8079: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8072: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8073: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8074: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8075: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8076: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8077: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8078: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8079: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8080: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8073: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8074: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8075: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8076: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8077: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8078: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8079: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8080: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8081:
8074: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8075: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8076: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8077: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8078: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8079: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8080: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8081:
8082: l_instance_rec csi_datastructures_pub.instance_header_rec;
8075: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8076: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8077: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8078: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8079: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8080: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8081:
8082: l_instance_rec csi_datastructures_pub.instance_header_rec;
8083: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
8076: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8077: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8078: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8079: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8080: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8081:
8082: l_instance_rec csi_datastructures_pub.instance_header_rec;
8083: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
8084: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
8087: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8088: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
8089: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
8090:
8091: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8092: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8093: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8094: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8095: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8088: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
8089: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
8090:
8091: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8092: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8093: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8094: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8095: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8096: l_u_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8089: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
8090:
8091: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8092: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8093: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8094: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8095: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8096: l_u_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8097: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8090:
8091: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8092: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8093: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8094: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8095: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8096: l_u_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8097: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8098:
8091: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8092: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8093: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8094: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8095: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8096: l_u_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8097: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8098:
8099: l_time_stamp date;
8092: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8093: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8094: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8095: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8096: l_u_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8097: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8098:
8099: l_time_stamp date;
8100:
8093: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8094: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8095: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8096: l_u_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8097: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8098:
8099: l_time_stamp date;
8100:
8101: l_td_owner_id number;
8444: x_return_status OUT NOCOPY varchar2,
8445: x_return_message OUT NOCOPY varchar2)
8446: IS
8447:
8448: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8449: l_td_found boolean := FALSE;
8450:
8451: l_source_header_rec csi_interface_pkg.source_header_rec;
8452: l_source_line_rec csi_interface_pkg.source_line_rec;
8452: l_source_line_rec csi_interface_pkg.source_line_rec;
8453:
8454: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8455:
8456: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8457: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8458:
8459: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8460: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8453:
8454: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8455:
8456: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8457: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8458:
8459: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8460: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8461: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8455:
8456: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8457: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8458:
8459: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8460: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8461: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8462: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8463: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8456: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8457: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8458:
8459: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8460: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8461: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8462: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8463: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8464: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8457: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8458:
8459: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8460: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8461: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8462: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8463: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8464: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8465: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8458:
8459: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8460: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8461: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8462: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8463: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8464: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8465: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8466: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8459: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8460: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8461: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8462: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8463: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8464: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8465: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8466: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8467: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8460: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8461: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8462: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8463: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8464: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8465: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8466: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8467: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8468:
8461: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8462: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8463: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8464: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8465: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8466: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8467: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8468:
8469: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8462: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8463: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8464: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8465: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8466: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8467: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8468:
8469: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8470: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8463: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8464: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8465: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8466: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8467: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8468:
8469: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8470: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8471: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8465: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8466: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8467: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8468:
8469: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8470: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8471: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8472: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8473: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8466: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8467: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8468:
8469: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8470: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8471: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8472: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8473: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8474: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8467: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8468:
8469: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8470: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8471: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8472: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8473: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8474: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8475: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8468:
8469: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8470: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8471: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8472: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8473: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8474: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8475: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8476:
8469: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8470: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8471: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8472: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8473: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8474: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8475: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8476:
8477: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8470: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8471: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8472: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8473: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8474: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8475: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8476:
8477: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8478:
8471: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8472: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8473: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8474: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8475: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8476:
8477: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8478:
8479: -- Added this for unlock_item_instances
8696: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
8697: x_return_status OUT NOCOPY varchar2)
8698: IS
8699:
8700: l_tl_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8701: l_tld_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8702:
8703: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
8704:
8697: x_return_status OUT NOCOPY varchar2)
8698: IS
8699:
8700: l_tl_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8701: l_tld_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8702:
8703: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
8704:
8705: l_p_tl_rec csi_t_datastructures_grp.txn_line_rec;
8701: l_tld_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8702:
8703: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
8704:
8705: l_p_tl_rec csi_t_datastructures_grp.txn_line_rec;
8706:
8707: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8708: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8709: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8703: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
8704:
8705: l_p_tl_rec csi_t_datastructures_grp.txn_line_rec;
8706:
8707: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8708: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8709: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8710: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8711: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8704:
8705: l_p_tl_rec csi_t_datastructures_grp.txn_line_rec;
8706:
8707: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8708: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8709: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8710: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8711: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8712: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8705: l_p_tl_rec csi_t_datastructures_grp.txn_line_rec;
8706:
8707: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8708: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8709: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8710: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8711: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8712: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8713: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
8706:
8707: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8708: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8709: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8710: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8711: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8712: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8713: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
8714: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
8707: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8708: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8709: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8710: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8711: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8712: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8713: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
8714: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
8715: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8708: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8709: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8710: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8711: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8712: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8713: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
8714: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
8715: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8716: l_p_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8709: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8710: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8711: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8712: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8713: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
8714: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
8715: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8716: l_p_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8717:
8711: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8712: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8713: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
8714: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
8715: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8716: l_p_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8717:
8718: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8719: l_src_tld_total_qty number := 0;
8712: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8713: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
8714: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
8715: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8716: l_p_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8717:
8718: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8719: l_src_tld_total_qty number := 0;
8720:
8714: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
8715: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8716: l_p_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8717:
8718: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8719: l_src_tld_total_qty number := 0;
8720:
8721: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
8722: l_msg_count number;
9050:
9051: l_trk_child_tbl oe_order_pub.line_tbl_type;
9052: l_trk_parent_rec oe_order_pub.line_rec_type;
9053:
9054: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
9055: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
9056: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
9057: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
9058:
9051: l_trk_child_tbl oe_order_pub.line_tbl_type;
9052: l_trk_parent_rec oe_order_pub.line_rec_type;
9053:
9054: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
9055: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
9056: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
9057: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
9058:
9059: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9052: l_trk_parent_rec oe_order_pub.line_rec_type;
9053:
9054: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
9055: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
9056: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
9057: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
9058:
9059: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9060: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9055: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
9056: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
9057: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
9058:
9059: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9060: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9061: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9062: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9063: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9056: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
9057: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
9058:
9059: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9060: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9061: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9062: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9063: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9064: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9057: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
9058:
9059: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9060: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9061: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9062: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9063: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9064: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9065: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9058:
9059: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9060: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9061: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9062: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9063: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9064: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9065: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9066: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
9059: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9060: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9061: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9062: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9063: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9064: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9065: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9066: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
9067: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9060: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9061: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9062: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9063: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9064: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9065: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9066: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
9067: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9068:
9061: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9062: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9063: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9064: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9065: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9066: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
9067: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9068:
9069: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9062: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9063: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9064: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9065: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9066: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
9067: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9068:
9069: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9070: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9063: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9064: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9065: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9066: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
9067: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9068:
9069: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9070: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9071: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9065: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9066: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
9067: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9068:
9069: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9070: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9071: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9072: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9073: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9066: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
9067: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9068:
9069: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9070: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9071: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9072: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9073: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9074: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9067: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9068:
9069: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9070: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9071: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9072: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9073: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9074: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9075: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9068:
9069: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9070: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9071: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9072: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9073: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9074: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9075: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9076:
9069: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9070: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9071: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9072: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9073: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9074: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9075: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9076:
9077: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9070: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9071: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9072: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9073: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9074: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9075: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9076:
9077: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9078: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9071: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9072: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9073: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9074: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9075: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9076:
9077: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9078: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9079: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9073: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9074: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9075: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9076:
9077: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9078: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9079: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9080: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9081: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9074: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9075: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9076:
9077: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9078: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9079: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9080: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9081: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9082: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9075: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9076:
9077: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9078: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9079: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9080: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9081: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9082: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9083: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9076:
9077: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9078: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9079: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9080: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9081: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9082: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9083: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9084: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
9077: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9078: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9079: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9080: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9081: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9082: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9083: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9084: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
9085: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9078: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
9079: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9080: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9081: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9082: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9083: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9084: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
9085: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9086: l_p_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
9079: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9080: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9081: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9082: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9083: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9084: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
9085: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9086: l_p_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
9087:
9081: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9082: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9083: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9084: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
9085: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9086: l_p_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
9087:
9088: l_tmp_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9089: l_party_site_id number;
9082: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9083: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9084: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
9085: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9086: l_p_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
9087:
9088: l_tmp_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9089: l_party_site_id number;
9090: l_owner_party_id number;
9084: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
9085: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9086: l_p_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
9087:
9088: l_tmp_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9089: l_party_site_id number;
9090: l_owner_party_id number;
9091: l_owner_account_id number;
9092:
9142: l_msg_data varchar2(2000);
9143: l_msg_count number;
9144:
9145: ---Added (Start) for m-to-m enhancements
9146: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9147: ---Added (End) for m-to-m enhancements
9148:
9149: skip_regular_process exception;
9150: l_error_rec csi_datastructures_pub.transaction_error_rec;
9154: l_current_site_use_id number;
9155: l_install_site_use_id number;
9156:
9157: l_osp_vld_org_id number;
9158: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9159: l_src_tld_total_qty number := 0;
9160: --
9161: l_ul_txn_line_id NUMBER;
9162: l_ul_instance_rec csi_datastructures_pub.instance_rec;
10470: l_trx_line_id number;
10471: l_txn_line_rec_exists boolean := FALSE;
10472: l_create_txn_line_dtls boolean := TRUE;
10473:
10474: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;
10475:
10476: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
10477: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
10478: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
10472: l_create_txn_line_dtls boolean := TRUE;
10473:
10474: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;
10475:
10476: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
10477: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
10478: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
10479: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
10480: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
10473:
10474: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;
10475:
10476: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
10477: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
10478: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
10479: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
10480: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
10481: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
10474: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;
10475:
10476: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
10477: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
10478: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
10479: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
10480: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
10481: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
10482: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
10475:
10476: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
10477: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
10478: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
10479: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
10480: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
10481: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
10482: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
10483: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
10476: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
10477: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
10478: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
10479: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
10480: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
10481: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
10482: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
10483: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
10484:
10477: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
10478: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
10479: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
10480: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
10481: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
10482: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
10483: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
10484:
10485: l_continue boolean := TRUE;
10478: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
10479: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
10480: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
10481: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
10482: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
10483: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
10484:
10485: l_continue boolean := TRUE;
10486:
10479: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
10480: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
10481: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
10482: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
10483: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
10484:
10485: l_continue boolean := TRUE;
10486:
10487: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
10849: l_shipped_qty number;
10850: p_trackable_parent boolean;
10851: x_trx_line_id number;
10852:
10853: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
10854: l_trx_detail_exist boolean := FALSE;
10855: l_trx_rec csi_datastructures_pub.transaction_rec;
10856:
10857: l_exp_instance_rec csi_datastructures_pub.instance_rec;