APPS.PQH_PROCESS_EMP_REVIEW dependencies on FND_DATE

Line 61: fnd_date.canonical_to_date(review.date_start) date_start,

57: SELECT
58: to_number(review.event_id) event_id,
59: review.Type,
60: hl.meaning,
61: fnd_date.canonical_to_date(review.date_start) date_start,
62: fnd_date.canonical_to_date(review.date_end) date_end,
63: review.time_start time_start,
64: review.time_end time_end ,
65: to_number(review.location_id) location_id ,

Line 62: fnd_date.canonical_to_date(review.date_end) date_end,

58: to_number(review.event_id) event_id,
59: review.Type,
60: hl.meaning,
61: fnd_date.canonical_to_date(review.date_start) date_start,
62: fnd_date.canonical_to_date(review.date_end) date_end,
63: review.time_start time_start,
64: review.time_end time_end ,
65: to_number(review.location_id) location_id ,
66: loc.location_code location,

Line 669: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_Start)));

665: end if;
666:
667: if p_date_start is not null then
668: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_START_DATE',
669: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_Start)));
670: end if;
671:
672: if p_date_end is not null then
673: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_END_DATE',

Line 674: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_End)));

670: end if;
671:
672: if p_date_end is not null then
673: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_END_DATE',
674: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_End)));
675: end if;
676:
677: if p_Time_Start is not null then
678: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_START_TIME', p_Time_Start);

Line 809: X_Date_Start => fnd_date.chardt_to_date(l_Date_Start),

805: X_Location_Id => l_Location_id,
806: X_Internal_Contact_Person_Id => null,
807: X_Organization_Run_By_Id => null,
808: X_Assignment_Id => l_Assignment_Id,
809: X_Date_Start => fnd_date.chardt_to_date(l_Date_Start),
810: X_Type => l_Type,
811: X_Comments => l_Comments,
812: X_Contact_Telephone_Number => null ,
813: X_Date_End => fnd_date.chardt_to_date(l_Date_End ),

Line 813: X_Date_End => fnd_date.chardt_to_date(l_Date_End ),

809: X_Date_Start => fnd_date.chardt_to_date(l_Date_Start),
810: X_Type => l_Type,
811: X_Comments => l_Comments,
812: X_Contact_Telephone_Number => null ,
813: X_Date_End => fnd_date.chardt_to_date(l_Date_End ),
814: X_Emp_Or_Apl => 'E',
815: X_Event_Or_Interview => 'I' ,
816: X_External_Contact => null ,
817: X_Time_End => l_Time_End,

Line 840: X_ctl_globals_end_of_time => fnd_date.chardt_to_date(l_Date_Start));

836: X_Attribute17 => null,
837: X_Attribute18 => null,
838: X_Attribute19 => null,
839: X_Attribute20 => null,
840: X_ctl_globals_end_of_time => fnd_date.chardt_to_date(l_Date_Start));
841: --
842: ELSE
843: --
844: PER_EVENTS_PKG.Insert_row(X_Rowid => l_Row_id,

Line 851: X_Date_Start => fnd_date.chardt_to_date(l_Date_Start),

847: X_Location_Id => l_Location_id,
848: X_Internal_Contact_Person_Id => null,
849: X_Organization_Run_By_Id => null,
850: X_Assignment_Id => l_Assignment_Id,
851: X_Date_Start => fnd_date.chardt_to_date(l_Date_Start),
852: X_Type => l_Type,
853: X_Comments => l_Comments,
854: X_Contact_Telephone_Number => null ,
855: X_Date_End => fnd_date.chardt_to_date(l_Date_End ),

Line 855: X_Date_End => fnd_date.chardt_to_date(l_Date_End ),

851: X_Date_Start => fnd_date.chardt_to_date(l_Date_Start),
852: X_Type => l_Type,
853: X_Comments => l_Comments,
854: X_Contact_Telephone_Number => null ,
855: X_Date_End => fnd_date.chardt_to_date(l_Date_End ),
856: X_Emp_Or_Apl => 'E',
857: X_Event_Or_Interview => 'I' ,
858: X_External_Contact => null ,
859: X_Time_End => l_Time_End,

Line 882: X_ctl_globals_end_of_time => fnd_date.chardt_to_date(l_Date_Start));

878: X_Attribute17 => null,
879: X_Attribute18 => null,
880: X_Attribute19 => null,
881: X_Attribute20 => null,
882: X_ctl_globals_end_of_time => fnd_date.chardt_to_date(l_Date_Start));
883: --
884: END IF;
885:
886: pkg_event_id := l_Event_id;