DBA Data[Home] [Help]

APPS.PA_ROLE_PROFILES_PKG dependencies on FND_PROFILE

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

21: p_resource_id IN NUMBER DEFAULT NULL,
22: x_profile_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
23: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
24:
25: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
26:
27: BEGIN
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29:

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

86: p_project_role_id IN NUMBER,
87: p_role_weighting IN NUMBER,
88: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
89:
90: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
91:
92: BEGIN
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:

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

140: p_position_id IN NUMBER DEFAULT NULL,
141: p_resource_id IN NUMBER DEFAULT NULL,
142: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
143:
144: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
145:
146: BEGIN
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:

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

214: l_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
215: l_exists VARCHAR2(1);
216: l_return_status VARCHAR2(1);
217: l_msg_index_out NUMBER := 0;
218: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
219: BEGIN
220: -------------------------------------------------------------------
221: -- Initial Setup
222: -------------------------------------------------------------------

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

394: l_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
395: l_exists VARCHAR2(1) := 'N';
396: l_return_status VARCHAR2(1);
397: l_msg_index_out NUMBER := 0;
398: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
399: BEGIN
400: -------------------------------------------------------------------
401: -- Initial Setup
402: -------------------------------------------------------------------