APPS.PO_WF_PO_CHARGE_ACC dependencies on GL_CODE_COMBINATIONS

Line 1554: l_COGS_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE := NULL;

1550: --End of Comments
1551: ---------------------------------------------------------------------------
1552: FUNCTION get_COGS_account(p_inv_org_id IN NUMBER) RETURN NUMBER
1553: IS
1554: l_COGS_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE := NULL;
1555: BEGIN
1556: --SQL WHAT: Get the Get the COGS account for the Logical Inventory Org
1557: -- associated with an OU for a given Transaction Flow.
1558: --SQL WHY: Default as the PO Charge Account for SPS case

Line 1601: l_item_expense_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;

1597: FUNCTION get_item_expense_account(p_item_id IN NUMBER,
1598: p_inv_org_id IN NUMBER)
1599: RETURN NUMBER
1600: IS
1601: l_item_expense_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1602: BEGIN
1603: --SQL WHAT: Get the Expense Account associated with an item in the Logical
1604: -- Inventory Org for a Start OU for a given Transaction Flow.
1605: --SQL WHY: To default this as the PO Expense Account for SPS case

Line 1646: l_org_expense_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;

1642: ---------------------------------------------------------------------------
1643: FUNCTION get_org_expense_account(p_inv_org_id IN NUMBER)
1644: RETURN NUMBER
1645: IS
1646: l_org_expense_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1647: BEGIN
1648: --SQL WHAT: Get the Expense Account associated with the Logical
1649: -- Inventory Org for a Start OU for a given Transaction Flow.
1650: --SQL WHY: To default this as the PO Expense Account for SPS case

Line 1690: l_org_material_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;

1686: ---------------------------------------------------------------------------
1687: FUNCTION get_org_material_account(p_inv_org_id IN NUMBER)
1688: RETURN NUMBER
1689: IS
1690: l_org_material_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1691: BEGIN
1692: --SQL WHAT: Get the Material Account associated with the Logical
1693: -- Inventory Org for a Start OU for a given Transaction Flow.
1694: --SQL WHY: To default this as the PO Expense Account for SPS case

Line 1960: l_dest_charge_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;

1956: result OUT NOCOPY VARCHAR2
1957: )
1958: IS
1959: l_progress WF_ITEM_ACTIVITY_STATUSES.error_stack%TYPE; -- VARCHAR2(4000)
1960: l_dest_charge_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1961: l_temp_acc_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1962: BEGIN
1963: l_progress := '010';
1964:

Line 1961: l_temp_acc_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;

1957: )
1958: IS
1959: l_progress WF_ITEM_ACTIVITY_STATUSES.error_stack%TYPE; -- VARCHAR2(4000)
1960: l_dest_charge_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1961: l_temp_acc_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1962: BEGIN
1963: l_progress := '010';
1964:
1965: -- Do nothing in cancel or timeout mode

Line 2051: l_pou_coa_id GL_CODE_COMBINATIONS.chart_of_accounts_id%TYPE;

2047: result OUT NOCOPY VARCHAR2
2048: )
2049: IS
2050: l_progress WF_ITEM_ACTIVITY_STATUSES.error_stack%TYPE; -- VARCHAR2(4000)
2051: l_pou_coa_id GL_CODE_COMBINATIONS.chart_of_accounts_id%TYPE;
2052: l_ship_to_ou_coa_id GL_CODE_COMBINATIONS.chart_of_accounts_id%TYPE;
2053: l_is_sps_distribution VARCHAR2(10); --
2054: BEGIN
2055: l_progress := '010';

Line 2052: l_ship_to_ou_coa_id GL_CODE_COMBINATIONS.chart_of_accounts_id%TYPE;

2048: )
2049: IS
2050: l_progress WF_ITEM_ACTIVITY_STATUSES.error_stack%TYPE; -- VARCHAR2(4000)
2051: l_pou_coa_id GL_CODE_COMBINATIONS.chart_of_accounts_id%TYPE;
2052: l_ship_to_ou_coa_id GL_CODE_COMBINATIONS.chart_of_accounts_id%TYPE;
2053: l_is_sps_distribution VARCHAR2(10); --
2054: BEGIN
2055: l_progress := '010';
2056:

Line 2252: l_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;

2248: l_progress wf_item_activity_statuses.error_stack%TYPE;
2249: l_flex_status VARCHAR2(100);
2250: l_concat_segments VARCHAR2(2000);
2251: l_validation_date DATE;
2252: l_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
2253: l_is_combination_valid BOOLEAN;
2254: BEGIN
2255:
2256: l_progress := '010';