APPS.CST_MGD_MSTR_BOOK_RPT dependencies on FND_PROFILE

Line 429: l_resp_id NUMBER:= FND_PROFILE.VALUE('RESP_ID');

425: --========================================================================
426: FUNCTION beforereport RETURN BOOLEAN IS
427: INVALID_DATE_RANGE_EXCEPT EXCEPTION;
428:
429: l_resp_id NUMBER:= FND_PROFILE.VALUE('RESP_ID');
430: /* CURSOR lcu_inv_org -- Added for Italy China Enhancements
431: IS
432: SELECT HOU.organization_id
433: FROM hr_organization_units HOU

Line 1065: SELECT TO_CHAR(SYSDATE, FND_PROFILE.value('ICX_DATE_FORMAT_MASK'))

1061: FUNCTION get_icx_date RETURN VARCHAR2
1062: IS
1063: lc_sysdate VARCHAR2 (80);
1064: BEGIN
1065: SELECT TO_CHAR(SYSDATE, FND_PROFILE.value('ICX_DATE_FORMAT_MASK'))
1066: INTO lc_sysdate
1067: FROM SYS.dual;
1068:
1069: RETURN (lc_sysdate);

Line 1822: SELECT TO_CHAR (TO_DATE (p_date_from, 'YYYY/MM/DD HH24:MI:SS'), FND_PROFILE.value('ICX_DATE_FORMAT_MASK'))

1818: RETURN VARCHAR2
1819: IS
1820: lc_date VARCHAR2 (50);
1821: BEGIN
1822: SELECT TO_CHAR (TO_DATE (p_date_from, 'YYYY/MM/DD HH24:MI:SS'), FND_PROFILE.value('ICX_DATE_FORMAT_MASK'))
1823: INTO lc_date
1824: FROM SYS.dual;
1825:
1826: RETURN (lc_date);

Line 1842: SELECT TO_CHAR (TO_DATE (p_date_to, 'YYYY/MM/DD HH24:MI:SS'), FND_PROFILE.value ('ICX_DATE_FORMAT_MASK'))

1838: RETURN VARCHAR2
1839: IS
1840: lc_date VARCHAR2 (50);
1841: BEGIN
1842: SELECT TO_CHAR (TO_DATE (p_date_to, 'YYYY/MM/DD HH24:MI:SS'), FND_PROFILE.value ('ICX_DATE_FORMAT_MASK'))
1843: INTO lc_date
1844: FROM SYS.dual;
1845:
1846: RETURN (lc_date);