APPS.IEX_SCORE_NEW_PVT dependencies on FND_PROFILE

Line 7: --G_Debug_Level NUMBER := to_number(nvl(fnd_profile.value('IEX_DEBUG_LEVEL'), '0'));

3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_SCORE_NEW_PVT';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvscfb.pls';
7: --G_Debug_Level NUMBER := to_number(nvl(fnd_profile.value('IEX_DEBUG_LEVEL'), '0'));
8: G_Batch_Size NUMBER ;
9: PG_DEBUG NUMBER ;
10:
11: G_MIN_SCORE VARCHAR2(100);

Line 524: t_prf_score_trans varchar2(1) := nvl(fnd_profile.value('IEX_STORE_PS_SCORE'),'Y'); -- added for bug 13426796 by sunagesh on 25.11.2011

520: l_object_name varchar2(360);
521: l_acct_number varchar2(100);
522: --End Bug 8933776 30-Nov-2009 barathsr
523: t_object_code varchar2(100); -- added for bug 13426796 by sunagesh on 25.11.2011
524: t_prf_score_trans varchar2(1) := nvl(fnd_profile.value('IEX_STORE_PS_SCORE'),'Y'); -- added for bug 13426796 by sunagesh on 25.11.2011
525: BEGIN
526:
527: l_api_name := 'getScores';
528: l_score_comp_tbl := p_score_comp_tbl;

Line 1673: l_pf_value varchar2(50) := nvl(FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL'),'');

1669: l_msg_count NUMBER;
1670:
1671: -- bug 6128024
1672: l_pf_name varchar2(100);
1673: l_pf_value varchar2(50) := nvl(FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL'),'');
1674:
1675: type score_ids is table of number index by binary_integer;
1676: l_num_score_engines score_ids;
1677:

Line 1736: NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('DEFAULT_ORG_ID')), ' '));

1732: when others then l_pf_name := null;
1733: end;
1734:
1735: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Default Operating Unit : ' ||
1736: NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('DEFAULT_ORG_ID')), ' '));
1737: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Operating Unit: ' ||
1738: NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('ORG_ID')), ' '));
1739: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Security Profile: ' || l_pf_name);
1740: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 1738: NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('ORG_ID')), ' '));

1734:
1735: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Default Operating Unit : ' ||
1736: NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('DEFAULT_ORG_ID')), ' '));
1737: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Operating Unit: ' ||
1738: NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('ORG_ID')), ' '));
1739: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Security Profile: ' || l_pf_name);
1740: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1741: -- End bug 6128024
1742:

Line 1759: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');

1755:
1756: --Start adding for bug 10210488 snuthala 19th Oct 10
1757: --l_xml_header := '';
1758: -- Instead of hard coding the value, pick the charcter set value from "ICX: Client IANA Encoding" profile.
1759: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
1760: l_xml_header := '';
1761: --End adding for bug 10210488 snuthala 19th Oct 10
1762:
1763: l_xml_header:=l_xml_header||l_new_line||'';

Line 3036: G_Batch_Size := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));

3032:
3033:
3034:
3035: BEGIN
3036: G_Batch_Size := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
3037: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3038:
3039: G_MIN_SCORE := '1';
3040: G_MAX_SCORE := '100';