APPS.CSI_ORDER_FULFILL_PUB dependencies on CSI_T_DATASTRUCTURES_GRP

Line 400: x_txn_line_rec OUT nocopy csi_t_datastructures_grp.txn_line_rec,

396:
397: PROCEDURE create_dflt_txn_dtls(
398: p_order_line_rec IN oe_order_lines_all%rowtype,
399: px_default_info_rec IN OUT nocopy default_info_rec,
400: x_txn_line_rec OUT nocopy csi_t_datastructures_grp.txn_line_rec,
401: x_tld_tbl OUT nocopy csi_t_datastructures_grp.txn_line_detail_tbl,
402: x_tiir_tbl OUT nocopy csi_t_datastructures_grp.txn_ii_rltns_tbl,
403: x_return_status OUT nocopy varchar2)
404: IS

Line 401: x_tld_tbl OUT nocopy csi_t_datastructures_grp.txn_line_detail_tbl,

397: PROCEDURE create_dflt_txn_dtls(
398: p_order_line_rec IN oe_order_lines_all%rowtype,
399: px_default_info_rec IN OUT nocopy default_info_rec,
400: x_txn_line_rec OUT nocopy csi_t_datastructures_grp.txn_line_rec,
401: x_tld_tbl OUT nocopy csi_t_datastructures_grp.txn_line_detail_tbl,
402: x_tiir_tbl OUT nocopy csi_t_datastructures_grp.txn_ii_rltns_tbl,
403: x_return_status OUT nocopy varchar2)
404: IS
405:

Line 402: x_tiir_tbl OUT nocopy csi_t_datastructures_grp.txn_ii_rltns_tbl,

398: p_order_line_rec IN oe_order_lines_all%rowtype,
399: px_default_info_rec IN OUT nocopy default_info_rec,
400: x_txn_line_rec OUT nocopy csi_t_datastructures_grp.txn_line_rec,
401: x_tld_tbl OUT nocopy csi_t_datastructures_grp.txn_line_detail_tbl,
402: x_tiir_tbl OUT nocopy csi_t_datastructures_grp.txn_ii_rltns_tbl,
403: x_return_status OUT nocopy varchar2)
404: IS
405:
406: c_tl_rec csi_t_datastructures_grp.txn_line_rec;

Line 406: c_tl_rec csi_t_datastructures_grp.txn_line_rec;

402: x_tiir_tbl OUT nocopy csi_t_datastructures_grp.txn_ii_rltns_tbl,
403: x_return_status OUT nocopy varchar2)
404: IS
405:
406: c_tl_rec csi_t_datastructures_grp.txn_line_rec;
407: c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
408: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
409: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
410: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 407: c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

403: x_return_status OUT nocopy varchar2)
404: IS
405:
406: c_tl_rec csi_t_datastructures_grp.txn_line_rec;
407: c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
408: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
409: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
410: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
411: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 408: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

404: IS
405:
406: c_tl_rec csi_t_datastructures_grp.txn_line_rec;
407: c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
408: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
409: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
410: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
411: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
412: c_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 409: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

405:
406: c_tl_rec csi_t_datastructures_grp.txn_line_rec;
407: c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
408: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
409: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
410: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
411: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
412: c_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
413: c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 410: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

406: c_tl_rec csi_t_datastructures_grp.txn_line_rec;
407: c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
408: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
409: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
410: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
411: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
412: c_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
413: c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
414:

Line 411: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

407: c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
408: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
409: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
410: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
411: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
412: c_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
413: c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
414:
415: l_loop_count number := 1;

Line 412: c_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

408: c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
409: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
410: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
411: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
412: c_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
413: c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
414:
415: l_loop_count number := 1;
416: l_quantity number;

Line 413: c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;

409: c_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
410: c_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
411: c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
412: c_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
413: c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
414:
415: l_loop_count number := 1;
416: l_quantity number;
417:

Line 1545: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

1541: END get_txn_sub_type_id;
1542:
1543: /* This routine splits the transaction details in to quantity one each */
1544: PROCEDURE split_txn_dtls(
1545: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
1546: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
1547: x_return_status OUT NOCOPY varchar2)
1548: IS
1549: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 1546: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,

1542:
1543: /* This routine splits the transaction details in to quantity one each */
1544: PROCEDURE split_txn_dtls(
1545: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
1546: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
1547: x_return_status OUT NOCOPY varchar2)
1548: IS
1549: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1550: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

Line 1549: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

1545: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
1546: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
1547: x_return_status OUT NOCOPY varchar2)
1548: IS
1549: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1550: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1551:
1552: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1553: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 1550: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

1546: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
1547: x_return_status OUT NOCOPY varchar2)
1548: IS
1549: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1550: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1551:
1552: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1553: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1554: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 1552: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;

1548: IS
1549: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1550: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1551:
1552: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1553: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1554: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1555: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1556: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 1553: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

1549: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1550: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1551:
1552: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1553: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1554: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1555: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1556: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1557: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 1554: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

1550: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1551:
1552: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1553: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1554: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1555: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1556: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1557: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1558: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 1555: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

1551:
1552: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1553: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1554: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1555: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1556: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1557: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1558: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1559: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 1556: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1552: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1553: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1554: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1555: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1556: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1557: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1558: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1559: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1560: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 1557: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

1553: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1554: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1555: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1556: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1557: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1558: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1559: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1560: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1561: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 1558: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

1554: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1555: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1556: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1557: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1558: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1559: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1560: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1561: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1562:

Line 1559: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

1555: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1556: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1557: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1558: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1559: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1560: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1561: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1562:
1563: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 1560: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

1556: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1557: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1558: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1559: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1560: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1561: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1562:
1563: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1564: l_split_count number;

Line 1561: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

1557: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1558: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1559: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1560: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1561: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1562:
1563: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1564: l_split_count number;
1565:

Line 1563: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1559: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1560: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1561: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1562:
1563: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1564: l_split_count number;
1565:
1566: l_c_pty_ind binary_integer;
1567: l_c_pa_ind binary_integer;

Line 1699: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

1695: END split_txn_dtls;
1696:
1697: PROCEDURE split_txn_dtls_with_ratio(
1698: p_quantity_ratio IN number,
1699: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1700: x_return_status OUT NOCOPY varchar2)
1701: IS
1702:
1703: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 1703: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

1699: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1700: x_return_status OUT NOCOPY varchar2)
1701: IS
1702:
1703: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1704: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1705:
1706: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1707: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 1704: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

1700: x_return_status OUT NOCOPY varchar2)
1701: IS
1702:
1703: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1704: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1705:
1706: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1707: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1708: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 1706: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;

1702:
1703: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1704: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1705:
1706: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1707: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1708: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1709: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1710: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 1707: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

1703: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1704: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1705:
1706: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1707: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1708: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1709: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1710: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1711: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 1708: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

1704: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1705:
1706: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1707: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1708: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1709: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1710: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1711: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1712: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 1709: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

1705:
1706: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1707: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1708: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1709: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1710: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1711: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1712: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1713: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 1710: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1706: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1707: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1708: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1709: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1710: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1711: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1712: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1713: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1714: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 1711: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

1707: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1708: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1709: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1710: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1711: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1712: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1713: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1714: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1715: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 1712: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

1708: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1709: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1710: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1711: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1712: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1713: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1714: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1715: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1716:

Line 1713: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

1709: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1710: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1711: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1712: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1713: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1714: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1715: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1716:
1717: l_td_quantity number;

Line 1714: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

1710: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1711: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1712: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1713: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1714: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1715: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1716:
1717: l_td_quantity number;
1718:

Line 1715: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

1711: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1712: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1713: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1714: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1715: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1716:
1717: l_td_quantity number;
1718:
1719: l_o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 1719: l_o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

1715: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1716:
1717: l_td_quantity number;
1718:
1719: l_o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1720: l_o_ind binary_integer := 0;
1721:
1722: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1723: l_msg_count number;

Line 2013: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;

2009: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
2010: l_g_time_stamp date;
2011:
2012: -- create_txn_line_dtls variables
2013: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2014: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2015: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2016: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2017: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 2014: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

2010: l_g_time_stamp date;
2011:
2012: -- create_txn_line_dtls variables
2013: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2014: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2015: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2016: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2017: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2018: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 2015: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

2011:
2012: -- create_txn_line_dtls variables
2013: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2014: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2015: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2016: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2017: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2018: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2019:

Line 2016: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

2012: -- create_txn_line_dtls variables
2013: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2014: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2015: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2016: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2017: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2018: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2019:
2020: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 2017: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

2013: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2014: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2015: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2016: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2017: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2018: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2019:
2020: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2021: l_msg_count number;

Line 2018: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

2014: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2015: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2016: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2017: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2018: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2019:
2020: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2021: l_msg_count number;
2022: l_msg_data varchar2(4000);

Line 2122: x_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

2118: p_source_table IN varchar2,
2119: p_source_id IN number,
2120: p_source_flag IN varchar2,
2121: p_processing_status IN varchar2,
2122: x_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2123: x_return_status OUT NOCOPY varchar2)
2124: IS
2125:
2126: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 2126: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

2122: x_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2123: x_return_status OUT NOCOPY varchar2)
2124: IS
2125:
2126: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2127: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2128:
2129: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2130: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 2127: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

2123: x_return_status OUT NOCOPY varchar2)
2124: IS
2125:
2126: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2127: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2128:
2129: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2130: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2131: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 2129: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

2125:
2126: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2127: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2128:
2129: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2130: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2131: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2132: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2133: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 2130: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

2126: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2127: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2128:
2129: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2130: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2131: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2132: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2133: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2134: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 2131: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

2127: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2128:
2129: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2130: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2131: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2132: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2133: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2134: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2135: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 2132: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

2128:
2129: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2130: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2131: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2132: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2133: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2134: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2135: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2136: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 2133: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

2129: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2130: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2131: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2132: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2133: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2134: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2135: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2136: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2137: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 2134: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

2130: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2131: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2132: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2133: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2134: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2135: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2136: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2137: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2138:

Line 2135: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

2131: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2132: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2133: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2134: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2135: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2136: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2137: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2138:
2139: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 2136: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

2132: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2133: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2134: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2135: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2136: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2137: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2138:
2139: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2140: l_msg_data varchar2(2000);

Line 2137: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

2133: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2134: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2135: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2136: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2137: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2138:
2139: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2140: l_msg_data varchar2(2000);
2141: l_msg_count number;

Line 2401: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

2397: PROCEDURE convert_wip_instance_to_cp(
2398: p_instance_id IN number,
2399: p_order_hdr_rec IN oe_order_headers_all%rowtype,
2400: p_order_line_rec IN oe_order_lines_all%rowtype,
2401: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
2402: px_default_info_rec IN OUT nocopy default_info_rec,
2403: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2404: x_return_status OUT NOCOPY varchar2)
2405: IS

Line 2426: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

2422: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2423: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2424: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2425:
2426: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2427: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2428: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2429: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2430: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;

Line 2427: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

2423: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2424: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2425:
2426: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2427: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2428: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2429: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2430: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2431: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 2428: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

2424: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2425:
2426: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2427: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2428: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2429: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2430: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2431: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2432: l_upd_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 2429: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

2425:
2426: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2427: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2428: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2429: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2430: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2431: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2432: l_upd_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2433: l_upd_order_line_rec csi_order_ship_pub.order_line_rec;

Line 2430: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;

2426: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2427: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2428: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2429: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2430: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2431: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2432: l_upd_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2433: l_upd_order_line_rec csi_order_ship_pub.order_line_rec;
2434: l_tld_found VARCHAR2(1);

Line 2431: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

2427: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2428: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2429: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2430: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2431: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2432: l_upd_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2433: l_upd_order_line_rec csi_order_ship_pub.order_line_rec;
2434: l_tld_found VARCHAR2(1);
2435:

Line 2432: l_upd_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

2428: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2429: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2430: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2431: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2432: l_upd_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2433: l_upd_order_line_rec csi_order_ship_pub.order_line_rec;
2434: l_tld_found VARCHAR2(1);
2435:
2436: l_instance_party_id number;

Line 2460: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

2456:
2457: -- Modification for bug 4091371
2458: PROCEDURE get_info_from_tld(
2459: p_instance_id IN number,
2460: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2461: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2462: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2463: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
2464: x_sub_type_id OUT nocopy number,

Line 2461: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

2457: -- Modification for bug 4091371
2458: PROCEDURE get_info_from_tld(
2459: p_instance_id IN number,
2460: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2461: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2462: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2463: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
2464: x_sub_type_id OUT nocopy number,
2465: x_cascade_owner_flag OUT nocopy varchar2,

Line 2462: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

2458: PROCEDURE get_info_from_tld(
2459: p_instance_id IN number,
2460: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2461: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2462: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2463: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
2464: x_sub_type_id OUT nocopy number,
2465: x_cascade_owner_flag OUT nocopy varchar2,
2466: x_tld_found OUT NOCOPY VARCHAR2 )

Line 2463: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

2459: p_instance_id IN number,
2460: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2461: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2462: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2463: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
2464: x_sub_type_id OUT nocopy number,
2465: x_cascade_owner_flag OUT nocopy varchar2,
2466: x_tld_found OUT NOCOPY VARCHAR2 )
2467: IS

Line 2470: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

2466: x_tld_found OUT NOCOPY VARCHAR2 )
2467: IS
2468: l_tld_found VARCHAR2(1) := fnd_api.g_false;
2469: l_txn_line_detail_id NUMBER;
2470: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2471: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2472: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2473: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2474: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 2471: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

