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.PAY_USER_TABLE_DETAILS_PKG dependencies on FND_DATE

Line 226: AND fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE) < val.effective_end_date;

222: AND val.legislation_code = X_LEGISLATION_CODE
223: AND pur.legislation_code = X_LEGISLATION_CODE
224: )
225: )
226: AND fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE) < val.effective_end_date;
227:
228:
229:
230: l_user_row_id NUMBER;

Line 271: AND fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE) BETWEEN effective_start_date AND effective_end_date;

267: legislation_code IS NULL
268: )
269: AND business_group_id IS NULL
270: AND user_table_id = l_user_table_id
271: AND fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE) BETWEEN effective_start_date AND effective_end_date;
272:
273:
274: IF (l_effective_start_date <> fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE))
275: THEN

Line 274: IF (l_effective_start_date <> fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE))

270: AND user_table_id = l_user_table_id
271: AND fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE) BETWEEN effective_start_date AND effective_end_date;
272:
273:
274: IF (l_effective_start_date <> fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE))
275: THEN
276: pay_user_row_api.update_user_row
277: (p_validate => FALSE
278: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)

Line 278: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)

274: IF (l_effective_start_date <> fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE))
275: THEN
276: pay_user_row_api.update_user_row
277: (p_validate => FALSE
278: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)
279: ,p_datetrack_update_mode => hr_api.g_update
280: ,p_user_row_id => l_user_row_id
281: ,p_display_sequence => l_display_sequence
282: ,p_object_version_number => l_object_version_number

Line 294: IF (l_effective_end_date <> fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE))

290: );
291:
292: END IF;
293:
294: IF (l_effective_end_date <> fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE))
295: THEN
296: FOR c_rec IN c_get_col_instance_id(l_user_row_id)
297: LOOP
298: pay_user_column_instance_api.delete_user_column_instance

Line 300: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE)

296: FOR c_rec IN c_get_col_instance_id(l_user_row_id)
297: LOOP
298: pay_user_column_instance_api.delete_user_column_instance
299: (p_validate => FALSE
300: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE)
301: ,p_user_column_instance_id => c_rec.column_instance_id
302: ,p_datetrack_update_mode => hr_api.g_delete
303: ,p_object_version_number => c_rec.object_version_number
304: ,p_effective_start_date => l_start_date

Line 311: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE)

307: END LOOP;
308:
309: pay_user_row_api.delete_user_row
310: (p_validate => FALSE
311: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE)
312: ,p_datetrack_update_mode => hr_api.g_delete
313: ,p_user_row_id => l_user_row_id
314: ,p_object_version_number => l_object_version_number
315: ,p_disable_range_overlap_check => FALSE

Line 330: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)

326: l_display_sequence := X_DISPLAY_SEQUENCE;
327:
328: pay_user_row_api.create_user_row
329: (p_validate => FALSE
330: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)
331: ,p_user_table_id => l_user_table_id
332: ,p_row_low_range_or_name => X_ROW_LOW_RANGE_OR_NAME
333: ,p_display_sequence => l_display_sequence
334: ,p_business_group_id => NULL

Line 349: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE)

345: IF (SUBSTR(X_EFFECTIVE_END_DATE,0,4) <> '4712')
346: THEN
347: pay_user_row_api.delete_user_row
348: (p_validate => FALSE
349: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE)
350: ,p_datetrack_update_mode => hr_api.g_delete
351: ,p_user_row_id => l_user_row_id
352: ,p_object_version_number => l_object_version_number
353: ,p_disable_range_overlap_check => FALSE

Line 492: AND fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)

488: AND put.user_table_name = X_USER_TABLE_NAME
489: AND put.legislation_code = X_LEGISLATION_CODE
490: AND pur.legislation_code = X_LEGISLATION_CODE
491: AND puc.legislation_code = X_LEGISLATION_CODE
492: AND fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)
493: BETWEEN pur.effective_start_date AND pur.effective_end_date ;
494:
495: l_user_table_id NUMBER;
496: l_user_row_id NUMBER;

Line 551: AND fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)

547: AND val.legislation_code = X_LEGISLATION_CODE
548: AND pur.legislation_code = X_LEGISLATION_CODE
549: )
550: )
551: AND fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)
552: BETWEEN val.effective_start_date AND val.effective_end_date
553: AND fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)
554: BETWEEN pur.effective_start_date AND pur.effective_end_date;
555:

Line 553: AND fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)

549: )
550: )
551: AND fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)
552: BETWEEN val.effective_start_date AND val.effective_end_date
553: AND fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)
554: BETWEEN pur.effective_start_date AND pur.effective_end_date;
555:
556: IF (l_effective_start_date <> fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE))
557: THEN

Line 556: IF (l_effective_start_date <> fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE))

552: BETWEEN val.effective_start_date AND val.effective_end_date
553: AND fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)
554: BETWEEN pur.effective_start_date AND pur.effective_end_date;
555:
556: IF (l_effective_start_date <> fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE))
557: THEN
558:
559: pay_user_column_instance_api.update_user_column_instance
560: (p_validate => FALSE

Line 561: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)

557: THEN
558:
559: pay_user_column_instance_api.update_user_column_instance
560: (p_validate => FALSE
561: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)
562: ,p_user_column_instance_id => l_user_col_instance_id
563: ,p_datetrack_update_mode => hr_api.g_update
564: ,p_value => X_VALUE
565: ,p_object_version_number => l_object_version_number

Line 572: IF (l_effective_end_date <> fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE))

568: );
569:
570: END IF;
571:
572: IF (l_effective_end_date <> fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE))
573: THEN
574:
575: pay_user_column_instance_api.delete_user_column_instance
576: (p_validate => FALSE

Line 577: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE)

573: THEN
574:
575: pay_user_column_instance_api.delete_user_column_instance
576: (p_validate => FALSE
577: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE)
578: ,p_user_column_instance_id => l_user_col_instance_id
579: ,p_datetrack_update_mode => hr_api.g_delete
580: ,p_object_version_number => l_object_version_number
581: ,p_effective_start_date => l_start_date

Line 600: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)

596: CLOSE c_row_col_details;
597:
598: pay_user_column_instance_api.create_user_column_instance
599: (p_validate => FALSE
600: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_START_DATE)
601: ,p_user_row_id => l_user_row_id
602: ,p_user_column_id => l_user_column_id
603: ,p_value => X_VALUE
604: ,p_business_group_id => NULL

Line 618: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE)

614: IF (SUBSTR(X_EFFECTIVE_END_DATE,0,4) <> TO_CHAR(l_end_date,'YYYY'))
615: THEN
616: pay_user_column_instance_api.delete_user_column_instance
617: (p_validate => FALSE
618: ,p_effective_date => fnd_date.canonical_to_date(X_EFFECTIVE_END_DATE)
619: ,p_user_column_instance_id => l_user_col_instance_id
620: ,p_datetrack_update_mode => hr_api.g_delete
621: ,p_object_version_number => l_object_version_number
622: ,p_effective_start_date => l_start_date