APPS.PAY_PYCAROEP_XMLP_PKG dependencies on FND_DATE

Line 79: CP_start_date := fnd_date.canonical_to_date(p_start_date);

75: CP_selection_type := l_selection_type;
76:
77: End if;
78:
79: CP_start_date := fnd_date.canonical_to_date(p_start_date);
80: CP_end_date := fnd_date.canonical_to_date(p_end_date);
81:
82:
83: Open csr_get_trace_param;

Line 80: CP_end_date := fnd_date.canonical_to_date(p_end_date);

76:
77: End if;
78:
79: CP_start_date := fnd_date.canonical_to_date(p_start_date);
80: CP_end_date := fnd_date.canonical_to_date(p_end_date);
81:
82:
83: Open csr_get_trace_param;
84: Fetch csr_get_trace_param into l_trace;

Line 103: LP_DATE_OR_PERSON := ' AND fnd_date.canonical_to_date(pcrv.roe_date) BETWEEN fnd_date.canonical_TO_DATE(:P_START_DATE) '||

99:
100: If ((P_START_DATE is not NULL) and (P_END_DATE is not NULL)) then
101: begin
102: If P_PERSON_ID IS NOT NULL then
103: LP_DATE_OR_PERSON := ' AND fnd_date.canonical_to_date(pcrv.roe_date) BETWEEN fnd_date.canonical_TO_DATE(:P_START_DATE) '||
104: ' AND fnd_date.canonical_TO_DATE(:P_END_DATE)'||
105: ' AND paf.person_id=to_number(:P_PERSON_ID)';
106:
107: Elsif P_ASSIGNMENT_SET is NOT NULL then

Line 104: ' AND fnd_date.canonical_TO_DATE(:P_END_DATE)'||

100: If ((P_START_DATE is not NULL) and (P_END_DATE is not NULL)) then
101: begin
102: If P_PERSON_ID IS NOT NULL then
103: LP_DATE_OR_PERSON := ' AND fnd_date.canonical_to_date(pcrv.roe_date) BETWEEN fnd_date.canonical_TO_DATE(:P_START_DATE) '||
104: ' AND fnd_date.canonical_TO_DATE(:P_END_DATE)'||
105: ' AND paf.person_id=to_number(:P_PERSON_ID)';
106:
107: Elsif P_ASSIGNMENT_SET is NOT NULL then
108: LP_ASSIGNMENT_SET := ', HR_ASSIGNMENT_SET_AMENDMENTS haa';

Line 109: LP_DATE_OR_PERSON := ' AND fnd_date.canonical_to_date(pcrv.roe_date) BETWEEN fnd_date.canonical_to_DATE(:P_START_DATE) AND fnd_date.canonical_TO_DATE(:P_END_DATE)'||

105: ' AND paf.person_id=to_number(:P_PERSON_ID)';
106:
107: Elsif P_ASSIGNMENT_SET is NOT NULL then
108: LP_ASSIGNMENT_SET := ', HR_ASSIGNMENT_SET_AMENDMENTS haa';
109: LP_DATE_OR_PERSON := ' AND fnd_date.canonical_to_date(pcrv.roe_date) BETWEEN fnd_date.canonical_to_DATE(:P_START_DATE) AND fnd_date.canonical_TO_DATE(:P_END_DATE)'||
110: ' AND haa.assignment_id = paf.assignment_id AND haa.include_or_exclude = ''I''' ||
111: ' AND haa.assignment_set_id = to_number(:P_ASSIGNMENT_SET)';
112:
113: Else

Line 114: LP_DATE_OR_PERSON := ' AND fnd_date.canonical_to_date(pcrv.roe_date) BETWEEN fnd_date.canonical_to_DATE(:P_START_DATE) AND fnd_date.canonical_TO_DATE(:P_END_DATE)';

110: ' AND haa.assignment_id = paf.assignment_id AND haa.include_or_exclude = ''I''' ||
111: ' AND haa.assignment_set_id = to_number(:P_ASSIGNMENT_SET)';
112:
113: Else
114: LP_DATE_OR_PERSON := ' AND fnd_date.canonical_to_date(pcrv.roe_date) BETWEEN fnd_date.canonical_to_DATE(:P_START_DATE) AND fnd_date.canonical_TO_DATE(:P_END_DATE)';
115: End if;
116: end;
117: Elsif P_PERSON_ID is not NULL then
118: LP_DATE_OR_PERSON := 'AND paf.person_id=to_number(:P_PERSON_ID)';