APPS.PSP_XMLGEN dependencies on FND_GLOBAL

Line 40: g_request_id := fnd_global.conc_request_id;

36: l_error_count NUMBER;
37: l_return_status CHAR(1);
38: l_language_code VARCHAR2(30);
39: BEGIN
40: g_request_id := fnd_global.conc_request_id;
41: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);
42: l_language_code := USERENV('LANG');
43:
44: OPEN get_sob_cur;

Line 298: g_request_id := fnd_global.conc_request_id;

294: l_error_count NUMBER;
295: l_return_status CHAR(1);
296: BEGIN
297:
298: g_request_id := fnd_global.conc_request_id;
299: OPEN template_id_cur;
300: FETCH template_id_cur INTO l_template_id, l_request_id, l_set_of_books_id;
301: CLOSE template_id_cur;
302:

Line 668: g_request_id := fnd_global.conc_request_id;

664: l_approval_type psp_report_templates.approval_type%TYPE; --Bug 6864426
665: l_initiator_name per_people_f.full_name%TYPE; --Bug 6864426
666:
667: BEGIN
668: g_request_id := fnd_global.conc_request_id;
669: OPEN layout_type_cur;
670: FETCH layout_type_cur INTO l_layout_type;
671: CLOSE layout_type_cur;
672:

Line 1192: g_request_id := fnd_global.conc_request_id;

1188:
1189: l_error_count NUMBER;
1190: l_return_status CHAR(1);
1191: BEGIN
1192: g_request_id := fnd_global.conc_request_id;
1193:
1194: OPEN get_request_id_cur;
1195: FETCH get_request_id_cur INTO l_request_id;
1196: CLOSE get_request_id_cur;

Line 1336: g_request_id := fnd_global.conc_request_id;

1332: CLOSE get_request_id_cur;
1333:
1334: hr_utility.trace('LD Debug p_item_type_key = '||p_item_type_key);
1335:
1336: g_request_id := fnd_global.conc_request_id;
1337: l_item_type := SUBSTR(p_item_type_key, 1, INSTR(p_item_type_key, ':') - 1);
1338: l_item_key := SUBSTR(p_item_type_key, INSTR(p_item_type_key, ':') + 1, length(p_item_type_key) - 2);
1339:
1340: hr_utility.trace('LD Debug l_item_type = '||l_item_type);

Line 1423: g_request_id := fnd_global.conc_request_id;

1419: l_return_status CHAR(1);
1420:
1421:
1422: BEGIN
1423: g_request_id := fnd_global.conc_request_id;
1424: --- replaced single bulk update with a loop b'cos of xml error
1425: ---ORA-29532, ORA-6512 for bug fix 4429787
1426: open er_cur;
1427: loop

Line 1486: g_request_id := fnd_global.conc_request_id;

1482:
1483: l_error_count NUMBER;
1484: l_return_status CHAR(1);
1485: BEGIN
1486: g_request_id := fnd_global.conc_request_id;
1487: UPDATE psp_eff_reports
1488: SET person_xml = generate_person_xml(person_id, template_id, effort_report_id, request_id, set_of_books_id, full_name, employee_number, mailstop, emp_primary_org_name, emp_primary_org_id, currency_code)
1489: WHERE request_id = p_request_id
1490: AND status_code <> 'R';

Line 1562: g_request_id := fnd_global.conc_request_id;

1558:
1559: person_rec person_cur%ROWTYPE;
1560: l_xml CLOB;
1561: BEGIN
1562: g_request_id := fnd_global.conc_request_id;
1563:
1564: OPEN person_cur;
1565: l_xml := empty_clob();
1566: LOOP

Line 1709: g_request_id := fnd_global.conc_request_id;

1705: AND layout_lookup_type = 'PSP_PROJECT_MANAGER_ROLE';
1706:
1707:
1708: BEGIN
1709: g_request_id := fnd_global.conc_request_id;
1710: OPEN effort_report_id_cur;
1711: FETCH effort_report_id_cur BULK COLLECT INTO r_effort_report.r_effort_report_id, r_effort_report.r_start_date, r_effort_report.r_end_date;
1712: CLOSE effort_report_id_cur;
1713: