APPS.PERFRPHR dependencies on FND_DATE

Line 289: TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY') proposed_end_date,

285: -- modifying for bug#4083763
286: --DECODE(con.ctr_information2,'FIXED_TERM','D','PERMANENT','I') app_contract_cat,
287: DECODE(con.ctr_information2,'FIXED_TERM','1','PERMANENT','2','NEW_HIRE_CONTRACT','4', decode(OI1.ORG_INFORMATION8, 'Y', '3')) app_contract_cat,
288: --
289: TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY') proposed_end_date,
290: DECODE(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),NULL
291: ,TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY')
292: ,TO_CHAR(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),'DDMMYYYY')) con_end_date,
293: ext.rowid row_id,

Line 291: ,TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY')

287: DECODE(con.ctr_information2,'FIXED_TERM','1','PERMANENT','2','NEW_HIRE_CONTRACT','4', decode(OI1.ORG_INFORMATION8, 'Y', '3')) app_contract_cat,
288: --
289: TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY') proposed_end_date,
290: DECODE(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),NULL
291: ,TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY')
292: ,TO_CHAR(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),'DDMMYYYY')) con_end_date,
293: ext.rowid row_id,
294: ext.aei_information4 app_titulair,
295: ext.aei_information5 app_status_before_hire,

Line 395: TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY') proposed_end_date,

391: -- modifying for bug#4083763
392: --DECODE(con.ctr_information2,'FIXED_TERM','D','PERMANENT','I') app_contract_cat,
393: DECODE(con.ctr_information2,'FIXED_TERM','1','PERMANENT','2','NEW_HIRE_CONTRACT','4', decode(OI1.ORG_INFORMATION8, 'Y', '3')) app_contract_cat,
394: --
395: TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY') proposed_end_date,
396: DECODE(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),NULL
397: ,TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY')
398: ,TO_CHAR(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),'DDMMYYYY')) con_end_date,
399: ext.rowid row_id,

Line 397: ,TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY')

393: DECODE(con.ctr_information2,'FIXED_TERM','1','PERMANENT','2','NEW_HIRE_CONTRACT','4', decode(OI1.ORG_INFORMATION8, 'Y', '3')) app_contract_cat,
394: --
395: TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY') proposed_end_date,
396: DECODE(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),NULL
397: ,TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY')
398: ,TO_CHAR(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),'DDMMYYYY')) con_end_date,
399: ext.rowid row_id,
400: ext.aei_information4 app_titulair,
401: ext.aei_information5 app_status_before_hire,

Line 790: l_date := fnd_date.canonical_to_date(p_date);

786: /********************---*==MAIN==*---*************************/
787: /********************-----*==*==*----*************************/
788: BEGIN
789: --
790: l_date := fnd_date.canonical_to_date(p_date);
791: IF p_person_id IS NULL AND p_establishment_id IS NULL THEN
792: l_trace := 'Writing to error log1';
793: fnd_file.put_line(FND_FILE.LOG,REPLACE(fnd_message.get_string('PER','PER_74857_NULL_PERSON_ESTAB'),fnd_global.local_chr(13),NULL));
794: l_error := TRUE;

Line 1081: aei_information12 = fnd_date.date_to_canonical(sysdate)

1077: --
1078: l_trace := 'Updating per_assignment_extra_info';
1079: UPDATE per_assignment_extra_info
1080: SET aei_information11 = 'N',
1081: aei_information12 = fnd_date.date_to_canonical(sysdate)
1082: WHERE rowid = r_app.row_id;
1083: --
1084: END IF; --l_error
1085: --