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 300: g_request_id := fnd_global.conc_request_id;

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

Line 672: g_request_id := fnd_global.conc_request_id;

668: l_approval_type psp_report_templates.approval_type%TYPE; --Bug 6864426
669: l_initiator_name per_people_f.full_name%TYPE; --Bug 6864426
670:
671: BEGIN
672: g_request_id := fnd_global.conc_request_id;
673: OPEN layout_type_cur;
674: FETCH layout_type_cur INTO l_layout_type;
675: CLOSE layout_type_cur;
676:

Line 1198: g_request_id := fnd_global.conc_request_id;

1194:
1195: l_error_count NUMBER;
1196: l_return_status CHAR(1);
1197: BEGIN
1198: g_request_id := fnd_global.conc_request_id;
1199:
1200: OPEN get_request_id_cur;
1201: FETCH get_request_id_cur INTO l_request_id;
1202: CLOSE get_request_id_cur;

Line 1344: g_request_id := fnd_global.conc_request_id;

1340: CLOSE get_request_id_cur;
1341:
1342: hr_utility.trace('LD Debug p_item_type_key = '||p_item_type_key);
1343:
1344: g_request_id := fnd_global.conc_request_id;
1345: l_item_type := SUBSTR(p_item_type_key, 1, INSTR(p_item_type_key, ':') - 1);
1346: l_item_key := SUBSTR(p_item_type_key, INSTR(p_item_type_key, ':') + 1, length(p_item_type_key) - 2);
1347:
1348: hr_utility.trace('LD Debug l_item_type = '||l_item_type);

Line 1432: g_request_id := fnd_global.conc_request_id;

1428: l_return_status CHAR(1);
1429:
1430:
1431: BEGIN
1432: g_request_id := fnd_global.conc_request_id;
1433: --- replaced single bulk update with a loop b'cos of xml error
1434: ---ORA-29532, ORA-6512 for bug fix 4429787
1435: open er_cur;
1436: loop

Line 1496: g_request_id := fnd_global.conc_request_id;

1492:
1493: l_error_count NUMBER;
1494: l_return_status CHAR(1);
1495: BEGIN
1496: g_request_id := fnd_global.conc_request_id;
1497: UPDATE psp_eff_reports
1498: 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)
1499: WHERE request_id = p_request_id
1500: AND status_code <> 'R';

Line 1573: g_request_id := fnd_global.conc_request_id;

1569:
1570: person_rec person_cur%ROWTYPE;
1571: l_xml CLOB;
1572: BEGIN
1573: g_request_id := fnd_global.conc_request_id;
1574:
1575: OPEN person_cur;
1576: l_xml := empty_clob();
1577: LOOP

Line 1734: g_request_id := fnd_global.conc_request_id;

1730:
1731:
1732: --Changes End for 12326688
1733: BEGIN
1734: g_request_id := fnd_global.conc_request_id;
1735: OPEN effort_report_id_cur;
1736: 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;
1737: CLOSE effort_report_id_cur;
1738: