eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PL_ORG_INFO dependencies on FND_DATE

Line 136: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)

132: select 1
133: from hr_organization_information where
134: organization_id = ORG_ID and
135: org_information_context = ORG_INFO_TYPE_CODE and
136: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)
137: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
138: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
139: between fnd_date.canonical_to_date(ORG_INFORMATION1)
140: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or

Line 137: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or

133: from hr_organization_information where
134: organization_id = ORG_ID and
135: org_information_context = ORG_INFO_TYPE_CODE and
136: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)
137: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
138: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
139: between fnd_date.canonical_to_date(ORG_INFORMATION1)
140: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
141: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and

Line 138: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))

134: organization_id = ORG_ID and
135: org_information_context = ORG_INFO_TYPE_CODE and
136: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)
137: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
138: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
139: between fnd_date.canonical_to_date(ORG_INFORMATION1)
140: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
141: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
142: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or

Line 139: between fnd_date.canonical_to_date(ORG_INFORMATION1)

135: org_information_context = ORG_INFO_TYPE_CODE and
136: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)
137: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
138: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
139: between fnd_date.canonical_to_date(ORG_INFORMATION1)
140: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
141: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
142: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
143: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between

Line 140: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or

136: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)
137: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
138: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
139: between fnd_date.canonical_to_date(ORG_INFORMATION1)
140: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
141: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
142: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
143: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
144: fnd_date.canonical_to_date(P_FLEX_START_DATE) and

Line 141: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and

137: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
138: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
139: between fnd_date.canonical_to_date(ORG_INFORMATION1)
140: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
141: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
142: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
143: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
144: fnd_date.canonical_to_date(P_FLEX_START_DATE) and
145: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')));

Line 142: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or

138: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
139: between fnd_date.canonical_to_date(ORG_INFORMATION1)
140: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
141: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
142: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
143: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
144: fnd_date.canonical_to_date(P_FLEX_START_DATE) and
145: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')));
146:

Line 143: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between

139: between fnd_date.canonical_to_date(ORG_INFORMATION1)
140: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
141: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
142: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
143: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
144: fnd_date.canonical_to_date(P_FLEX_START_DATE) and
145: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')));
146:
147: cursor csr_org_dates is

Line 144: fnd_date.canonical_to_date(P_FLEX_START_DATE) and

140: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
141: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
142: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
143: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
144: fnd_date.canonical_to_date(P_FLEX_START_DATE) and
145: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')));
146:
147: cursor csr_org_dates is
148: select date_from, nvl(date_to,to_date('31/12/4712','DD/MM/YYYY')) from

Line 145: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')));

141: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
142: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
143: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
144: fnd_date.canonical_to_date(P_FLEX_START_DATE) and
145: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')));
146:
147: cursor csr_org_dates is
148: select date_from, nvl(date_to,to_date('31/12/4712','DD/MM/YYYY')) from
149: hr_organization_units where organization_id = ORG_ID;

Line 158: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) > fnd_date.canonical_to_date(P_FLEX_END_DATE)) then

154:
155: BEGIN
156:
157:
158: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) > fnd_date.canonical_to_date(P_FLEX_END_DATE)) then
159: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
160: -- This message will be 'Please enter a Start date >= End date
161: hr_utility.raise_error;
162: end if;

Line 174: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));

170: fetch csr_overlap_rec into overlap_found;
171: if csr_overlap_rec%found then
172: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');
173: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',ORG_INFO_TYPE_CODE||'_FLEX'));
174: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
175: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
176: hr_utility.raise_error;
177: end if;
178: close csr_overlap_rec;

Line 175: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));

171: if csr_overlap_rec%found then
172: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');
173: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',ORG_INFO_TYPE_CODE||'_FLEX'));
174: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
175: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
176: hr_utility.raise_error;
177: end if;
178: close csr_overlap_rec;
179:

Line 180: if ((nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) > org_end_date)

176: hr_utility.raise_error;
177: end if;
178: close csr_overlap_rec;
179:
180: if ((nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) > org_end_date)
181: or (fnd_date.canonical_to_date(P_FLEX_START_DATE) < org_start_date))then
182: hr_utility.set_message(800,'HR_ORG_DATE_RANGE_PL');
183: hr_utility.set_message_token('ORGINFO',hr_general.decode_lookup('PL_FORM_LABELS',ORG_INFO_TYPE_CODE));
184: -- This message will be 'Please enter date range so that it falls within org date range

Line 181: or (fnd_date.canonical_to_date(P_FLEX_START_DATE) < org_start_date))then

177: end if;
178: close csr_overlap_rec;
179:
180: if ((nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) > org_end_date)
181: or (fnd_date.canonical_to_date(P_FLEX_START_DATE) < org_start_date))then
182: hr_utility.set_message(800,'HR_ORG_DATE_RANGE_PL');
183: hr_utility.set_message_token('ORGINFO',hr_general.decode_lookup('PL_FORM_LABELS',ORG_INFO_TYPE_CODE));
184: -- This message will be 'Please enter date range so that it falls within org date range
185: hr_utility.raise_error;

Line 207: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)

203: select 1
204: from hr_organization_information where
205: organization_id = p_org_id and
206: org_information_context = P_ORG_INFO_TYPE_CODE and
207: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)
208: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
209: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
210: between fnd_date.canonical_to_date(ORG_INFORMATION1)
211: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or

Line 208: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or

204: from hr_organization_information where
205: organization_id = p_org_id and
206: org_information_context = P_ORG_INFO_TYPE_CODE and
207: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)
208: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
209: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
210: between fnd_date.canonical_to_date(ORG_INFORMATION1)
211: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
212: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and

Line 209: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))

205: organization_id = p_org_id and
206: org_information_context = P_ORG_INFO_TYPE_CODE and
207: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)
208: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
209: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
210: between fnd_date.canonical_to_date(ORG_INFORMATION1)
211: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
212: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
213: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or

Line 210: between fnd_date.canonical_to_date(ORG_INFORMATION1)

206: org_information_context = P_ORG_INFO_TYPE_CODE and
207: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)
208: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
209: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
210: between fnd_date.canonical_to_date(ORG_INFORMATION1)
211: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
212: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
213: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
214: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between

Line 211: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or

207: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)
208: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
209: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
210: between fnd_date.canonical_to_date(ORG_INFORMATION1)
211: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
212: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
213: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
214: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
215: fnd_date.canonical_to_date(P_FLEX_START_DATE) and

Line 212: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and

208: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
209: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
210: between fnd_date.canonical_to_date(ORG_INFORMATION1)
211: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
212: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
213: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
214: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
215: fnd_date.canonical_to_date(P_FLEX_START_DATE) and
216: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')))

Line 213: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or

209: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
210: between fnd_date.canonical_to_date(ORG_INFORMATION1)
211: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
212: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
213: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
214: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
215: fnd_date.canonical_to_date(P_FLEX_START_DATE) and
216: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')))
217: and org_information_id <> P_ORG_INFORMATION_ID;

Line 214: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between

210: between fnd_date.canonical_to_date(ORG_INFORMATION1)
211: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
212: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
213: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
214: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
215: fnd_date.canonical_to_date(P_FLEX_START_DATE) and
216: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')))
217: and org_information_id <> P_ORG_INFORMATION_ID;
218:

Line 215: fnd_date.canonical_to_date(P_FLEX_START_DATE) and

211: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
212: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
213: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
214: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
215: fnd_date.canonical_to_date(P_FLEX_START_DATE) and
216: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')))
217: and org_information_id <> P_ORG_INFORMATION_ID;
218:
219: cursor csr_org_dates is

Line 216: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')))

212: fnd_date.canonical_to_date(ORG_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
213: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
214: nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
215: fnd_date.canonical_to_date(P_FLEX_START_DATE) and
216: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')))
217: and org_information_id <> P_ORG_INFORMATION_ID;
218:
219: cursor csr_org_dates is
220: select date_from, nvl(date_to,to_date('31/12/4712','DD/MM/YYYY')) from

Line 229: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) > fnd_date.canonical_to_date(P_FLEX_END_DATE)) then

225: org_end_date date;
226:
227: BEGIN
228:
229: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) > fnd_date.canonical_to_date(P_FLEX_END_DATE)) then
230: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
231: -- This message will be 'Please enter a Start date >= End date
232: hr_utility.raise_error;
233: end if;

Line 245: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));

241: fetch csr_overlap_upd_rec into overlap_upd_found;
242: if csr_overlap_upd_rec%found then
243: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');
244: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_ORG_INFO_TYPE_CODE||'_FLEX'));
245: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
246: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
247: hr_utility.raise_error;
248: end if;
249: close csr_overlap_upd_rec;

Line 246: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));

242: if csr_overlap_upd_rec%found then
243: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');
244: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_ORG_INFO_TYPE_CODE||'_FLEX'));
245: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
246: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
247: hr_utility.raise_error;
248: end if;
249: close csr_overlap_upd_rec;
250:

Line 251: if ((nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) > org_end_date)

247: hr_utility.raise_error;
248: end if;
249: close csr_overlap_upd_rec;
250:
251: if ((nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) > org_end_date)
252: or (fnd_date.canonical_to_date(P_FLEX_START_DATE) < org_start_date))then
253: hr_utility.set_message(800,'HR_ORG_DATE_RANGE_PL');
254: hr_utility.set_message_token('ORGINFO',hr_general.decode_lookup('PL_FORM_LABELS',P_ORG_INFO_TYPE_CODE));
255: -- This message will be 'Please enter date range so that it falls within org date range

Line 252: or (fnd_date.canonical_to_date(P_FLEX_START_DATE) < org_start_date))then

248: end if;
249: close csr_overlap_upd_rec;
250:
251: if ((nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) > org_end_date)
252: or (fnd_date.canonical_to_date(P_FLEX_START_DATE) < org_start_date))then
253: hr_utility.set_message(800,'HR_ORG_DATE_RANGE_PL');
254: hr_utility.set_message_token('ORGINFO',hr_general.decode_lookup('PL_FORM_LABELS',P_ORG_INFO_TYPE_CODE));
255: -- This message will be 'Please enter date range so that it falls within org date range
256: hr_utility.raise_error;