DBA Data[Home] [Help]

APPS.IRC_UTILITIES_PKG dependencies on PER_ALL_PEOPLE_F

Line 102: FUNCTION GET_CURRENT_EMPLOYER (p_person_id per_all_people_f.person_id%TYPE default null,

98: -- Developer Implementation Notes:
99: --
100: -- {End Of Comments}
101:
102: FUNCTION GET_CURRENT_EMPLOYER (p_person_id per_all_people_f.person_id%TYPE default null,
103: p_eff_date date default trunc(sysdate))
104: RETURN VARCHAR2;
105:
106: FUNCTION GET_CURRENT_EMPLOYER_PTY (p_party_id number,

Line 135: FUNCTION GET_MAX_QUAL_TYPE (p_person_id per_all_people_f.person_id%TYPE default null)

131: -- Developer Implementation Notes:
132: --
133: -- {End Of Comments}
134:
135: FUNCTION GET_MAX_QUAL_TYPE (p_person_id per_all_people_f.person_id%TYPE default null)
136: RETURN VARCHAR2;
137: FUNCTION GET_MAX_QUAL_TYPE_PTY (p_party_id NUMBER)
138: RETURN VARCHAR2;
139: -- ----------------------------------------------------------------------------

Line 162: FUNCTION GET_EMP_UPT_FOR_PERSON (p_person_id per_all_people_f.person_id%TYPE default null,

158: -- Developer Implementation Notes:
159: --
160: -- {End Of Comments}
161:
162: FUNCTION GET_EMP_UPT_FOR_PERSON (p_person_id per_all_people_f.person_id%TYPE default null,
163: p_eff_date date default trunc(sysdate))
164: RETURN VARCHAR2;
165: --
166: FUNCTION GET_EMP_UPT_FOR_PARTY (p_party_id number,

Line 196: p_person_id per_all_people_f.person_id%TYPE default null,

192: --
193: -- {End Of Comments}
194:
195: FUNCTION GET_APL_UPT_FOR_PERSON (
196: p_person_id per_all_people_f.person_id%TYPE default null,
197: p_eff_date date default trunc(sysdate))
198: RETURN VARCHAR2;
199: --
200: FUNCTION GET_APL_UPT_FOR_PARTY (

Line 230: p_person_id per_all_people_f.person_id%TYPE default null,

226: --
227: -- {End Of Comments}
228:
229: FUNCTION GET_EMP_SPT_FOR_PERSON (
230: p_person_id per_all_people_f.person_id%TYPE default null,
231: p_eff_date date default trunc(sysdate))
232: RETURN VARCHAR2;
233:
234: --

Line 262: (p_person_id IN per_all_people_f.person_id%TYPE,

258: -- {End Of Comments}
259: --
260: --
261: FUNCTION GET_RECRUITMENT_PERSON_ID
262: (p_person_id IN per_all_people_f.person_id%TYPE,
263: p_effective_date IN per_all_people_f.effective_start_date%TYPE default trunc(sysdate))
264: RETURN per_all_people_f.person_id%TYPE;
265:
266: -- ----------------------------------------------------------------------------

Line 263: p_effective_date IN per_all_people_f.effective_start_date%TYPE default trunc(sysdate))

259: --
260: --
261: FUNCTION GET_RECRUITMENT_PERSON_ID
262: (p_person_id IN per_all_people_f.person_id%TYPE,
263: p_effective_date IN per_all_people_f.effective_start_date%TYPE default trunc(sysdate))
264: RETURN per_all_people_f.person_id%TYPE;
265:
266: -- ----------------------------------------------------------------------------
267: -- |-----------------------< IS_OPEN_PARTY >-------------------------|

Line 264: RETURN per_all_people_f.person_id%TYPE;

260: --
261: FUNCTION GET_RECRUITMENT_PERSON_ID
262: (p_person_id IN per_all_people_f.person_id%TYPE,
263: p_effective_date IN per_all_people_f.effective_start_date%TYPE default trunc(sysdate))
264: RETURN per_all_people_f.person_id%TYPE;
265:
266: -- ----------------------------------------------------------------------------
267: -- |-----------------------< IS_OPEN_PARTY >-------------------------|
268: -- ----------------------------------------------------------------------------