APPS.FII_AR_UTIL_PKG dependencies on FII_AR_UTIL_PKG

Line 1: PACKAGE BODY fii_ar_util_pkg AS

1: PACKAGE BODY fii_ar_util_pkg AS
2: /* $Header: FIIARUTILB.pls 120.50 2006/12/13 17:00:15 vkazhipu ship $ */
3:
4: g_min_start_date date;
5: -- -------------------------------------------------

Line 201: fii_ar_util_pkg.populate_party_id;

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
199: parent should be stored in g_party_id variable. */
200:
201: fii_ar_util_pkg.populate_party_id;
202:
203: SELECT nvl(min(start_date), trunc(sysdate)) INTO g_min_start_date
204: FROM fii_time_ent_period;
205:

Line 311: SELECT fii_ar_util_pkg.get_dso_period_profile

307: g_cust_suffix := '_base';
308: g_cust_view_by := NULL;
309: END CASE;
310:
311: SELECT fii_ar_util_pkg.get_dso_period_profile
312: INTO g_dso_period
313: FROM dual;
314:
315: CASE

Line 643: g_security_profile_id := fii_ar_util_pkg.get_sec_profile;

639: l_all_org_flag VARCHAR2(30);
640: l_business_group_id NUMBER;
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

Line 673: g_security_profile_id := fii_ar_util_pkg.get_sec_profile;

669:
670: FUNCTION get_business_group RETURN NUMBER IS
671: l_business_group_id NUMBER;
672: BEGIN
673: g_security_profile_id := fii_ar_util_pkg.get_sec_profile;
674:
675: SELECT business_group_id
676: INTO l_business_group_id
677: FROM per_security_profiles

Line 698: g_business_group_id := fii_ar_util_pkg.get_business_group;

694: END IF;
695:
696: g_det_ou_lov := determine_OU_LOV;
697:
698: g_business_group_id := fii_ar_util_pkg.get_business_group;
699:
700: IF(p_selected_operating_unit <> 'ALL') then
701: IF (g_operating_unit is null or g_operating_unit <> p_selected_operating_unit) THEN
702: g_operating_unit := p_selected_operating_unit;

Line 740: WHERE business_group_id = fii_ar_util_pkg.g_business_group_id) ;

736: gl_sets_of_books gsob
737: where fsp.set_of_books_id = gsob.set_of_books_id
738: AND fsp.org_id in (SELECT organization_id
739: FROM hr_operating_units
740: WHERE business_group_id = fii_ar_util_pkg.g_business_group_id) ;
741:
742: ELSIF g_det_ou_lov=3 THEN
743: select distinct currency_code
744: into g_common_functional_currency

Line 778: WHERE business_group_id = fii_ar_util_pkg.g_business_group_id

774: g_det_ou_lov=2
775: AND fsp.org_id in (
776: SELECT organization_id
777: FROM hr_operating_units
778: WHERE business_group_id = fii_ar_util_pkg.g_business_group_id
779: )
780: )
781: OR (
782: g_det_ou_lov=3

Line 1072: g_security_profile_id := fii_ar_util_pkg.get_sec_profile;

1068:
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:

Line 1412: VALUES (''FII_AR_UTIL_PKG'',

1408: session_id,
1409: region_code,
1410: sql_statement,
1411: value)
1412: VALUES (''FII_AR_UTIL_PKG'',
1413: ''POPULATE_SUMMARY_GT_TABLES'',
1414: '||g_session_id||','''||g_region_code||''' ,
1415: ''l_select'',
1416: '''||REPLACE(l_select, '''', '''''')||''')';

Line 1559: VALUES (''FII_AR_UTIL_PKG'',

1555: session_id,
1556: region_code,
1557: sql_statement,
1558: value)
1559: VALUES (''FII_AR_UTIL_PKG'',
1560: ''POPULATE_SUMMARY_GT_TABLES'',
1561: '||g_session_id||','''||g_region_code||''' ,
1562: ''l_select2'',
1563: '''||REPLACE(l_select2, '''', '''''')||''')';

Line 1919: END fii_ar_util_pkg;

1915: WHEN OTHERS THEN
1916: g_page_refresh_date := sysdate;
1917: END get_page_refresh_date;
1918:
1919: END fii_ar_util_pkg;