APPS.FEM_HIER_UTILS_PVT dependencies on FND_PROFILE

Line 7594: l_cal_period_id NUMBER := FND_PROFILE.Value_Specific('FEM_PERIOD',FND_GLOBAL.USER_ID);

7590: l_is_prior_version VARCHAR2(1) := 'N';
7591:
7592: l_child_sequence_num NUMBER;
7593:
7594: l_cal_period_id NUMBER := FND_PROFILE.Value_Specific('FEM_PERIOD',FND_GLOBAL.USER_ID);
7595: --l_dataset_code NUMBER := -999;
7596:
7597: --Bug#4252397: Fetch dataset code from profile.
7598: l_dataset_code NUMBER := FND_PROFILE.Value_Specific('FEM_DATASET',FND_GLOBAL.USER_ID);

Line 7598: l_dataset_code NUMBER := FND_PROFILE.Value_Specific('FEM_DATASET',FND_GLOBAL.USER_ID);

7594: l_cal_period_id NUMBER := FND_PROFILE.Value_Specific('FEM_PERIOD',FND_GLOBAL.USER_ID);
7595: --l_dataset_code NUMBER := -999;
7596:
7597: --Bug#4252397: Fetch dataset code from profile.
7598: l_dataset_code NUMBER := FND_PROFILE.Value_Specific('FEM_DATASET',FND_GLOBAL.USER_ID);
7599:
7600: CURSOR l_hier_ver_details_csr (c_version_id IN NUMBER)
7601: IS
7602: SELECT effective_start_date,

Line 8426: l_dataset_code NUMBER := FND_PROFILE.VALUE_SPECIFIC('FEM_DATASET',FND_GLOBAL.USER_ID);

8422: l_relationship_id NUMBER;
8423: l_version_start_date DATE;
8424:
8425: -- Bug#5723800 : Begin
8426: l_dataset_code NUMBER := FND_PROFILE.VALUE_SPECIFIC('FEM_DATASET',FND_GLOBAL.USER_ID);
8427: l_cal_period_id NUMBER := FND_PROFILE.VALUE_SPECIFIC('FEM_PERIOD',FND_GLOBAL.USER_ID);
8428: l_insert_flag VARCHAR2(1) := 'Y';
8429: l_creation_date DATE := SYSDATE;
8430: l_last_update_date DATE := SYSDATE;

Line 8427: l_cal_period_id NUMBER := FND_PROFILE.VALUE_SPECIFIC('FEM_PERIOD',FND_GLOBAL.USER_ID);

8423: l_version_start_date DATE;
8424:
8425: -- Bug#5723800 : Begin
8426: l_dataset_code NUMBER := FND_PROFILE.VALUE_SPECIFIC('FEM_DATASET',FND_GLOBAL.USER_ID);
8427: l_cal_period_id NUMBER := FND_PROFILE.VALUE_SPECIFIC('FEM_PERIOD',FND_GLOBAL.USER_ID);
8428: l_insert_flag VARCHAR2(1) := 'Y';
8429: l_creation_date DATE := SYSDATE;
8430: l_last_update_date DATE := SYSDATE;
8431: l_last_Updated_by NUMBER := FND_GLOBAL.User_Id;