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.HXT_RETRIEVAL_ROLLBACK dependencies on FND_GLOBAL

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

1370: ELSE
1371: -- Bug 14389835
1372: pay_batch_element_entry_api.create_batch_header
1373: (p_session_date => TRUNC(SYSDATE),
1374: p_batch_name => 'REV_'||p_batch_id||'_'||FND_GLOBAL.conc_request_id,
1375: p_business_group_id => FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'),
1376: p_batch_reference => 'REV_'||p_batch_id,
1377: p_batch_source => 'OTM',
1378: p_action_if_exists => 'I',

Line 1406: p_batch_name => 'REP_'||p_batch_id||'_'||FND_GLOBAL.conc_request_id,

1402: ELSE
1403: -- Bug 14389835
1404: pay_batch_element_entry_api.create_batch_header
1405: (p_session_date => SYSDATE,
1406: p_batch_name => 'REP_'||p_batch_id||'_'||FND_GLOBAL.conc_request_id,
1407: p_business_group_id => FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'),
1408: p_batch_reference => 'REP_'||p_batch_id,
1409: p_batch_source => 'OTM',
1410: p_action_if_exists => 'I',

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

3842:
3843: FORALL i IN l_id_tab.FIRST..l_id_tab.LAST
3844: UPDATE hxc_transaction_details
3845: SET status = 'ROLLEDBACK',
3846: exception_description = 'Rollback Request:'||FND_GLOBAL.conc_request_id
3847: WHERE transaction_detail_id = l_lines_td_id(i);
3848:
3849: END IF;
3850:

Line 3964: l_query := l_query||FND_GLOBAL.newline||' AND tim.for_person_id = '||p_person_id;

3960:
3961: -- Bug 13777315
3962: IF p_person_id IS NOT NULL
3963: THEN
3964: l_query := l_query||FND_GLOBAL.newline||' AND tim.for_person_id = '||p_person_id;
3965: END IF;
3966:
3967: IF p_location_id IS NOT NULL
3968: THEN

Line 3969: l_location_filter := FND_Global.newline||' AND paf.location_id = '||p_location_id;

3965: END IF;
3966:
3967: IF p_location_id IS NOT NULL
3968: THEN
3969: l_location_filter := FND_Global.newline||' AND paf.location_id = '||p_location_id;
3970: END iF;
3971:
3972: IF p_organization_id IS NOT NULL
3973: THEN

Line 3974: l_org_filter := FND_Global.newline||' AND paf.organization_id = '||p_organization_id;

3970: END iF;
3971:
3972: IF p_organization_id IS NOT NULL
3973: THEN
3974: l_org_filter := FND_Global.newline||' AND paf.organization_id = '||p_organization_id;
3975: END iF;
3976:
3977: IF p_payroll_id IS NOT NULL
3978: THEN

Line 3979: l_payroll_filter := FND_Global.newline||' AND paf.payroll_id = '||p_payroll_id;

3975: END iF;
3976:
3977: IF p_payroll_id IS NOT NULL
3978: THEN
3979: l_payroll_filter := FND_Global.newline||' AND paf.payroll_id = '||p_payroll_id;
3980: END iF;
3981:
3982: IF p_batch_id IS NOT NULL
3983: THEN

Line 3984: l_batch_filter := FND_Global.newline||' AND tim.batch_id = '||p_batch_id;

3980: END iF;
3981:
3982: IF p_batch_id IS NOT NULL
3983: THEN
3984: l_batch_filter := FND_Global.newline||' AND tim.batch_id = '||p_batch_id;
3985: END IF;
3986:
3987: IF p_batch_ref IS NOT NULL
3988: THEN

Line 3997: l_batch_filter := l_batch_filter||FND_Global.newline||' AND tim.batch_id IN '||l_batches_list;

3993:
3994: CLOSE get_batches;
3995:
3996: l_batches_list := '('||string_list(l_batches)||')';
3997: l_batch_filter := l_batch_filter||FND_Global.newline||' AND tim.batch_id IN '||l_batches_list;
3998:
3999: END IF;
4000:
4001:

Line 4006: l_asg_criteria := l_batch_filter||FND_Global.newline||' AND for_person_id IN ( SELECT person_id

4002:
4003: IF p_gre_id IS NULL
4004: THEN
4005:
4006: l_asg_criteria := l_batch_filter||FND_Global.newline||' AND for_person_id IN ( SELECT person_id
4007: FROM per_all_assignments_f paf
4008: WHERE paf.effective_start_date <= ptp.end_date
4009: AND paf.effective_end_date >= ptp.start_date
4010: AND business_group_id = '||p_bg_id

Line 4019: l_asg_criteria := l_batch_filter||FND_Global.newline||' AND for_person_id IN ( SELECT person_id

4015:
4016: ELSIF p_gre_id IS NOT NULL
4017: THEN
4018:
4019: l_asg_criteria := l_batch_filter||FND_Global.newline||' AND for_person_id IN ( SELECT person_id
4020: FROM per_all_assignments_f paf,
4021: hr_soft_coding_keyflex hsk
4022: WHERE paf.effective_start_date <= ptp.end_date
4023: AND paf.effective_end_date >= ptp.start_date

Line 4028: ||FND_Global.newline||' AND paf.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id

4024: AND business_group_id = '||p_bg_id
4025: ||l_location_filter
4026: ||l_org_filter
4027: ||l_payroll_filter
4028: ||FND_Global.newline||' AND paf.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
4029: AND hsk.segment1 = '''||p_gre_id||''''
4030: ||')';
4031:
4032: END IF;