APPS.HRDPP_CREATE_PTNL_LER_FOR_PER dependencies on HR_PUMP_GET

Line 170: hr_pump_get.gl(l.pval003,'BEN_PTNL_LER_FOR_PER_STAT',d(l.pval014),vn)) p3,

166: l.pval001 p1,
167: decode(l.pval002,cn,dn,vn,dn,d(l.pval002)) p2,
168: l.pval002 d2,
169: decode(l.pval003,cn,vn,vn,vn,
170: hr_pump_get.gl(l.pval003,'BEN_PTNL_LER_FOR_PER_STAT',d(l.pval014),vn)) p3,
171: l.pval003 d3,
172: decode(l.pval004,cn,vn,vn,vn,
173: hr_pump_get.gl(l.pval004,'BEN_PTNL_LER_FOR_PER_SRC',d(l.pval014),vn)) p4,
174: l.pval004 d4,

Line 173: hr_pump_get.gl(l.pval004,'BEN_PTNL_LER_FOR_PER_SRC',d(l.pval014),vn)) p4,

169: decode(l.pval003,cn,vn,vn,vn,
170: hr_pump_get.gl(l.pval003,'BEN_PTNL_LER_FOR_PER_STAT',d(l.pval014),vn)) p3,
171: l.pval003 d3,
172: decode(l.pval004,cn,vn,vn,vn,
173: hr_pump_get.gl(l.pval004,'BEN_PTNL_LER_FOR_PER_SRC',d(l.pval014),vn)) p4,
174: l.pval004 d4,
175: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
176: l.pval005 d5,
177: decode(l.pval006,cn,dn,vn,dn,d(l.pval006)) p6,

Line 234: hr_pump_get.get_csd_by_ptnl_ler_for_per_id

230: if c.p15 is null then
231: L_CSD_BY_PTNL_LER_FOR_PER_ID:=nn;
232: else
233: L_CSD_BY_PTNL_LER_FOR_PER_ID :=
234: hr_pump_get.get_csd_by_ptnl_ler_for_per_id
235: (P_CSD_BY_PPL_USER_KEY => c.p15);
236: end if;
237: --
238: if c.p16 is null then

Line 242: hr_pump_get.get_trgr_table_pk_id

238: if c.p16 is null then
239: L_TRGR_TABLE_PK_ID:=nn;
240: else
241: L_TRGR_TABLE_PK_ID :=
242: hr_pump_get.get_trgr_table_pk_id
243: (P_TRGR_TABLE_PK_USER_KEY => c.p16);
244: end if;
245: --
246: if c.p17 is null then

Line 250: hr_pump_get.get_enrt_perd_id

246: if c.p17 is null then
247: L_ENRT_PERD_ID:=nn;
248: else
249: L_ENRT_PERD_ID :=
250: hr_pump_get.get_enrt_perd_id
251: (P_ENRT_PERD_USER_KEY => c.p17);
252: end if;
253: --
254: if c.p18 is null or

Line 259: hr_pump_get.get_ler_id

255: c.p14 is null then
256: L_LER_ID:=nn;
257: else
258: L_LER_ID :=
259: hr_pump_get.get_ler_id
260: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
261: ,P_LIFE_EVENT_REASON => c.p18
262: ,P_EFFECTIVE_DATE => c.p14);
263: end if;

Line 269: hr_pump_get.get_person_id

265: if c.p19 is null then
266: L_PERSON_ID:=nn;
267: else
268: L_PERSON_ID :=
269: hr_pump_get.get_person_id
270: (P_PERSON_USER_KEY => c.p19);
271: end if;
272: --
273: L_REQUEST_ID :=

Line 274: hr_pump_get.get_request_id;

270: (P_PERSON_USER_KEY => c.p19);
271: end if;
272: --
273: L_REQUEST_ID :=
274: hr_pump_get.get_request_id;
275: --
276: L_PROGRAM_APPLICATION_ID :=
277: hr_pump_get.get_program_application_id;
278: --

Line 277: hr_pump_get.get_program_application_id;

273: L_REQUEST_ID :=
274: hr_pump_get.get_request_id;
275: --
276: L_PROGRAM_APPLICATION_ID :=
277: hr_pump_get.get_program_application_id;
278: --
279: L_PROGRAM_ID :=
280: hr_pump_get.get_program_id;
281: --

Line 280: hr_pump_get.get_program_id;

276: L_PROGRAM_APPLICATION_ID :=
277: hr_pump_get.get_program_application_id;
278: --
279: L_PROGRAM_ID :=
280: hr_pump_get.get_program_id;
281: --
282: hr_data_pump.api_trc_on;
283: ben_ptnl_ler_for_per_api.CREATE_PTNL_LER_FOR_PER
284: (p_validate => l_validate