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 327: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);

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

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

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

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

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