APPS.JAI_PLSQL_CACHE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 6: (p_org_id IN HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE)

2: /* $Header: jai_plsql_cache.plb 120.5 2006/08/24 15:33:39 lgopalsa noship $ */
3:
4: /* Read from cache */
5: FUNCTION read_cache
6: (p_org_id IN HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE)
7: RETURN func_curr_details AS
8: l_func_curr_det func_curr_details;
9: BEGIN
10: IF (g_get_func_curr.EXISTS (p_org_id)) THEN

Line 37: (p_org_id IN HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE,

33:
34: /* Write from cache */
35:
36: PROCEDURE write_cache
37: (p_org_id IN HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE,
38: p_func_curr_det IN func_curr_details
39: ) AS
40:
41: BEGIN

Line 61: (p_org_id IN HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE)

57:
58: /* Read from db and write into cache */
59:
60: FUNCTION read_from_db
61: (p_org_id IN HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE)
62: RETURN func_curr_details AS
63: ln_ledger_id NUMBER;
64: lv_curr_code VARCHAR2(10);
65:

Line 148: (p_org_id IN HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE)

144: read from db and write onto the cache and return the same
145: */
146:
147: FUNCTION return_sob_curr
148: (p_org_id IN HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE)
149: RETURN func_curr_details AS
150:
151: l_func_curr_det func_curr_details;
152: v_debug varchar2(1);