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_RETRIEVAL_ROLLBACK dependencies on FND_GLOBAL

Line 870: p_batch_name => 'REV_'||p_batch_id||'_'||FND_GLOBAL.conc_request_id,

866: END IF;
867:
868: pay_batch_element_entry_api.create_batch_header
869: (p_session_date => SYSDATE,
870: p_batch_name => 'REV_'||p_batch_id||'_'||FND_GLOBAL.conc_request_id,
871: p_business_group_id => FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'),
872: p_batch_reference => 'REV_'||p_batch_id,
873: p_batch_source => 'Time Store',
874: p_action_if_exists => 'I',

Line 1820: l_batch_filter := FND_GLOBAL.newline||' AND ( batch_id IN '||p_batches_list||FND_GLOBAL.newline||

1816: l_person_list :='AND tc.resource_id = '||p_person_id;
1817: l_query := l_query||l_person_list;
1818: END IF;
1819:
1820: l_batch_filter := FND_GLOBAL.newline||' AND ( batch_id IN '||p_batches_list||FND_GLOBAL.newline||
1821: ' OR retro_batch_id in '||p_batches_list||')';
1822:
1823:
1824:

Line 1829: l_start_date_filter := FND_GLOBAL.newline||' AND tc.start_time >= '''||p_start_date||'''';

1825:
1826:
1827: IF p_start_date IS NOT NULL
1828: THEN
1829: l_start_date_filter := FND_GLOBAL.newline||' AND tc.start_time >= '''||p_start_date||'''';
1830: END IF;
1831:
1832: IF p_end_date IS NOT NULL
1833: THEN

Line 1834: l_end_date_filter := FND_GLOBAL.newline||' AND TRUNC(tc.stop_time) <= '''||p_end_date||'''';

1830: END IF;
1831:
1832: IF p_end_date IS NOT NULL
1833: THEN
1834: l_end_date_filter := FND_GLOBAL.newline||' AND TRUNC(tc.stop_time) <= '''||p_end_date||'''';
1835: END IF;
1836:
1837: IF p_location_id IS NOT NULL
1838: THEN

Line 1839: l_location_filter := FND_GLOBAL.newline||' AND paf.location_id = '||p_location_id;

1835: END IF;
1836:
1837: IF p_location_id IS NOT NULL
1838: THEN
1839: l_location_filter := FND_GLOBAL.newline||' AND paf.location_id = '||p_location_id;
1840: END iF;
1841:
1842: IF p_organization_id IS NOT NULL
1843: THEN

Line 1844: l_org_filter := FND_GLOBAL.newline||' AND paf.organization_id = '||p_organization_id;

1840: END iF;
1841:
1842: IF p_organization_id IS NOT NULL
1843: THEN
1844: l_org_filter := FND_GLOBAL.newline||' AND paf.organization_id = '||p_organization_id;
1845: END iF;
1846:
1847: IF p_payroll_id IS NOT NULL
1848: THEN

Line 1849: l_payroll_filter := FND_GLOBAL.newline||' AND paf.payroll_id = '||p_payroll_id;

1845: END iF;
1846:
1847: IF p_payroll_id IS NOT NULL
1848: THEN
1849: l_payroll_filter := FND_GLOBAL.newline||' AND paf.payroll_id = '||p_payroll_id;
1850: END iF;
1851:
1852:
1853: IF p_gre_id IS NULL

Line 1855: l_asg_criteria := FND_GLOBAL.newline||' AND tc.resource_id IN ( SELECT person_id

1851:
1852:
1853: IF p_gre_id IS NULL
1854: THEN
1855: l_asg_criteria := FND_GLOBAL.newline||' AND tc.resource_id IN ( SELECT person_id
1856: FROM per_all_assignments_f paf
1857: WHERE business_group_id = '||p_bg_id
1858: ||l_location_filter
1859: ||l_org_filter

Line 1864: l_asg_criteria := FND_GLOBAL.newline||' AND tc.resource_id IN ( SELECT person_id

1860: ||l_payroll_filter
1861: ||')';
1862: ELSIF p_gre_id IS NOT NULL
1863: THEN
1864: l_asg_criteria := FND_GLOBAL.newline||' AND tc.resource_id IN ( SELECT person_id
1865: FROM per_all_assignments_f paf,
1866: hr_soft_coding_keyflex hsk
1867: WHERE business_group_id = '||p_bg_id
1868: ||l_location_filter

Line 1871: ||FND_GLOBAL.newline||' AND paf.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id

1867: WHERE business_group_id = '||p_bg_id
1868: ||l_location_filter
1869: ||l_org_filter
1870: ||l_payroll_filter
1871: ||FND_GLOBAL.newline||' AND paf.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
1872: AND hsk.segment1 = '''||p_gre_id||''''
1873: ||')';
1874: END IF;
1875:

Line 2042: exception_description = 'Rollback Request:'||FND_GLOBAL.conc_request_id

2038: display_numtab('Transaction Details',l_lines_trans_id);
2039: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST
2040: UPDATE hxc_transaction_details
2041: SET status = 'ROLLEDBACK',
2042: exception_description = 'Rollback Request:'||FND_GLOBAL.conc_request_id
2043: WHERE transaction_detail_id = l_lines_trans_id(i);
2044:
2045:
2046: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST

Line 2196: exception_description = 'Rollback Request:'||FND_GLOBAL.conc_request_id

2192: display_numtab('Transaction Details',l_lines_trans_id);
2193: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST
2194: UPDATE hxc_transaction_details
2195: SET status = 'ROLLEDBACK',
2196: exception_description = 'Rollback Request:'||FND_GLOBAL.conc_request_id
2197: WHERE transaction_detail_id = l_lines_td_id(i);
2198:
2199:
2200: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST

Line 2333: exception_description = 'Rollback Request:'||FND_GLOBAL.conc_request_id

2329: display_numtab('Transaction Details',l_lines_trans_id);
2330: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST
2331: UPDATE hxc_transaction_details
2332: SET status = 'ROLLEDBACK',
2333: exception_description = 'Rollback Request:'||FND_GLOBAL.conc_request_id
2334: WHERE transaction_detail_id = l_lines_td_id(i);
2335:
2336:
2337: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST

Line 2791: l_start_date_filter := FND_GLOBAL.newline||' AND sum.start_time >= '''||p_start_date||'''';

2787:
2788:
2789: IF p_start_date IS NOT NULL
2790: THEN
2791: l_start_date_filter := FND_GLOBAL.newline||' AND sum.start_time >= '''||p_start_date||'''';
2792: END IF;
2793:
2794: IF p_end_date IS NOT NULL
2795: THEN

Line 2796: l_end_date_filter := FND_GLOBAL.newline||' AND TRUNC(sum.stop_time) <= '''||p_end_date||'''';

2792: END IF;
2793:
2794: IF p_end_date IS NOT NULL
2795: THEN
2796: l_end_date_filter := FND_GLOBAL.newline||' AND TRUNC(sum.stop_time) <= '''||p_end_date||'''';
2797: END IF;
2798:
2799: IF p_location_id IS NOT NULL
2800: THEN

Line 2801: l_location_filter := FND_GLOBAL.newline||' AND paf.location_id = '||p_location_id;

2797: END IF;
2798:
2799: IF p_location_id IS NOT NULL
2800: THEN
2801: l_location_filter := FND_GLOBAL.newline||' AND paf.location_id = '||p_location_id;
2802: END iF;
2803:
2804: IF p_organization_id IS NOT NULL
2805: THEN

Line 2806: l_org_filter := FND_GLOBAL.newline||' AND paf.organization_id = '||p_organization_id;

2802: END iF;
2803:
2804: IF p_organization_id IS NOT NULL
2805: THEN
2806: l_org_filter := FND_GLOBAL.newline||' AND paf.organization_id = '||p_organization_id;
2807: END iF;
2808:
2809: IF p_payroll_id IS NOT NULL
2810: THEN

Line 2811: l_payroll_filter := FND_GLOBAL.newline||' AND paf.payroll_id = '||p_payroll_id;

2807: END iF;
2808:
2809: IF p_payroll_id IS NOT NULL
2810: THEN
2811: l_payroll_filter := FND_GLOBAL.newline||' AND paf.payroll_id = '||p_payroll_id;
2812: END iF;
2813:
2814:
2815: IF p_gre_id IS NULL

Line 2817: l_asg_criteria := FND_GLOBAL.newline||' AND resource_id IN ( SELECT person_id

2813:
2814:
2815: IF p_gre_id IS NULL
2816: THEN
2817: l_asg_criteria := FND_GLOBAL.newline||' AND resource_id IN ( SELECT person_id
2818: FROM per_all_assignments_f paf
2819: WHERE business_group_id = '||p_bg_id
2820: ||l_location_filter
2821: ||l_org_filter

Line 2826: l_asg_criteria := FND_GLOBAL.newline||' AND resource_id IN ( SELECT person_id

2822: ||l_payroll_filter
2823: ||')';
2824: ELSIF p_gre_id IS NOT NULL
2825: THEN
2826: l_asg_criteria := FND_GLOBAL.newline||' AND resource_id IN ( SELECT person_id
2827: FROM per_all_assignments_f paf,
2828: hr_soft_coding_keyflex hsk
2829: WHERE business_group_id = '||p_bg_id
2830: ||l_location_filter

Line 2833: ||FND_GLOBAL.newline||' AND paf.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id

2829: WHERE business_group_id = '||p_bg_id
2830: ||l_location_filter
2831: ||l_org_filter
2832: ||l_payroll_filter
2833: ||FND_GLOBAL.newline||' AND paf.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
2834: AND hsk.segment1 = '''||p_gre_id||''''
2835: ||')';
2836: END IF;
2837:

Line 3049: exception_description = 'Rollback Request:'||FND_GLOBAL.conc_request_id

3045: display_numtab('Transaction Details',l_tc_data_td_id);
3046: FORALL i IN l_tc_data_td_id.FIRST..l_tc_data_td_id.LAST
3047: UPDATE hxc_transaction_details
3048: SET status = 'ROLLEDBACK',
3049: exception_description = 'Rollback Request:'||FND_GLOBAL.conc_request_id
3050: WHERE transaction_detail_id = l_tc_data_td_id(i);
3051:
3052:
3053: FORALL i IN l_tc_data_td_id.FIRST..l_tc_data_td_id.LAST