2467: IS
2468: l_tld_found VARCHAR2(1) := fnd_api.g_false;
2469: l_txn_line_detail_id NUMBER;
2470: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2471: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2472: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2473: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2474: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2475: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 2472: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

2468: l_tld_found VARCHAR2(1) := fnd_api.g_false;
2469: l_txn_line_detail_id NUMBER;
2470: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2471: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2472: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2473: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2474: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2475: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2476: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 2473: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

2469: l_txn_line_detail_id NUMBER;
2470: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2471: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2472: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2473: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2474: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2475: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2476: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2477: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 2474: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

2470: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2471: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2472: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2473: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2474: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2475: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2476: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2477: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2478: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 2475: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

2471: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2472: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2473: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2474: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2475: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2476: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2477: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2478: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2479: l_msg_count number;

Line 2476: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

2472: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2473: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2474: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2475: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2476: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2477: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2478: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2479: l_msg_count number;
2480: l_msg_data varchar2(2000);

Line 2477: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

2473: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2474: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2475: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2476: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2477: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2478: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2479: l_msg_count number;
2480: l_msg_data varchar2(2000);
2481:

Line 4064: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

4060: l_config_instances config_serial_inst_tbl;
4061:
4062: l_order_hdr_rec oe_order_headers_all%rowtype;
4063: l_order_line_rec oe_order_lines_all%rowtype;
4064: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4065:
4066: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4067:
4068: BEGIN

Line 4483: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

4479: PROCEDURE stamp_om_line_for_options(
4480: p_order_hdr_rec IN oe_order_headers_all%rowtype,
4481: p_order_line_rec IN oe_order_lines_all%rowtype,
4482: p_wip_instances IN wip_instances,
4483: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4484: px_default_info_rec IN OUT nocopy default_info_rec,
4485: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4486: x_return_status OUT nocopy varchar2)
4487: IS

Line 4717: px_src_tld_tbl IN OUT nocopy csi_t_datastructures_grp.txn_line_detail_tbl,

4713: x_return_status := fnd_api.g_ret_sts_error;
4714: END mark_and_get_config;
4715:
4716: PROCEDURE mark_and_get_src_tld(
4717: px_src_tld_tbl IN OUT nocopy csi_t_datastructures_grp.txn_line_detail_tbl,
4718: x_src_tld_rec OUT nocopy csi_t_datastructures_grp.txn_line_detail_rec,
4719: x_return_status OUT nocopy varchar2)
4720: IS
4721: px_ind binary_integer := 0;

Line 4718: x_src_tld_rec OUT nocopy csi_t_datastructures_grp.txn_line_detail_rec,

4714: END mark_and_get_config;
4715:
4716: PROCEDURE mark_and_get_src_tld(
4717: px_src_tld_tbl IN OUT nocopy csi_t_datastructures_grp.txn_line_detail_tbl,
4718: x_src_tld_rec OUT nocopy csi_t_datastructures_grp.txn_line_detail_rec,
4719: x_return_status OUT nocopy varchar2)
4720: IS
4721: px_ind binary_integer := 0;
4722: BEGIN

Line 5038: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5034: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5035: x_return_status OUT nocopy varchar2)
5036: IS
5037:
5038: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5039: l_temp_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5040:
5041: l_config_class_ratio number;
5042:

Line 5039: l_temp_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5035: x_return_status OUT nocopy varchar2)
5036: IS
5037:
5038: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5039: l_temp_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5040:
5041: l_config_class_ratio number;
5042:
5043: lp_ind binary_integer := 0;

Line 5057: l_oc_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;

5053:
5054: l_config_ns_tld_id number;
5055: l_sub_config_ns_tld_id number;
5056:
5057: l_oc_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5058:
5059: oct_ind binary_integer := 0;
5060: l_oc_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5061:

