APPS.PQP_HROSS_REPORTS dependencies on FND_PROFILE

Line 61: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_date_format);

57: BEGIN
58: hr_utility.set_location('Entering: ' || l_proc_name, 10);
59:
60: --Set the value of person id where clause
61: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_date_format);
62:
63: GENERIC_WHERE := ' AND 1=1 ' ||
64: ' AND ppf.business_group_id LIKE (''' ||
65: P_BUSINESS_GROUP_ID || ''') ';

Line 162: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_date_format);

158: BEGIN
159: hr_utility.set_location('Entering: ' || l_proc_name, 10);
160:
161: --Set the value of person id where clause
162: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_date_format);
163:
164: GENERIC_WHERE := ' AND 1=1 ';
165:
166: IF P_PERSON_TYPE IS NOT NULL AND P_PERSON_TYPE <> ' ' THEN

Line 338: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_date_format);

334: FUNCTION Get_Date(p_date IN DATE) RETURN VARCHAR2 IS
335: l_return_value VARCHAR2(20);
336: l_date_format VARCHAR2(20);
337: BEGIN
338: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_date_format);
339: SELECT to_char(fnd_date.canonical_to_date(fnd_date.date_to_canonical(p_date)), l_date_format) into l_return_value FROM dual;
340: RETURN l_return_value;
341: END Get_Date;
342: