[Home] [Help]
1565: --End of Comments
1566: ---------------------------------------------------------------------------
1567: FUNCTION get_COGS_account(p_inv_org_id IN NUMBER) RETURN NUMBER
1568: IS
1569: l_COGS_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE := NULL;
1570: BEGIN
1571: --SQL WHAT: Get the Get the COGS account for the Logical Inventory Org
1572: -- associated with an OU for a given Transaction Flow.
1573: --SQL WHY: Default as the PO Charge Account for SPS case
1612: FUNCTION get_item_expense_account(p_item_id IN NUMBER,
1613: p_inv_org_id IN NUMBER)
1614: RETURN NUMBER
1615: IS
1616: l_item_expense_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1617: BEGIN
1618: --SQL WHAT: Get the Expense Account associated with an item in the Logical
1619: -- Inventory Org for a Start OU for a given Transaction Flow.
1620: --SQL WHY: To default this as the PO Expense Account for SPS case
1657: ---------------------------------------------------------------------------
1658: FUNCTION get_org_expense_account(p_inv_org_id IN NUMBER)
1659: RETURN NUMBER
1660: IS
1661: l_org_expense_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1662: BEGIN
1663: --SQL WHAT: Get the Expense Account associated with the Logical
1664: -- Inventory Org for a Start OU for a given Transaction Flow.
1665: --SQL WHY: To default this as the PO Expense Account for SPS case
1701: ---------------------------------------------------------------------------
1702: FUNCTION get_org_material_account(p_inv_org_id IN NUMBER)
1703: RETURN NUMBER
1704: IS
1705: l_org_material_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1706: BEGIN
1707: --SQL WHAT: Get the Material Account associated with the Logical
1708: -- Inventory Org for a Start OU for a given Transaction Flow.
1709: --SQL WHY: To default this as the PO Expense Account for SPS case
1971: result OUT NOCOPY VARCHAR2
1972: )
1973: IS
1974: l_progress WF_ITEM_ACTIVITY_STATUSES.error_stack%TYPE; -- VARCHAR2(4000)
1975: l_dest_charge_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1976: l_temp_acc_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1977: BEGIN
1978: l_progress := '010';
1979:
1972: )
1973: IS
1974: l_progress WF_ITEM_ACTIVITY_STATUSES.error_stack%TYPE; -- VARCHAR2(4000)
1975: l_dest_charge_account_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1976: l_temp_acc_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1977: BEGIN
1978: l_progress := '010';
1979:
1980: -- Do nothing in cancel or timeout mode
2062: result OUT NOCOPY VARCHAR2
2063: )
2064: IS
2065: l_progress WF_ITEM_ACTIVITY_STATUSES.error_stack%TYPE; -- VARCHAR2(4000)
2066: l_pou_coa_id GL_CODE_COMBINATIONS.chart_of_accounts_id%TYPE;
2067: l_ship_to_ou_coa_id GL_CODE_COMBINATIONS.chart_of_accounts_id%TYPE;
2068: l_is_sps_distribution VARCHAR2(10); --
2069: BEGIN
2070: l_progress := '010';
2063: )
2064: IS
2065: l_progress WF_ITEM_ACTIVITY_STATUSES.error_stack%TYPE; -- VARCHAR2(4000)
2066: l_pou_coa_id GL_CODE_COMBINATIONS.chart_of_accounts_id%TYPE;
2067: l_ship_to_ou_coa_id GL_CODE_COMBINATIONS.chart_of_accounts_id%TYPE;
2068: l_is_sps_distribution VARCHAR2(10); --
2069: BEGIN
2070: l_progress := '010';
2071:
2273: l_progress wf_item_activity_statuses.error_stack%TYPE;
2274: l_flex_status VARCHAR2(100);
2275: l_concat_segments VARCHAR2(2000);
2276: l_validation_date DATE;
2277: l_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
2278: l_is_combination_valid BOOLEAN;
2279:
2280: --Bug 9645501
2281: l_account_gen_flow_type VARCHAR2(25);