APPS.PSP_XMLGEN dependencies on FND_PROFILE

Line 41: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);

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;
45: FETCH get_sob_cur INTO l_gl_sob;

Line 329: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);

325: END LOOP;
326: CLOSE sort_option_cur;
327: l_emp_sort_option := l_sort_option1;
328:
329: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);
330:
331: OPEN layout_type_cur;
332: FETCH layout_type_cur INTO l_layout_type, l_display_flag;
333: CLOSE layout_type_cur;

Line 665: l_business_group_id Number := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

661: l_num25_fmask VARCHAR2(30);
662: l_icx_date_format VARCHAR2(20);
663: l_error_count NUMBER;
664: l_return_status CHAR(1);
665: l_business_group_id Number := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
666: l_grouping_category varchar2(30); -- Added for Hospital effort report
667: l_layout_option_order Number;
668: l_approval_type psp_report_templates.approval_type%TYPE; --Bug 6864426
669: l_initiator_name per_people_f.full_name%TYPE; --Bug 6864426

Line 684: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);

680: CLOSE initiator_name_cur;
681:
682:
683: l_num25_fmask := fnd_currency.get_format_mask(p_currency_code, 25);
684: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);
685:
686: OPEN sort_option_cur(p_template_id, l_business_group_id);
687: LOOP
688: IF (sort_option_cur%ROWCOUNT = 0) THEN