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

Line 43: WHERE ret.last_update_date >= FND_DATE.canonical_to_date(:SINCEDATE)

39: ORDER BY ret.last_update_date DESC,
40: ret.time_building_block_id DESC)
41: FROM hxc_pa_latest_details ret,
42: hxc_timecard_summary sum
43: WHERE ret.last_update_date >= FND_DATE.canonical_to_date(:SINCEDATE)
44: AND ret.timecard_id = sum.timecard_id
45: AND ret.org_id = :ORGID ';
46:
47:

Line 763: l_pa_sql := l_pa_sql||' AND sum.start_time >= fnd_date.canonical_to_date('''||

759: END IF;
760:
761: IF p_start_date IS NOT NULL
762: THEN
763: l_pa_sql := l_pa_sql||' AND sum.start_time >= fnd_date.canonical_to_date('''||
764: fnd_date.date_to_canonical(TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
765: )||''') ';
766: END IF;
767:

Line 764: fnd_date.date_to_canonical(TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))

760:
761: IF p_start_date IS NOT NULL
762: THEN
763: l_pa_sql := l_pa_sql||' AND sum.start_time >= fnd_date.canonical_to_date('''||
764: fnd_date.date_to_canonical(TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
765: )||''') ';
766: END IF;
767:
768: IF p_end_date IS NOT NULL

Line 770: l_pa_sql := l_pa_sql||' AND TRUNC(sum.stop_time) <= fnd_date.canonical_to_date('''||

766: END IF;
767:
768: IF p_end_date IS NOT NULL
769: THEN
770: l_pa_sql := l_pa_sql||' AND TRUNC(sum.stop_time) <= fnd_date.canonical_to_date('''||
771: fnd_date.date_to_canonical(TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
772: )||''') ';
773: END IF;
774:

Line 771: fnd_date.date_to_canonical(TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))

767:
768: IF p_end_date IS NOT NULL
769: THEN
770: l_pa_sql := l_pa_sql||' AND TRUNC(sum.stop_time) <= fnd_date.canonical_to_date('''||
771: fnd_date.date_to_canonical(TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
772: )||''') ';
773: END IF;
774:
775:

Line 778: hr_utility.trace(' Since_date: '||FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')));

774:
775:
776: -- Bug 12605349
777: hr_utility.trace(' sql: '||l_pa_sql);
778: hr_utility.trace(' Since_date: '||FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')));
779: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));
780:
781: OPEN l_pa_cursor FOR l_pa_sql
782: USING FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')),

Line 782: USING FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')),

778: hr_utility.trace(' Since_date: '||FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')));
779: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));
780:
781: OPEN l_pa_cursor FOR l_pa_sql
782: USING FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')),
783: NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID'));
784: LOOP
785: FETCH l_pa_cursor BULK COLLECT INTO restab,
786: tctab,

Line 825: l_pa_sql := REPLACE(l_pa_sql,'ret.last_update_date >= FND_DATE.canonical_to_date',

821:
822: CLOSE l_pa_cursor;
823:
824:
825: l_pa_sql := REPLACE(l_pa_sql,'ret.last_update_date >= FND_DATE.canonical_to_date',
826: 'ret.last_update_date < FND_DATE.canonical_to_date');
827:
828: OPEN l_pa_cursor FOR l_pa_sql
829: USING FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')),

Line 826: 'ret.last_update_date < FND_DATE.canonical_to_date');

822: CLOSE l_pa_cursor;
823:
824:
825: l_pa_sql := REPLACE(l_pa_sql,'ret.last_update_date >= FND_DATE.canonical_to_date',
826: 'ret.last_update_date < FND_DATE.canonical_to_date');
827:
828: OPEN l_pa_cursor FOR l_pa_sql
829: USING FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')),
830: NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID'));

Line 829: USING FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')),

825: l_pa_sql := REPLACE(l_pa_sql,'ret.last_update_date >= FND_DATE.canonical_to_date',
826: 'ret.last_update_date < FND_DATE.canonical_to_date');
827:
828: OPEN l_pa_cursor FOR l_pa_sql
829: USING FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')),
830: NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID'));
831:
832: LOOP
833: FETCH l_pa_cursor BULK COLLECT INTO restab,

Line 871: l_pay_sql := l_pay_sql||' AND sum.start_time >= fnd_date.canonical_to_date('''||

