APPS.ICX_REQ_ACCT_DIST dependencies on ICX_CART_LINE_DISTRIBUTIONS

Line 178: v_distribution_lines_region := 'ICX_CART_LINE_DISTRIBUTIONS_R';

174: v_total_lines_entered := icx_percentage.COUNT;
175:
176: -- Initialise header and line regions
177: v_distribution_header_region := 'ICX_CART_LINE_ACCOUNT_HEADER_R';
178: v_distribution_lines_region := 'ICX_CART_LINE_DISTRIBUTIONS_R';
179:
180: v_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');
181:
182: icx_util.getPrompts(601, v_distribution_header_region, v_title, v_prompts);

Line 1738: and a.region_code = 'ICX_CART_LINE_DISTRIBUTIONS_R'

1734: and a.REGION_CODE = c.REGION_CODE
1735: and a.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
1736: and c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
1737: and a.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
1738: and a.region_code = 'ICX_CART_LINE_DISTRIBUTIONS_R'
1739: and a.ATTRIBUTE_CODE LIKE 'ICX_CHARGE_ACCT_SEG%'
1740: order by a.display_sequence;
1741:
1742: cursor check_concatenated_segment is

Line 1757: and a.region_code = 'ICX_CART_LINE_DISTRIBUTIONS_R'

1753: and a.REGION_CODE = c.REGION_CODE
1754: and a.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
1755: and c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
1756: and a.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
1757: and a.region_code = 'ICX_CART_LINE_DISTRIBUTIONS_R'
1758: and a.attribute_code = 'ICX_CHARGE_ACCOUNT_NUM';
1759:
1760: BEGIN
1761:

Line 1797: DELETE FROM icx_cart_line_distributions

1793: the user will either enter '0' (zero) or leave blank in the percentage
1794: column to indicate that, account entry is deleted.
1795: */
1796:
1797: DELETE FROM icx_cart_line_distributions
1798: WHERE cart_id = v_cart_id
1799: AND cart_line_id = v_cart_line_id;
1800:
1801:

Line 1972: AND a.REGION_CODE = 'ICX_CART_LINE_DISTRIBUTIONS_R'

1968: AND b.DATA_TYPE = 'VARCHAR2'
1969: AND c.REGION_APPLICATION_ID = 601
1970: AND a.REGION_CODE = c.REGION_CODE
1971: AND a.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
1972: AND a.REGION_CODE = 'ICX_CART_LINE_DISTRIBUTIONS_R'
1973: AND a.ATTRIBUTE_CODE LIKE 'ICX_CHARGE_ACCT_SEG%'
1974: ORDER BY a.display_sequence;
1975:
1976: -- Exclude the current line

Line 1985: FROM icx_cart_line_distributions

1981: AND cart_line_id <> v_cart_line_id;
1982:
1983: CURSOR get_distributions IS
1984: SELECT distribution_id
1985: FROM icx_cart_line_distributions
1986: WHERE cart_id = v_cart_id
1987: AND cart_line_id = v_cart_line_id;
1988:
1989: CURSOR get_distributions_account_num IS

Line 1991: FROM icx_cart_line_distributions

1987: AND cart_line_id = v_cart_line_id;
1988:
1989: CURSOR get_distributions_account_num IS
1990: SELECT charge_account_num, allocation_value, allocation_type
1991: FROM icx_cart_line_distributions
1992: WHERE cart_id = v_cart_id
1993: AND cart_line_id = v_cart_line_id;
1994:
1995: CURSOR check_concatenated_segment IS

Line 2010: AND a.region_code = 'ICX_CART_LINE_DISTRIBUTIONS_R'

2006: AND a.REGION_CODE = c.REGION_CODE
2007: AND a.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
2008: AND c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
2009: AND a.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
2010: AND a.region_code = 'ICX_CART_LINE_DISTRIBUTIONS_R'
2011: AND a.attribute_code = 'ICX_CHARGE_ACCOUNT_NUM';
2012:
2013: BEGIN
2014:

Line 2015: v_distribution_lines_region := 'ICX_CART_LINE_DISTRIBUTIONS_R';

2011: AND a.attribute_code = 'ICX_CHARGE_ACCOUNT_NUM';
2012:
2013: BEGIN
2014:
2015: v_distribution_lines_region := 'ICX_CART_LINE_DISTRIBUTIONS_R';
2016: v_allocation_type := 'PERCENT';
2017:
2018: v_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
2019: v_employee_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);

Line 2038: DELETE FROM icx_cart_line_distributions

2034:
2035: -- Delte all the account distributions of all the lines except for
2036: -- for the current line. The 'apply to all' overwrites the existing
2037: -- distributions of other lines.
2038: DELETE FROM icx_cart_line_distributions
2039: WHERE cart_id = v_cart_id
2040: AND cart_line_id <> v_cart_line_id;
2041:
2042: IF v_concatenated_segment = 'N' THEN