Line 5060: l_oc_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5056:
5057: l_oc_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5058:
5059: oct_ind binary_integer := 0;
5060: l_oc_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5061:
5062: l_ii_rltns_qry_rec csi_datastructures_pub.relationship_query_rec;
5063: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5064: l_temp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 5079: l_t_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

5075:
5076: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
5077: l_instance_id_lst csi_datastructures_pub.id_tbl;
5078:
5079: l_t_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5080: l_wip_processing boolean := FALSE;
5081:
5082: l_msg_count number := 0;
5083: l_msg_data varchar2(2000);

Line 5709: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,

5705:
5706: -- child order line instances should get hooked in to the ib trackable parent order line
5707: PROCEDURE build_parent_relation(
5708: p_order_line_rec IN oe_order_lines_all%rowtype,
5709: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
5710: p_split_flag IN varchar2,
5711: p_identified_item_type IN varchar2,
5712: p_config_rec IN config_rec,
5713: p_config_instances IN config_serial_inst_tbl,

Line 5726: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

5722:
5723: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5724: l_instance_tbl csi_datastructures_pub.instance_tbl;
5725:
5726: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5727: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5728:
5729: l_parent_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
5730: l_child_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;

Line 5727: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

5723: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5724: l_instance_tbl csi_datastructures_pub.instance_tbl;
5725:
5726: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5727: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5728:
5729: l_parent_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
5730: l_child_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5731: l_ns_tld_id number;

Line 5730: l_child_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;

5726: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5727: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5728:
5729: l_parent_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
5730: l_child_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5731: l_ns_tld_id number;
5732:
5733: l_qty_ratio number;
5734:

Line 6098: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,

6094:
6095: -- builds relation to the next level
6096: PROCEDURE build_child_relation(
6097: p_order_line_rec IN oe_order_lines_all%ROWTYPE,
6098: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6099: p_identified_item_type IN varchar2,
6100: px_default_info_rec IN OUT NOCOPY default_info_rec,
6101: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6102: x_return_status OUT NOCOPY varchar2)

Line 6114: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

6110: l_instance_tbl csi_datastructures_pub.instance_tbl;
6111: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6112:
6113:
6114: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6115:
6116: l_child_line_tbl oe_order_pub.line_tbl_type;
6117: l_grand_child_line_tbl oe_order_pub.line_tbl_type;
6118: l_qty_ratio number;

Line 6127: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

6123:
6124: l_ns_tld_id number;
6125: l_object_id number;
6126: l_subject_id number;
6127: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6128:
6129: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6130: l_msg_data varchar2(2000);
6131: l_msg_count number;

Line 6383: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

6379: PROCEDURE process_ato_option_nsrl(
6380: p_order_hdr_rec IN oe_order_headers_all%rowtype,
6381: p_order_line_rec IN oe_order_lines_all%rowtype,
6382: p_config_rec IN config_rec,
6383: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
6384: px_default_info_rec IN OUT nocopy default_info_rec,
6385: x_return_status OUT nocopy Varchar2)
6386: IS
6387:

Line 6764: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

6760: p_order_hdr_rec IN oe_order_headers_all%rowtype,
6761: p_order_line_rec IN oe_order_lines_all%rowtype,
6762: p_config_rec IN config_rec,
6763: p_config_instances IN config_serial_inst_tbl,
6764: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
6765: px_default_info_rec IN OUT nocopy default_info_rec,
6766: x_return_status OUT nocopy varchar2)
6767: IS
6768:

Line 7096: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

7092: IS
7093:
7094: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7095: l_wip_processing boolean := TRUE;
7096: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7097: l_transaction_line_id number;
7098: l_mdl_ordered_qty number;
7099: l_model_hierarchy varchar2(100);
7100: l_qty_ratio number; --declared for bug5096435

Line 7238: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

7234: x_return_status := fnd_api.g_ret_sts_error;
7235: END process_ato_option_from_wip;
7236:
7237: PROCEDURE get_source_tlds(
7238: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
7239: x_src_tld_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7240: x_src_tld_total_qty OUT NOCOPY number)
7241: IS
7242: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 7239: x_src_tld_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

7235: END process_ato_option_from_wip;
7236:
7237: PROCEDURE get_source_tlds(
7238: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
7239: x_src_tld_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7240: x_src_tld_total_qty OUT NOCOPY number)
7241: IS
7242: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7243: l_src_ind binary_integer := 0;

Line 7242: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

7238: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
7239: x_src_tld_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7240: x_src_tld_total_qty OUT NOCOPY number)
7241: IS
7242: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7243: l_src_ind binary_integer := 0;
7244: l_src_tld_total_qty number := 0;
7245: BEGIN
7246: IF p_tld_tbl.COUNT > 0 THEN

Line 7265: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

7261:
7262: PROCEDURE demo_fulfillment(
7263: p_txn_type_id IN number,
7264: p_order_line_rec IN oe_order_lines_all%rowtype,
7265: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
7266: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
7267: x_return_status OUT nocopy varchar2)
7268: IS
7269:

Line 7272: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

7268: IS
7269:
7270: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
7271:
7272: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7273: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7274:
7275: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7276: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 7273: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

7269:
7270: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
7271:
7272: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7273: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7274:
7275: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7276: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7277: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 7275: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

7271:
7272: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7273: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7274:
7275: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7276: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7277: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7278: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7279: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 7276: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

7272: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7273: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7274:
7275: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7276: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7277: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7278: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7279: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7280: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 7277: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

7273: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7274:
7275: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7276: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7277: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7278: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7279: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7280: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7281: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 7278: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

7274:
7275: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7276: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7277: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7278: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7279: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7280: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7281: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 7279: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

7275: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7276: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7277: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7278: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7279: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7280: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7281: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 7280: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

7276: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7277: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7278: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7279: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7280: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7281: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7284:

Line 7281: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

7277: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7278: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7279: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7280: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7281: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7284:
7285: l_instance_rec csi_datastructures_pub.instance_header_rec;

Line 7282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

7278: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7279: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7280: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7281: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7284:
7285: l_instance_rec csi_datastructures_pub.instance_header_rec;
7286: l_party_header_tbl csi_datastructures_pub.party_header_tbl;

Line 7283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

7279: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7280: l_txn_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7281: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7284:
7285: l_instance_rec csi_datastructures_pub.instance_header_rec;
7286: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
7287: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

Line 7294: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

7290: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7291: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
7292: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
7293:
7294: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
7295: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7296: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7297: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7298: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 7295: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

7291: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
7292: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
7293:
7294: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
7295: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7296: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7297: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7298: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7299: l_u_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 7296: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

7292: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
7293:
7294: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
7295: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7296: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7297: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7298: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7299: l_u_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7300: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 7297: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

7293:
7294: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
7295: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7296: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7297: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7298: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7299: l_u_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7300: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7301:

Line 7298: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

7294: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
7295: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7296: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7297: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7298: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7299: l_u_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7300: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7301:
7302: l_time_stamp date;

Line 7299: l_u_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

7295: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7296: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7297: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7298: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7299: l_u_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7300: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7301:
7302: l_time_stamp date;
7303:

Line 7300: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

7296: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7297: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7298: l_u_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7299: l_u_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7300: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7301:
7302: l_time_stamp date;
7303:
7304: l_td_owner_id number;

Line 7651: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

7647: x_return_status OUT NOCOPY varchar2,
7648: x_return_message OUT NOCOPY varchar2)
7649: IS
7650:
7651: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
7652: l_td_found boolean := FALSE;
7653:
7654: l_source_header_rec csi_interface_pkg.source_header_rec;
7655: l_source_line_rec csi_interface_pkg.source_line_rec;

Line 7659: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

7655: l_source_line_rec csi_interface_pkg.source_line_rec;
7656:
7657: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
7658:
7659: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7660: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7661:
7662: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7663: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 7660: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

7656:
7657: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
7658:
7659: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7660: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7661:
7662: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7663: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7664: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 7662: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

7658:
7659: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7660: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7661:
7662: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7663: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7664: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7665: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7666: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 7663: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

7659: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7660: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7661:
7662: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7663: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7664: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7665: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7666: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7667: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 7664: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

7660: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7661:
7662: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7663: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7664: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7665: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7666: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7667: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7668: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 7665: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

7661:
7662: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7663: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7664: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7665: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7666: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7667: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7668: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7669: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 7666: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

7662: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7663: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7664: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7665: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7666: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7667: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7668: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7669: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7670: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 7667: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

7663: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7664: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7665: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7666: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7667: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7668: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7669: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7670: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7671:

Line 7668: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

7664: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7665: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7666: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7667: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7668: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7669: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7670: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7671:
7672: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 7669: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

7665: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7666: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7667: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7668: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7669: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7670: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7671:
7672: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7673: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 7670: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

7666: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7667: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7668: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7669: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7670: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7671:
7672: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7673: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7674: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 7672: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

7668: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7669: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7670: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7671:
7672: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7673: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7674: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7675: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7676: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 7673: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

7669: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7670: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7671:
7672: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7673: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7674: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7675: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7676: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7677: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 7674: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

7670: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7671:
7672: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7673: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7674: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7675: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7676: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7677: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7678: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 7675: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

7671:
7672: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7673: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7674: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7675: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7676: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7677: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7678: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7679:

Line 7676: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

7672: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7673: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7674: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7675: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7676: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7677: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7678: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7679:
7680: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 7677: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

7673: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7674: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7675: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7676: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7677: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7678: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7679:
7680: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
7681:

Line 7678: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

7674: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7675: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7676: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7677: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7678: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7679:
7680: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
7681:
7682: -- Added this for unlock_item_instances

Line 7903: l_tl_query_rec csi_t_datastructures_grp.txn_line_query_rec;

7899: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
7900: x_return_status OUT NOCOPY varchar2)
7901: IS
7902:
7903: l_tl_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7904: l_tld_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7905:
7906: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
7907:

Line 7904: l_tld_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

7900: x_return_status OUT NOCOPY varchar2)
7901: IS
7902:
7903: l_tl_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7904: l_tld_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7905:
7906: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
7907:
7908: l_p_tl_rec csi_t_datastructures_grp.txn_line_rec;

Line 7908: l_p_tl_rec csi_t_datastructures_grp.txn_line_rec;

7904: l_tld_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7905:
7906: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
7907:
7908: l_p_tl_rec csi_t_datastructures_grp.txn_line_rec;
7909:
7910: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7911: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7912: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 7910: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

7906: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
7907:
7908: l_p_tl_rec csi_t_datastructures_grp.txn_line_rec;
7909:
7910: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7911: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7912: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7913: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7914: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 7911: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

7907:
7908: l_p_tl_rec csi_t_datastructures_grp.txn_line_rec;
7909:
7910: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7911: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7912: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7913: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7914: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 7912: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

7908: l_p_tl_rec csi_t_datastructures_grp.txn_line_rec;
7909:
7910: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7911: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7912: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7913: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7914: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7916: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 7913: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

7909:
7910: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7911: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7912: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7913: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7914: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7916: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
7917: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 7914: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

7910: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7911: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7912: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7913: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7914: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7916: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
7917: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
7918: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 7915: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

7911: l_p_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7912: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7913: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7914: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7916: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
7917: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
7918: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7919: l_p_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 7916: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;

7912: l_p_tpa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7913: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7914: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7916: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
7917: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
7918: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7919: l_p_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7920:

Line 7918: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

7914: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7916: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
7917: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
7918: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7919: l_p_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7920:
7921: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7922: l_src_tld_total_qty number := 0;

Line 7919: l_p_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

7915: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7916: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
7917: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
7918: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7919: l_p_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7920:
7921: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7922: l_src_tld_total_qty number := 0;
7923:

Line 7921: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

7917: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
7918: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7919: l_p_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7920:
7921: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7922: l_src_tld_total_qty number := 0;
7923:
7924: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7925: l_msg_count number;

Line 8154: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

8150:
8151: l_trk_child_tbl oe_order_pub.line_tbl_type;
8152: l_trk_parent_rec oe_order_pub.line_rec_type;
8153:
8154: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8155: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8156: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8157: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
8158:

Line 8155: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

8151: l_trk_child_tbl oe_order_pub.line_tbl_type;
8152: l_trk_parent_rec oe_order_pub.line_rec_type;
8153:
8154: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8155: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8156: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8157: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
8158:
8159: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 8156: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

8152: l_trk_parent_rec oe_order_pub.line_rec_type;
8153:
8154: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8155: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8156: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8157: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
8158:
8159: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8160: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 8159: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

8155: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8156: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8157: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
8158:
8159: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8160: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8161: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8162: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8163: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 8160: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

8156: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8157: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
8158:
8159: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8160: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8161: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8162: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8163: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8164: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 8161: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

8157: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
8158:
8159: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8160: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8161: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8162: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8163: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8164: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8165: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 8162: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

8158:
8159: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8160: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8161: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8162: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8163: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8164: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8165: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8166: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 8163: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

8159: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8160: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8161: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8162: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8163: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8164: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8165: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8166: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8167: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 8164: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

8160: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8161: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8162: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8163: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8164: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8165: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8166: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8167: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8168:

Line 8165: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

