APPS.FII_AR_UTIL_PKG dependencies on FND_PROFILE

Line 185: /* FND PROFILE for Customer Hierarchy: will be created through Bug 4637815 */

181: g_col_curr_suffix := '_func';
182: END IF;
183:
184:
185: /* FND PROFILE for Customer Hierarchy: will be created through Bug 4637815 */
186: is_hierarchical := nvl(fnd_profile.value('BIS_CUST_HIER_TYPE'), 'N');
187:
188: IF is_hierarchical = 'N' THEN
189: g_is_hierarchical_flag := 'N';

Line 186: is_hierarchical := nvl(fnd_profile.value('BIS_CUST_HIER_TYPE'), 'N');

182: END IF;
183:
184:
185: /* FND PROFILE for Customer Hierarchy: will be created through Bug 4637815 */
186: is_hierarchical := nvl(fnd_profile.value('BIS_CUST_HIER_TYPE'), 'N');
187:
188: IF is_hierarchical = 'N' THEN
189: g_is_hierarchical_flag := 'N';
190: ELSE

Line 194: g_industry_class_type := nvl(fnd_profile.value('BIS_CUST_CLASS_TYPE'), -1);

190: ELSE
191: g_is_hierarchical_flag :='Y';
192: END IF;
193:
194: g_industry_class_type := nvl(fnd_profile.value('BIS_CUST_CLASS_TYPE'), -1);
195:
196: /* The following procedure parses the g_party_id i.e. party_id parameter value passed by
197: BIS from PMV parameter region. After that in the case of customers defined is hierarchical
198: and if both parent and children are chosen together from customer parameter then only the

Line 607: stmt := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);

603:
604: FUNCTION get_sec_profile RETURN NUMBER IS
605: stmt NUMBER;
606: BEGIN
607: stmt := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);
608: RETURN stmt;
609: END get_sec_profile;
610:
611: FUNCTION get_dso_period_profile RETURN NUMBER IS

Line 614: stmt := nvl(fnd_profile.value('FII_AR_DSO_PERIOD'), -1);

610:
611: FUNCTION get_dso_period_profile RETURN NUMBER IS
612: stmt NUMBER;
613: BEGIN
614: stmt := nvl(fnd_profile.value('FII_AR_DSO_PERIOD'), -1);
615: RETURN stmt;
616: END get_dso_period_profile;
617:
618:

Line 645: g_security_org_id := fnd_profile.value('ORG_ID');

641:
642: BEGIN
643: g_security_profile_id := fii_ar_util_pkg.get_sec_profile;
644:
645: g_security_org_id := fnd_profile.value('ORG_ID');
646:
647: IF g_security_profile_id is NOT NULL AND g_security_profile_id <> -1 THEN
648: SELECT view_all_organizations_flag, business_group_id
649: INTO l_all_org_flag, l_business_group_id

Line 693: g_security_profile_id := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);

689: FUNCTION get_display_currency(p_selected_operating_unit IN VARCHAR2) RETURN VARCHAR2 IS
690: l_org_id NUMBER;
691: BEGIN
692: IF g_security_profile_id is null then
693: g_security_profile_id := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);
694: END IF;
695:
696: g_det_ou_lov := determine_OU_LOV;
697:

Line 753: l_org_id := nvl(fnd_profile.value('ORG_ID'), -1);

749: FROM per_organization_list
750: WHERE security_profile_id = g_security_profile_id) ;
751:
752: ELSIF g_det_ou_lov=4 THEN
753: l_org_id := nvl(fnd_profile.value('ORG_ID'), -1);
754: select distinct currency_code
755: into g_common_functional_currency
756: from ar_system_parameters_all fsp,
757: gl_sets_of_books gsob

Line 790: g_det_ou_lov=4 AND fsp.org_id = nvl(fnd_profile.value('ORG_ID'), -1)

786: WHERE security_profile_id = g_security_profile_id
787: )
788: )
789: OR(
790: g_det_ou_lov=4 AND fsp.org_id = nvl(fnd_profile.value('ORG_ID'), -1)
791: )
792: );
793:
794: */

Line 856: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');

852: l_industry_select VARCHAR2(500):=NULL;
853: l_all_org_flag VARCHAR2(30);
854: l_business_group_id NUMBER;
855: l_org_count NUMBER;
856: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
857: l_unid_message VARCHAR2(30) := FND_MESSAGE.get_string('FII', 'FII_AR_UNID_CUSTOMER');
858: l_unassigned_message VARCHAR2(30) := FND_MESSAGE.get_string('BIS', 'EDW_UNASSIGNED');
859:
860: i number;

Line 1073: g_security_org_id := fnd_profile.value('ORG_ID');

1069:
1070: /* Handles Org related SELECT, FROM and WHERE clause */
1071:
1072: g_security_profile_id := fii_ar_util_pkg.get_sec_profile;
1073: g_security_org_id := fnd_profile.value('ORG_ID');
1074:
1075: /* Security is dictated by 'MO: Security Profile'. */
1076:
1077: IF g_security_profile_id is not null AND g_security_profile_id <> -1 THEN