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.

[Home] [Help]

APPS.HXC_RDB_PRE_RETRIEVAL dependencies on FND_PROFILE

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 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 779: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));

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')),
783: NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID'));

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 783: NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID'));

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,
787: stattab,

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 830: NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID'));

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,
834: tctab,

Line 867: l_pay_sql := REPLACE(l_pay_sql,'BUSINESSID',FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));

863:
864:
865: ELSIF p_application = 'PAY'
866: THEN
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('''||

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 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 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 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 1167: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);

1163:
1164: BEGIN
1165:
1166:
1167: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);
1168: l_language_code := USERENV('LANG');
1169:
1170: l_report_info := ' ';
1171:

Line 1390: AND TRUNC(start_time) = TO_DATE(p_start_time,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))

1386: BEGIN
1387:
1388: DELETE FROM hxc_locks
1389: WHERE resource_id = TO_NUMBER(p_resource_id)
1390: AND TRUNC(start_time) = TO_DATE(p_start_time,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
1391: AND TRUNC(stop_time) = TO_DATE(p_stop_time,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'));
1392: COMMIT;
1393:
1394:

Line 1391: AND TRUNC(stop_time) = TO_DATE(p_stop_time,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'));

1387:
1388: DELETE FROM hxc_locks
1389: WHERE resource_id = TO_NUMBER(p_resource_id)
1390: AND TRUNC(start_time) = TO_DATE(p_start_time,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
1391: AND TRUNC(stop_time) = TO_DATE(p_stop_time,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'));
1392: COMMIT;
1393:
1394:
1395: END release_timecard_lock;