APPS.HXT_RETRIEVAL_ROLLBACK dependencies on FND_PROFILE

Line 279: ||' Start: '||TO_CHAR(start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))

275: IS
276:
277: CURSOR get_period_details
278: IS select 'Period Name: '||period_name
279: ||' Start: '||TO_CHAR(start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
280: ||' End: '||TO_CHAR(end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
281: from per_time_periods
282: where time_period_id = p_time_period_id;
283:

Line 280: ||' End: '||TO_CHAR(end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))

276:
277: CURSOR get_period_details
278: IS select 'Period Name: '||period_name
279: ||' Start: '||TO_CHAR(start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
280: ||' End: '||TO_CHAR(end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
281: from per_time_periods
282: where time_period_id = p_time_period_id;
283:
284: l_period_details VARCHAR2(240):= 'XXXX';

Line 1375: p_business_group_id => FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'),

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',
1379: p_batch_id => l_new_batch,

Line 1407: p_business_group_id => FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'),

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',
1411: p_batch_id => l_new_batch,

Line 1574: RPAD(TO_CHAR(line_tab(i).effective_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')),15)||

1570: RPAD(line_tab(i).assignment_number,10)||
1571: l_space||
1572: RPAD(element_name(line_tab(i).element_type_id),20)||
1573: l_space||
1574: RPAD(TO_CHAR(line_tab(i).effective_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')),15)||
1575: l_space||
1576: RPAD(NVL(line_tab(i).value_1||'/'||
1577: line_tab(i).value_2||'/'||
1578: line_tab(i).value_3||'/'||