DBA Data[Home] [Help]

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: /* Commented and added as a part of Bug#10239077 Starts
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: if p_date_start is not null then
677: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_START_DATE',
678: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_Start), calendar_aware => FND_DATE.calendar_aware_alt));

Line 678: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_Start), calendar_aware => FND_DATE.calendar_aware_alt));

674: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_End)));
675: end if; */
676: if p_date_start is not null then
677: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_START_DATE',
678: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_Start), calendar_aware => FND_DATE.calendar_aware_alt));
679: end if;
680:
681: if p_date_end is not null then
682: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_END_DATE',

Line 683: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_End), calendar_aware => FND_DATE.calendar_aware_alt));

679: end if;
680:
681: if p_date_end is not null then
682: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_END_DATE',
683: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_End), calendar_aware => FND_DATE.calendar_aware_alt));
684: end if;
685: /* Commented and added as a part of Bug#10239077 Ends */
686:
687: if p_Time_Start is not null then

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

820: X_Location_Id => l_Location_id,
821: X_Internal_Contact_Person_Id => null,
822: X_Organization_Run_By_Id => null,
823: X_Assignment_Id => l_Assignment_Id,
824: X_Date_Start => fnd_date.chardt_to_date(l_Date_Start),
825: X_Type => l_Type,
826: X_Comments => l_Comments,
827: X_Contact_Telephone_Number => null ,
828: X_Date_End => fnd_date.chardt_to_date(l_Date_End ),

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

824: X_Date_Start => fnd_date.chardt_to_date(l_Date_Start),
825: X_Type => l_Type,
826: X_Comments => l_Comments,
827: X_Contact_Telephone_Number => null ,
828: X_Date_End => fnd_date.chardt_to_date(l_Date_End ),
829: X_Emp_Or_Apl => 'E',
830: X_Event_Or_Interview => 'I' ,
831: X_External_Contact => null ,
832: X_Time_End => l_Time_End,

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

851: X_Attribute17 => null,
852: X_Attribute18 => null,
853: X_Attribute19 => null,
854: X_Attribute20 => null,
855: X_ctl_globals_end_of_time => fnd_date.chardt_to_date(l_Date_Start));
856: --
857: ELSE
858: --
859: PER_EVENTS_PKG.Insert_row(X_Rowid => l_Row_id,

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

862: X_Location_Id => l_Location_id,
863: X_Internal_Contact_Person_Id => null,
864: X_Organization_Run_By_Id => null,
865: X_Assignment_Id => l_Assignment_Id,
866: X_Date_Start => fnd_date.chardt_to_date(l_Date_Start),
867: X_Type => l_Type,
868: X_Comments => l_Comments,
869: X_Contact_Telephone_Number => null ,
870: X_Date_End => fnd_date.chardt_to_date(l_Date_End ),

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

866: X_Date_Start => fnd_date.chardt_to_date(l_Date_Start),
867: X_Type => l_Type,
868: X_Comments => l_Comments,
869: X_Contact_Telephone_Number => null ,
870: X_Date_End => fnd_date.chardt_to_date(l_Date_End ),
871: X_Emp_Or_Apl => 'E',
872: X_Event_Or_Interview => 'I' ,
873: X_External_Contact => null ,
874: X_Time_End => l_Time_End,

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

893: X_Attribute17 => null,
894: X_Attribute18 => null,
895: X_Attribute19 => null,
896: X_Attribute20 => null,
897: X_ctl_globals_end_of_time => fnd_date.chardt_to_date(l_Date_Start));
898: --
899: END IF;
900:
901: pkg_event_id := l_Event_id;