APPS.FII_LOB_MAINTAIN_PKG dependencies on FND_PROFILE

Line 16: := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');

12:
13: g_schema_name VARCHAR2(120) := 'FII';
14: g_retcode VARCHAR2(20) := NULL;
15: g_debug_mode VARCHAR2(1)
16: := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
17:
18: g_index NUMBER(10) :=0;
19: -- *****************************************************************
20: -- Check if a value set is table validated

Line 134: l_dir := fnd_profile.value('BIS_DEBUG_LOG_DIRECTORY');

130: ----------------------------------------------
131: -- Do set up for log file
132: ----------------------------------------------
133:
134: l_dir := fnd_profile.value('BIS_DEBUG_LOG_DIRECTORY');
135: ------------------------------------------------------
136: -- Set default directory in case if the profile option
137: -- BIS_DEBUG_LOG_DIRECTORY is not set up
138: ------------------------------------------------------

Line 1159: If NVL(FND_PROFILE.value('FII_SORT_ORDER_IT'), 'N') = 'Y' then

1155: END IF;
1156:
1157: --------------------------------------------------------------
1158: --Populate column next_level_lob_sort_order (bug 3608355)
1159: If NVL(FND_PROFILE.value('FII_SORT_ORDER_IT'), 'N') = 'Y' then
1160: g_phase := 'Call Get_Sort_Order';
1161: Get_Sort_Order;
1162: End if;
1163: --------------------------------------------------------------