APPS.AZW_HIER dependencies on FND_LOOKUPS

Line 1498: v_context_type fnd_lookups.lookup_code%TYPE;

1494: v_root_rollup_flag VARCHAR2(1);
1495:
1496: -- Start: added by swarup for context sort
1497: disp_order INTEGER ;
1498: v_context_type fnd_lookups.lookup_code%TYPE;
1499: v_meaning fnd_lookups.meaning%TYPE;
1500:
1501: CURSOR get_context_types_c IS
1502:

Line 1499: v_meaning fnd_lookups.meaning%TYPE;

1495:
1496: -- Start: added by swarup for context sort
1497: disp_order INTEGER ;
1498: v_context_type fnd_lookups.lookup_code%TYPE;
1499: v_meaning fnd_lookups.meaning%TYPE;
1500:
1501: CURSOR get_context_types_c IS
1502:
1503: SELECT lookup_code,

Line 1507: FROM fnd_lookups

1503: SELECT lookup_code,
1504: meaning,
1505: DECODE(lookup_code, 'NONE', 1, 'BG', 2, 'SOB', 3, 'OU', 4, 5)
1506: display_order
1507: FROM fnd_lookups
1508: WHERE lookup_type = 'AZ_CONTEXT_TYPE'
1509: ORDER BY display_order;
1510:
1511: -- End: added by swarup for context sort

Line 1746: l_meaning fnd_lookups.meaning%TYPE;

1742: i IN OUT INTEGER,
1743: p_disp_order IN INTEGER
1744: ) IS
1745: l_disp_order INTEGER DEFAULT 0;
1746: l_meaning fnd_lookups.meaning%TYPE;
1747:
1748: BEGIN
1749:
1750: l_meaning := meaning ;