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_POST_RETRIEVAL dependencies on FND_PROFILE

Line 39: AND business_group_id = FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')

35: hxc_time_building_blocks SUM
36: WHERE ret.start_time BETWEEN :p_start_date
37: AND :p_end_date
38: AND ret.timecard_id = SUM.time_building_block_id
39: AND business_group_id = FND_PROFILE.VALUE(''PER_BUSINESS_GROUP_ID'')
40: PERSONCRITERIA
41: PAYROLLCRITERIA
42: BATCHCRITERIA
43: ORGCRITERIA

Line 62: AND ret.org_id = NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE(''ORG_ID''))

58: hxc_time_building_blocks SUM
59: WHERE ret.start_time BETWEEN :p_start_date
60: AND :p_end_date
61: AND ret.timecard_id = SUM.time_building_block_id
62: AND ret.org_id = NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE(''ORG_ID''))
63: PERSONCRITERIA
64: BATCHCRITERIA
65: ORGCRITERIA
66: ';

Line 1912: OPEN l_pay_cursor FOR l_pay_sql USING TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))

1908:
1909: END IF;
1910:
1911:
1912: OPEN l_pay_cursor FOR l_pay_sql USING TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
1913: ,TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'));
1914: LOOP
1915: FETCH l_pay_cursor BULK COLLECT INTO tctab,
1916: statustab,

Line 1913: ,TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'));

1909: END IF;
1910:
1911:
1912: OPEN l_pay_cursor FOR l_pay_sql USING TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
1913: ,TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'));
1914: LOOP
1915: FETCH l_pay_cursor BULK COLLECT INTO tctab,
1916: statustab,
1917: restab,

Line 1990: hr_utility.trace(' start : '||TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')));

1986: END IF;
1987:
1988: -- Bug 12605349
1989: hr_utility.trace(' sql : '||l_pa_sql);
1990: hr_utility.trace(' start : '||TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')));
1991: hr_utility.trace(' end : '||TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')));
1992: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));
1993:
1994:

Line 1991: hr_utility.trace(' end : '||TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')));

1987:
1988: -- Bug 12605349
1989: hr_utility.trace(' sql : '||l_pa_sql);
1990: hr_utility.trace(' start : '||TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')));
1991: hr_utility.trace(' end : '||TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')));
1992: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));
1993:
1994:
1995:

Line 1992: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));

1988: -- Bug 12605349
1989: hr_utility.trace(' sql : '||l_pa_sql);
1990: hr_utility.trace(' start : '||TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')));
1991: hr_utility.trace(' end : '||TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')));
1992: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));
1993:
1994:
1995:
1996: OPEN l_pay_cursor FOR l_pa_sql USING TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))

Line 1996: OPEN l_pay_cursor FOR l_pa_sql USING TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))

1992: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));
1993:
1994:
1995:
1996: OPEN l_pay_cursor FOR l_pa_sql USING TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
1997: ,TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'));
1998: LOOP
1999: FETCH l_pay_cursor BULK COLLECT INTO tctab,
2000: statustab,

Line 1997: ,TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'));

1993:
1994:
1995:
1996: OPEN l_pay_cursor FOR l_pa_sql USING TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
1997: ,TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'));
1998: LOOP
1999: FETCH l_pay_cursor BULK COLLECT INTO tctab,
2000: statustab,
2001: restab,

Line 2408: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);

2404:
2405: BEGIN
2406:
2407:
2408: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);
2409: l_language_code := USERENV('LANG');
2410:
2411: l_report_info := ' ';
2412: