APPS.ARRX_RC dependencies on FND_PROFILE

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

1500: select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
1501: into l_client_info_rsob_id
1502: from dual;
1503:
1504: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1505: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1506: (l_client_info_rsob_id = -99)
1507: THEN
1508: fa_rx_util_pkg.debug('Setting the sob type to P');

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

1624: end if;
1625: /* Set the appropriate sob type into the global variable var.ca_sob_type */
1626: select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
1627: into l_client_info_rsob_id from dual;
1628: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1629: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1630: (l_client_info_rsob_id = -99)
1631: THEN
1632: fa_rx_util_pkg.debug('Setting the sob type to P');

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

1761: SELECT TO_NUMBER(NVL( REPLACE(SUBSTRB(USERENV('CLIENT_INFO'),45,10),' '),-99))
1762: INTO l_client_info_rsob_id
1763: FROM dual;
1764:
1765: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1766: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1767: (l_client_info_rsob_id = -99)
1768: THEN
1769: var.ca_sob_type := 'P';