DBA Data[Home] [Help]

APPS.FII_PARTY_MKT_CLASS_C dependencies on BIS_COMMON_PARAMETERS

Line 84: g_collection_from_date := bis_common_parameters.get_GLOBAL_START_DATE; --global start date

80: -- OR
81: -- Last Initial is unseccessfull
82: g_phase := 'Setting dates for initial load.';
83: bis_collection_utilities.log('Setting dates for initial load. ');
84: g_collection_from_date := bis_common_parameters.get_GLOBAL_START_DATE; --global start date
85: if (g_collection_from_date is null) then
86: raise g_bis_setup_exception;
87: end if;
88: g_collection_to_date := g_run_date;

Line 193: SELECT nvl(bis_common_parameters.GET_BIS_CUST_CLASS_TYPE, -1)

189: l_error_message VARCHAR2(1000);
190: BEGIN
191: l_ret_val := 0;
192: -- Select Classification type
193: SELECT nvl(bis_common_parameters.GET_BIS_CUST_CLASS_TYPE, -1)
194: INTO g_class_type
195: FROM DUAL;
196:
197: -- Check if the classification type is non_hierarchical.

Line 680: IF l_class_category <> nvl(bis_common_parameters.GET_BIS_CUST_CLASS_TYPE, -1) THEN

676: select class_category into l_class_category
677: from fii_party_mkt_class
678: where rownum <2;
679:
680: IF l_class_category <> nvl(bis_common_parameters.GET_BIS_CUST_CLASS_TYPE, -1) THEN
681: return 'INIT';
682: ELSE
683: -- If the last run was unsuccessfull run initial else incremental
684: BIS_COLLECTION_UTILITIES.get_last_refresh_dates(