DBA Data[Home] [Help]

APPS.HRDPP_CREATE_IN_PASSPORT_DETAI dependencies on PER_IN_DATA_PUMP

Line 289: PER_IN_DATA_PUMP.GET_ISSUE_DATE

285: if c.p29 is null then
286: L_ISSUE_DATE:=vn;
287: else
288: L_ISSUE_DATE :=
289: PER_IN_DATA_PUMP.GET_ISSUE_DATE
290: (P_ISSUE_DATE => c.p29);
291: end if;
292: --
293: if c.p30 is null then

Line 297: PER_IN_DATA_PUMP.GET_EXPIRY_DATE

293: if c.p30 is null then
294: L_EXPIRY_DATE:=vn;
295: else
296: L_EXPIRY_DATE :=
297: PER_IN_DATA_PUMP.GET_EXPIRY_DATE
298: (P_EXPIRY_DATE => c.p30);
299: end if;
300: --
301: if c.p31 is null then

Line 305: PER_IN_DATA_PUMP.GET_PASSPORT_COUNTRY

301: if c.p31 is null then
302: L_ISSUING_COUNTRY:=vn;
303: else
304: L_ISSUING_COUNTRY :=
305: PER_IN_DATA_PUMP.GET_PASSPORT_COUNTRY
306: (P_ISSUING_COUNTRY => c.p31);
307: end if;
308: --
309: hr_data_pump.api_trc_on;