APPS.HRDPP_UPDATE_IN_PASSPORT_DETAI dependencies on PER_IN_DATA_PUMP

Line 283: PER_IN_DATA_PUMP.get_person_extra_info_id

279: if c.p26 is null then
280: L_PERSON_EXTRA_INFO_ID:=nn;
281: else
282: L_PERSON_EXTRA_INFO_ID :=
283: PER_IN_DATA_PUMP.get_person_extra_info_id
284: (P_PERSON_EXTRA_INFO_USER_KEY => c.p26);
285: end if;
286: --
287: if c.p26 is null then

Line 291: PER_IN_DATA_PUMP.GET_PERSON_EXTRA_INFO_OVN

287: if c.p26 is null then
288: L_OBJECT_VERSION_NUMBER:=nn;
289: else
290: L_OBJECT_VERSION_NUMBER :=
291: PER_IN_DATA_PUMP.GET_PERSON_EXTRA_INFO_OVN
292: (P_PERSON_EXTRA_INFO_USER_KEY => c.p26);
293: end if;
294: --
295: if c.d27=cn then

Line 301: PER_IN_DATA_PUMP.GET_ISSUE_DATE

297: elsif c.d27 is null then
298: L_ISSUE_DATE:=vh;
299: else
300: L_ISSUE_DATE :=
301: PER_IN_DATA_PUMP.GET_ISSUE_DATE
302: (P_ISSUE_DATE => c.p27);
303: end if;
304: --
305: if c.d28=cn then

Line 311: PER_IN_DATA_PUMP.GET_EXPIRY_DATE

307: elsif c.d28 is null then
308: L_EXPIRY_DATE:=vh;
309: else
310: L_EXPIRY_DATE :=
311: PER_IN_DATA_PUMP.GET_EXPIRY_DATE
312: (P_EXPIRY_DATE => c.p28);
313: end if;
314: --
315: if c.d29=cn then

Line 321: PER_IN_DATA_PUMP.GET_PASSPORT_COUNTRY

317: elsif c.d29 is null then
318: L_ISSUING_COUNTRY:=vh;
319: else
320: L_ISSUING_COUNTRY :=
321: PER_IN_DATA_PUMP.GET_PASSPORT_COUNTRY
322: (P_ISSUING_COUNTRY => c.p29);
323: end if;
324: --
325: hr_data_pump.api_trc_on;