DBA Data[Home] [Help]

APPS.PER_US_VETS_100A_SINGLE_PKG dependencies on FND_DATE

Line 1105: P_DATE_END1 := fnd_date.canonical_to_date(P_DATE_END);

1101:
1102: begin
1103:
1104: l_business_group_name := hr_reports.get_business_group(p_business_group_id);
1105: P_DATE_END1 := fnd_date.canonical_to_date(P_DATE_END);
1106: c_report_year := to_char(fnd_date.canonical_to_date(P_DATE_END),'RRRR');
1107: c_report_month := to_char(fnd_date.canonical_to_date(P_DATE_END),'MM');
1108: c_report_day := to_char(fnd_date.canonical_to_date(P_DATE_END),'DD');
1109: c_report_year1 := substr(c_report_year,1,1);

Line 1106: c_report_year := to_char(fnd_date.canonical_to_date(P_DATE_END),'RRRR');

1102: begin
1103:
1104: l_business_group_name := hr_reports.get_business_group(p_business_group_id);
1105: P_DATE_END1 := fnd_date.canonical_to_date(P_DATE_END);
1106: c_report_year := to_char(fnd_date.canonical_to_date(P_DATE_END),'RRRR');
1107: c_report_month := to_char(fnd_date.canonical_to_date(P_DATE_END),'MM');
1108: c_report_day := to_char(fnd_date.canonical_to_date(P_DATE_END),'DD');
1109: c_report_year1 := substr(c_report_year,1,1);
1110: c_report_year2 := substr(c_report_year,2,1);

Line 1107: c_report_month := to_char(fnd_date.canonical_to_date(P_DATE_END),'MM');

1103:
1104: l_business_group_name := hr_reports.get_business_group(p_business_group_id);
1105: P_DATE_END1 := fnd_date.canonical_to_date(P_DATE_END);
1106: c_report_year := to_char(fnd_date.canonical_to_date(P_DATE_END),'RRRR');
1107: c_report_month := to_char(fnd_date.canonical_to_date(P_DATE_END),'MM');
1108: c_report_day := to_char(fnd_date.canonical_to_date(P_DATE_END),'DD');
1109: c_report_year1 := substr(c_report_year,1,1);
1110: c_report_year2 := substr(c_report_year,2,1);
1111: c_report_year3 := substr(c_report_year,3,1);

Line 1108: c_report_day := to_char(fnd_date.canonical_to_date(P_DATE_END),'DD');

1104: l_business_group_name := hr_reports.get_business_group(p_business_group_id);
1105: P_DATE_END1 := fnd_date.canonical_to_date(P_DATE_END);
1106: c_report_year := to_char(fnd_date.canonical_to_date(P_DATE_END),'RRRR');
1107: c_report_month := to_char(fnd_date.canonical_to_date(P_DATE_END),'MM');
1108: c_report_day := to_char(fnd_date.canonical_to_date(P_DATE_END),'DD');
1109: c_report_year1 := substr(c_report_year,1,1);
1110: c_report_year2 := substr(c_report_year,2,1);
1111: c_report_year3 := substr(c_report_year,3,1);
1112: c_report_year4 := substr(c_report_year,4,1);