APPS.IRC_COMMUNICATIONS_API dependencies on HR_LOOKUPS

Line 1559: l_meaning_rec hr_lookups.meaning%TYPE;

1555: l_mgr_id number;
1556: l_apl_id number;
1557: l_team_id number;
1558: l_full_name per_all_people_f.full_name%TYPE;
1559: l_meaning_rec hr_lookups.meaning%TYPE;
1560: l_meaning_mgr hr_lookups.meaning%TYPE;
1561: l_meaning_apl hr_lookups.meaning%TYPE;
1562: l_meaning_tm hr_lookups.meaning%TYPE;
1563: l_meaning_agncy hr_lookups.meaning%TYPE;

Line 1560: l_meaning_mgr hr_lookups.meaning%TYPE;

1556: l_apl_id number;
1557: l_team_id number;
1558: l_full_name per_all_people_f.full_name%TYPE;
1559: l_meaning_rec hr_lookups.meaning%TYPE;
1560: l_meaning_mgr hr_lookups.meaning%TYPE;
1561: l_meaning_apl hr_lookups.meaning%TYPE;
1562: l_meaning_tm hr_lookups.meaning%TYPE;
1563: l_meaning_agncy hr_lookups.meaning%TYPE;
1564: l_role varchar2(32767);

Line 1561: l_meaning_apl hr_lookups.meaning%TYPE;

1557: l_team_id number;
1558: l_full_name per_all_people_f.full_name%TYPE;
1559: l_meaning_rec hr_lookups.meaning%TYPE;
1560: l_meaning_mgr hr_lookups.meaning%TYPE;
1561: l_meaning_apl hr_lookups.meaning%TYPE;
1562: l_meaning_tm hr_lookups.meaning%TYPE;
1563: l_meaning_agncy hr_lookups.meaning%TYPE;
1564: l_role varchar2(32767);
1565: --

Line 1562: l_meaning_tm hr_lookups.meaning%TYPE;

1558: l_full_name per_all_people_f.full_name%TYPE;
1559: l_meaning_rec hr_lookups.meaning%TYPE;
1560: l_meaning_mgr hr_lookups.meaning%TYPE;
1561: l_meaning_apl hr_lookups.meaning%TYPE;
1562: l_meaning_tm hr_lookups.meaning%TYPE;
1563: l_meaning_agncy hr_lookups.meaning%TYPE;
1564: l_role varchar2(32767);
1565: --
1566: TYPE cur_typ IS REF CURSOR;

Line 1563: l_meaning_agncy hr_lookups.meaning%TYPE;

1559: l_meaning_rec hr_lookups.meaning%TYPE;
1560: l_meaning_mgr hr_lookups.meaning%TYPE;
1561: l_meaning_apl hr_lookups.meaning%TYPE;
1562: l_meaning_tm hr_lookups.meaning%TYPE;
1563: l_meaning_agncy hr_lookups.meaning%TYPE;
1564: l_role varchar2(32767);
1565: --
1566: TYPE cur_typ IS REF CURSOR;
1567: cur_rcpt cur_typ;

Line 1818: p_lookup_code hr_lookups.lookup_code%TYPE

1814: -- ----------------------------------------------------------------------------
1815: --
1816:
1817: function get_lookup_meaning(
1818: p_lookup_code hr_lookups.lookup_code%TYPE
1819: ,p_lookup_type hr_lookups.lookup_type%TYPE)
1820: return varchar2 is
1821: --
1822: Cursor cur_lookup(p_lookup_code hr_lookups.lookup_code%TYPE,p_lookup_type hr_lookups.lookup_type%TYPE) is

Line 1819: ,p_lookup_type hr_lookups.lookup_type%TYPE)

1815: --
1816:
1817: function get_lookup_meaning(
1818: p_lookup_code hr_lookups.lookup_code%TYPE
1819: ,p_lookup_type hr_lookups.lookup_type%TYPE)
1820: return varchar2 is
1821: --
1822: Cursor cur_lookup(p_lookup_code hr_lookups.lookup_code%TYPE,p_lookup_type hr_lookups.lookup_type%TYPE) is
1823: --get lookup-meaning from lookup-code,lookup-type

Line 1822: Cursor cur_lookup(p_lookup_code hr_lookups.lookup_code%TYPE,p_lookup_type hr_lookups.lookup_type%TYPE) is

1818: p_lookup_code hr_lookups.lookup_code%TYPE
1819: ,p_lookup_type hr_lookups.lookup_type%TYPE)
1820: return varchar2 is
1821: --
1822: Cursor cur_lookup(p_lookup_code hr_lookups.lookup_code%TYPE,p_lookup_type hr_lookups.lookup_type%TYPE) is
1823: --get lookup-meaning from lookup-code,lookup-type
1824: select hr_lookups.meaning
1825: from hr_lookups
1826: where lookup_code = p_lookup_code

Line 1824: select hr_lookups.meaning

1820: return varchar2 is
1821: --
1822: Cursor cur_lookup(p_lookup_code hr_lookups.lookup_code%TYPE,p_lookup_type hr_lookups.lookup_type%TYPE) is
1823: --get lookup-meaning from lookup-code,lookup-type
1824: select hr_lookups.meaning
1825: from hr_lookups
1826: where lookup_code = p_lookup_code
1827: and lookup_type = p_lookup_type
1828: and enabled_flag = 'Y'

Line 1825: from hr_lookups

1821: --
1822: Cursor cur_lookup(p_lookup_code hr_lookups.lookup_code%TYPE,p_lookup_type hr_lookups.lookup_type%TYPE) is
1823: --get lookup-meaning from lookup-code,lookup-type
1824: select hr_lookups.meaning
1825: from hr_lookups
1826: where lookup_code = p_lookup_code
1827: and lookup_type = p_lookup_type
1828: and enabled_flag = 'Y'
1829: and sysdate between

Line 1833: l_lookup_meaning hr_lookups.meaning%TYPE;

1829: and sysdate between
1830: nvl(start_date_active, sysdate)
1831: and nvl(end_date_active, sysdate);
1832: --
1833: l_lookup_meaning hr_lookups.meaning%TYPE;
1834: --
1835: BEGIN
1836: --fetch vacancy_id for a given topic
1837: OPEN cur_lookup(p_lookup_code, p_lookup_type);