APPS.PER_PERUSE1L_XMLP_PKG dependencies on FND_DATE

Line 31: C_PAYROLL_PERIOD_DATE_START := FND_DATE.CANONICAL_TO_DATE(P_PAYROLL_PERIOD_DATE_START);

27: L_DUMMY:=P_REPORT_YEARVALIDTRIGGER;
28: C_END_OF_TIME := hr_general.END_OF_TIME;
29: C_BUSINESS_GROUP_NAME := hr_reports.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
30: C_MAXIMUM_NO_OF_EMPLOYEES := P_MAXIMUM_NO_OF_EMPLOYEES;
31: C_PAYROLL_PERIOD_DATE_START := FND_DATE.CANONICAL_TO_DATE(P_PAYROLL_PERIOD_DATE_START);
32: C_PAYROLL_PERIOD_DATE_END := FND_DATE.CANONICAL_TO_DATE(P_PAYROLL_PERIOD_DATE_END);
33: C_REPORT_YEAR := P_REPORT_YEAR;
34: C_REPORT_DATE := TRUNC(SYSDATE);
35: SELECT

Line 32: C_PAYROLL_PERIOD_DATE_END := FND_DATE.CANONICAL_TO_DATE(P_PAYROLL_PERIOD_DATE_END);

28: C_END_OF_TIME := hr_general.END_OF_TIME;
29: C_BUSINESS_GROUP_NAME := hr_reports.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
30: C_MAXIMUM_NO_OF_EMPLOYEES := P_MAXIMUM_NO_OF_EMPLOYEES;
31: C_PAYROLL_PERIOD_DATE_START := FND_DATE.CANONICAL_TO_DATE(P_PAYROLL_PERIOD_DATE_START);
32: C_PAYROLL_PERIOD_DATE_END := FND_DATE.CANONICAL_TO_DATE(P_PAYROLL_PERIOD_DATE_END);
33: C_REPORT_YEAR := P_REPORT_YEAR;
34: C_REPORT_DATE := TRUNC(SYSDATE);
35: SELECT
36: PGH.NAME,

Line 83: P_REPORT_YEAR := TO_CHAR(FND_DATE.CANONICAL_TO_DATE(P_PAYROLL_PERIOD_DATE_END)

79:
80: FUNCTION P_REPORT_YEARVALIDTRIGGER RETURN BOOLEAN IS
81: BEGIN
82: IF P_PAYROLL_PERIOD_DATE_END IS NOT NULL THEN
83: P_REPORT_YEAR := TO_CHAR(FND_DATE.CANONICAL_TO_DATE(P_PAYROLL_PERIOD_DATE_END)
84: ,'YYYY');
85: ELSE
86: P_REPORT_YEAR := TO_CHAR(SYSDATE
87: ,'YYYY');

Line 109: L_DATE_END DATE := FND_DATE.CANONICAL_TO_DATE(P_PAYROLL_PERIOD_DATE_END);

105: L_E_ACT2 VARCHAR2(150) := NULL;
106: L_E_ACT3 VARCHAR2(150) := NULL;
107: L_E_ACT4 VARCHAR2(150) := NULL;
108: L_ACTIVITY VARCHAR2(150) := NULL;
109: L_DATE_END DATE := FND_DATE.CANONICAL_TO_DATE(P_PAYROLL_PERIOD_DATE_END);
110: L_DATE_START DATE := FND_DATE.CANONICAL_TO_DATE(P_PAYROLL_PERIOD_DATE_START);
111: L_COUNT_EMPS NUMBER := 0;
112: L_REPORT_EMPS NUMBER := 0;
113: L_BUFFER VARCHAR2(2000);

Line 110: L_DATE_START DATE := FND_DATE.CANONICAL_TO_DATE(P_PAYROLL_PERIOD_DATE_START);

106: L_E_ACT3 VARCHAR2(150) := NULL;
107: L_E_ACT4 VARCHAR2(150) := NULL;
108: L_ACTIVITY VARCHAR2(150) := NULL;
109: L_DATE_END DATE := FND_DATE.CANONICAL_TO_DATE(P_PAYROLL_PERIOD_DATE_END);
110: L_DATE_START DATE := FND_DATE.CANONICAL_TO_DATE(P_PAYROLL_PERIOD_DATE_START);
111: L_COUNT_EMPS NUMBER := 0;
112: L_REPORT_EMPS NUMBER := 0;
113: L_BUFFER VARCHAR2(2000);
114: G_DELIMITER VARCHAR2(1) := ',';