APPS.IRC_COMMUNICATIONS_API dependencies on HR_LOOKUPS

Line 1558: l_meaning_rec hr_lookups.meaning%TYPE;

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

Line 1559: l_meaning_mgr hr_lookups.meaning%TYPE;

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

Line 1560: l_meaning_apl hr_lookups.meaning%TYPE;

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

Line 1561: l_meaning_tm hr_lookups.meaning%TYPE;

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

Line 1562: l_meaning_agncy hr_lookups.meaning%TYPE;

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

Line 1817: p_lookup_code hr_lookups.lookup_code%TYPE

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

Line 1818: ,p_lookup_type hr_lookups.lookup_type%TYPE)

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

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

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

Line 1823: select hr_lookups.meaning

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

Line 1824: from hr_lookups

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

Line 1832: l_lookup_meaning hr_lookups.meaning%TYPE;

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