APPS.ARRX_RC dependencies on FND_PROFILE

Line 1577: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);

1573: select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
1574: into l_client_info_rsob_id
1575: from dual;
1576:
1577: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1578: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1579: (l_client_info_rsob_id = -99)
1580: THEN
1581: fa_rx_util_pkg.debug('Setting the sob type to P');

Line 1701: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);

1697: end if;
1698: /* Set the appropriate sob type into the global variable var.ca_sob_type */
1699: select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
1700: into l_client_info_rsob_id from dual;
1701: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1702: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1703: (l_client_info_rsob_id = -99)
1704: THEN
1705: fa_rx_util_pkg.debug('Setting the sob type to P');

Line 1838: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);

1834: SELECT TO_NUMBER(NVL( REPLACE(SUBSTRB(USERENV('CLIENT_INFO'),45,10),' '),-99))
1835: INTO l_client_info_rsob_id
1836: FROM dual;
1837:
1838: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1839: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1840: (l_client_info_rsob_id = -99)
1841: THEN
1842: var.ca_sob_type := 'P';