867: l_pay_sql := REPLACE(l_pay_sql,'BUSINESSID',FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));
868:
869: IF p_start_date IS NOT NULL
870: THEN
871: l_pay_sql := l_pay_sql||' AND sum.start_time >= fnd_date.canonical_to_date('''||
872: fnd_date.date_to_canonical(TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
873: )||''') ';
874: END IF;
875: IF p_end_date IS NOT NULL

Line 872: fnd_date.date_to_canonical(TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))

868:
869: IF p_start_date IS NOT NULL
870: THEN
871: l_pay_sql := l_pay_sql||' AND sum.start_time >= fnd_date.canonical_to_date('''||
872: fnd_date.date_to_canonical(TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
873: )||''') ';
874: END IF;
875: IF p_end_date IS NOT NULL
876: THEN

Line 877: l_pay_sql := l_pay_sql||' AND TRUNC(sum.stop_time) <= fnd_date.canonical_to_date('''||

873: )||''') ';
874: END IF;
875: IF p_end_date IS NOT NULL
876: THEN
877: l_pay_sql := l_pay_sql||' AND TRUNC(sum.stop_time) <= fnd_date.canonical_to_date('''||
878: fnd_date.date_to_canonical(TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
879: )||''') ';
880:
881: END IF;

Line 878: fnd_date.date_to_canonical(TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))

874: END IF;
875: IF p_end_date IS NOT NULL
876: THEN
877: l_pay_sql := l_pay_sql||' AND TRUNC(sum.stop_time) <= fnd_date.canonical_to_date('''||
878: fnd_date.date_to_canonical(TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
879: )||''') ';
880:
881: END IF;
882:

Line 890: l_pay_sql := l_pay_sql||' AND ret.last_update_date >= fnd_date.canonical_to_date('''||

886: END IF;
887:
888: IF p_changes_since IS NOT NULL
889: THEN
890: l_pay_sql := l_pay_sql||' AND ret.last_update_date >= fnd_date.canonical_to_date('''||
891: fnd_date.date_to_canonical(TO_DATE(p_changes_since,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
892: )||''') ';
893:
894: ELSE

Line 891: fnd_date.date_to_canonical(TO_DATE(p_changes_since,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))

887:
888: IF p_changes_since IS NOT NULL
889: THEN
890: l_pay_sql := l_pay_sql||' AND ret.last_update_date >= fnd_date.canonical_to_date('''||
891: fnd_date.date_to_canonical(TO_DATE(p_changes_since,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
892: )||''') ';
893:
894: ELSE
895: l_pay_sql := l_pay_sql||' AND ret.last_update_date >= fnd_date.canonical_to_date('''||

Line 895: l_pay_sql := l_pay_sql||' AND ret.last_update_date >= fnd_date.canonical_to_date('''||

891: fnd_date.date_to_canonical(TO_DATE(p_changes_since,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
892: )||''') ';
893:
894: ELSE
895: l_pay_sql := l_pay_sql||' AND ret.last_update_date >= fnd_date.canonical_to_date('''||
896: fnd_date.date_to_canonical(SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE'))||''') ';
897: END IF;
898:
899:

Line 896: fnd_date.date_to_canonical(SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE'))||''') ';

892: )||''') ';
893:
894: ELSE
895: l_pay_sql := l_pay_sql||' AND ret.last_update_date >= fnd_date.canonical_to_date('''||
896: fnd_date.date_to_canonical(SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE'))||''') ';
897: END IF;
898:
899:
900: IF COALESCE(p_payroll_id,p_gre_id,p_org_id) IS NOT NULL

Line 962: l_pay_sql := REPLACE(l_pay_sql,' AND ret.last_update_date >= fnd_date.canonical_to_date(',

958: END LOOP;
959:
960: CLOSE l_pay_cursor;
961:
962: l_pay_sql := REPLACE(l_pay_sql,' AND ret.last_update_date >= fnd_date.canonical_to_date(',
963: ' AND ret.last_update_date < fnd_date.canonical_to_date(');
964: OPEN l_pay_cursor FOR l_pay_sql;
965: LOOP
966: FETCH l_pay_cursor BULK COLLECT INTO restab,

Line 963: ' AND ret.last_update_date < fnd_date.canonical_to_date(');

959:
960: CLOSE l_pay_cursor;
961:
962: l_pay_sql := REPLACE(l_pay_sql,' AND ret.last_update_date >= fnd_date.canonical_to_date(',
963: ' AND ret.last_update_date < fnd_date.canonical_to_date(');
964: OPEN l_pay_cursor FOR l_pay_sql;
965: LOOP
966: FETCH l_pay_cursor BULK COLLECT INTO restab,
967: tctab,