2: /* $Header: jai_plsql_cache.pls 120.3 2006/05/26 11:36:23 lgopalsa noship $ */
3:
4: TYPE func_curr_details IS RECORD
5: ( --organization_id HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE, -- org id
6: ledger_id GL_LEDGERS.ledger_id%TYPE , -- SOB
7: currency_code GL_LEDGERS.currency_code%TYPE ,
8: chart_of_accounts_id GL_LEDGERS.chart_of_accounts_id%TYPE,
9: organization_code MTL_PARAMETERS.organization_code%TYPE,
10: legal_entity HR_ORGANIZATION_INFORMATION.org_information2%TYPE,
3:
4: TYPE func_curr_details IS RECORD
5: ( --organization_id HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE, -- org id
6: ledger_id GL_LEDGERS.ledger_id%TYPE , -- SOB
7: currency_code GL_LEDGERS.currency_code%TYPE ,
8: chart_of_accounts_id GL_LEDGERS.chart_of_accounts_id%TYPE,
9: organization_code MTL_PARAMETERS.organization_code%TYPE,
10: legal_entity HR_ORGANIZATION_INFORMATION.org_information2%TYPE,
11: organization_name HR_ALL_ORGANIZATION_UNITS.name%TYPE,
4: TYPE func_curr_details IS RECORD
5: ( --organization_id HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE, -- org id
6: ledger_id GL_LEDGERS.ledger_id%TYPE , -- SOB
7: currency_code GL_LEDGERS.currency_code%TYPE ,
8: chart_of_accounts_id GL_LEDGERS.chart_of_accounts_id%TYPE,
9: organization_code MTL_PARAMETERS.organization_code%TYPE,
10: legal_entity HR_ORGANIZATION_INFORMATION.org_information2%TYPE,
11: organization_name HR_ALL_ORGANIZATION_UNITS.name%TYPE,
12: -- Bug 5243532. Added by Lakshmi Gopalsami
39: WHERE organization_id = cp_org_id;
40:
41:
42: CURSOR get_func_curr
43: (cp_ledger_id IN GL_LEDGERS.ledger_id%TYPE) IS
44: SELECT currency_code curr_code,
45: chart_of_accounts_id coa
46: FROM gl_ledgers
47: WHERE ledger_id = cp_ledger_id;
42: CURSOR get_func_curr
43: (cp_ledger_id IN GL_LEDGERS.ledger_id%TYPE) IS
44: SELECT currency_code curr_code,
45: chart_of_accounts_id coa
46: FROM gl_ledgers
47: WHERE ledger_id = cp_ledger_id;
48:
49: /* Bug 5243532. Added by Lakshmi Gopalsami */
50: /* Currency precision details */