8161: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8162: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8163: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8164: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8165: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8166: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8167: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8168:
8169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 8166: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

8162: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8163: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8164: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8165: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8166: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8167: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8168:
8169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 8167: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

8163: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8164: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8165: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8166: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8167: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8168:
8169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 8169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

8165: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8166: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8167: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8168:
8169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 8170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

8166: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8167: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8168:
8169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 8171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

8167: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8168:
8169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8175: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 8172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

8168:
8169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8175: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8176:

Line 8173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

8169: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8175: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8176:
8177: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 8174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

8170: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8175: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8176:
8177: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8178: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 8175: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

8171: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8172: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8175: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8176:
8177: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8178: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8179: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 8177: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

8173: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8175: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8176:
8177: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8178: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8179: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8180: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8181: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 8178: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

8174: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8175: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8176:
8177: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8178: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8179: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8180: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8181: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8182: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 8179: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

8175: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8176:
8177: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8178: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8179: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8180: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8181: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8182: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8183: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 8180: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

8176:
8177: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8178: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8179: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8180: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8181: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8182: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8183: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8184: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 8181: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

8177: l_p_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8178: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8179: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8180: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8181: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8182: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8183: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8184: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8185: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 8182: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

8178: l_p_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8179: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8180: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8181: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8182: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8183: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8184: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8185: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8186: l_p_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 8183: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

8179: l_p_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8180: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8181: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8182: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8183: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8184: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8185: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8186: l_p_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8187:

Line 8185: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

8181: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8182: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8183: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8184: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8185: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8186: l_p_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8187:
8188: l_tmp_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8189: l_party_site_id number;

Line 8186: l_p_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

8182: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8183: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8184: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8185: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8186: l_p_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8187:
8188: l_tmp_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8189: l_party_site_id number;
8190: l_owner_party_id number;

Line 8188: l_tmp_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

8184: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8185: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8186: l_p_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8187:
8188: l_tmp_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8189: l_party_site_id number;
8190: l_owner_party_id number;
8191: l_owner_account_id number;
8192:

Line 8243: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

8239: l_msg_data varchar2(2000);
8240: l_msg_count number;
8241:
8242: ---Added (Start) for m-to-m enhancements
8243: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8244: ---Added (End) for m-to-m enhancements
8245:
8246: skip_regular_process exception;
8247: l_error_rec csi_datastructures_pub.transaction_error_rec;

Line 8255: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

8251: l_current_site_use_id number;
8252: l_install_site_use_id number;
8253:
8254: l_osp_vld_org_id number;
8255: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8256: l_src_tld_total_qty number := 0;
8257: --
8258: l_ul_txn_line_id NUMBER;
8259: l_ul_instance_rec csi_datastructures_pub.instance_rec;

Line 9458: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;

9454: l_trx_line_id number;
9455: l_txn_line_rec_exists boolean := FALSE;
9456: l_create_txn_line_dtls boolean := TRUE;
9457:
9458: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;
9459:
9460: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
9461: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9462: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;

Line 9460: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;

9456: l_create_txn_line_dtls boolean := TRUE;
9457:
9458: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;
9459:
9460: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
9461: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9462: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
9463: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9464: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 9461: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

9457:
9458: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;
9459:
9460: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
9461: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9462: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
9463: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9464: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9465: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 9462: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;

9458: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;
9459:
9460: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
9461: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9462: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
9463: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9464: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9465: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9466: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 9463: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

9459:
9460: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
9461: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9462: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
9463: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9464: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9465: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9466: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
9467: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 9464: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

9460: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
9461: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9462: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
9463: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9464: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9465: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9466: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
9467: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9468:

Line 9465: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

9461: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9462: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
9463: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9464: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9465: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9466: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
9467: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9468:
9469: l_continue boolean := TRUE;

Line 9466: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;

9462: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
9463: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9464: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9465: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9466: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
9467: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9468:
9469: l_continue boolean := TRUE;
9470:

Line 9467: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

9463: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
9464: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9465: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9466: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
9467: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9468:
9469: l_continue boolean := TRUE;
9470:
9471: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 9837: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

9833: l_shipped_qty number;
9834: p_trackable_parent boolean;
9835: x_trx_line_id number;
9836:
9837: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
9838: l_trx_detail_exist boolean := FALSE;
9839: l_trx_rec csi_datastructures_pub.transaction_rec;
9840:
9841: l_exp_instance_rec csi_datastructures_pub.instance_rec;