APPS.PA_ROLE_PROFILES_UTILS dependencies on FND_PROFILE

Line 22: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

18:
19: l_current_id NUMBER := NULL;
20: l_num_ids NUMBER := 0;
21: l_id_found_flag VARCHAR(1) := 'N';
22: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
23:
24: CURSOR c_ids IS
25: SELECT business_group_id
26: FROM per_business_groups

Line 111: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

107:
108: l_current_id NUMBER := NULL;
109: l_num_ids NUMBER := 0;
110: l_id_found_flag VARCHAR(1) := 'N';
111: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
112:
113: CURSOR c_ids IS
114: SELECT position_id
115: FROM per_positions

Line 209: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

205:
206: l_return_status VARCHAR2(1);
207: l_error_msg_code VARCHAR2(500);
208: l_exists VARCHAR(1);
209: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
210:
211: BEGIN
212: x_return_status := FND_API.G_RET_STS_SUCCESS;
213: --FND_MSG_PUB.initialize;

Line 370: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

366: l_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := p_role_id_tbl;
367: l_return_status VARCHAR2(1);
368: l_error_msg_code VARCHAR2(500);
369: l_sum NUMBER := 0;
370: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
371: BEGIN
372:
373: x_return_status := FND_API.G_RET_STS_SUCCESS;
374: