DBA Data[Home] [Help]

APPS.PA_JOB_UTILS dependencies on FND_PROFILE

Line 12: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

8: -- Parameters Type Required Description
9: -- p_log_msg VARCHAR2 YES It stores text which you want to print on screen
10: -- Out parameters
11: ----------------------------------------------------------------------------------------------------------------
12: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
13: -- Added Debug Profile Option variable initialization for bug#5094780
14: G_HR_CROSS_BUSINESS_GROUP varchar2(1) := fnd_profile.value('HR_CROSS_BUSINESS_GROUP');
15: G_PA_PROJ_RES_JOB_GRP NUMBER := to_number(fnd_profile.value('PA_PROJ_RES_JOB_GRP'));
16:

Line 14: G_HR_CROSS_BUSINESS_GROUP varchar2(1) := fnd_profile.value('HR_CROSS_BUSINESS_GROUP');

10: -- Out parameters
11: ----------------------------------------------------------------------------------------------------------------
12: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
13: -- Added Debug Profile Option variable initialization for bug#5094780
14: G_HR_CROSS_BUSINESS_GROUP varchar2(1) := fnd_profile.value('HR_CROSS_BUSINESS_GROUP');
15: G_PA_PROJ_RES_JOB_GRP NUMBER := to_number(fnd_profile.value('PA_PROJ_RES_JOB_GRP'));
16:
17: PROCEDURE log_message (p_log_msg IN VARCHAR2)
18: IS

Line 15: G_PA_PROJ_RES_JOB_GRP NUMBER := to_number(fnd_profile.value('PA_PROJ_RES_JOB_GRP'));

11: ----------------------------------------------------------------------------------------------------------------
12: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
13: -- Added Debug Profile Option variable initialization for bug#5094780
14: G_HR_CROSS_BUSINESS_GROUP varchar2(1) := fnd_profile.value('HR_CROSS_BUSINESS_GROUP');
15: G_PA_PROJ_RES_JOB_GRP NUMBER := to_number(fnd_profile.value('PA_PROJ_RES_JOB_GRP'));
16:
17: PROCEDURE log_message (p_log_msg IN VARCHAR2)
18: IS
19: BEGIN

Line 305: IF fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'Y'

301: l_business_group_id NUMBER;
302: BEGIN
303:
304: /*Commented for 5094780
305: IF fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'Y'
306: THEN
307: log_message('CBGA Profile is Y');
308: RETURN to_number(fnd_profile.value('PA_PROJ_RES_JOB_GRP'));
309: else */

Line 308: RETURN to_number(fnd_profile.value('PA_PROJ_RES_JOB_GRP'));

304: /*Commented for 5094780
305: IF fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'Y'
306: THEN
307: log_message('CBGA Profile is Y');
308: RETURN to_number(fnd_profile.value('PA_PROJ_RES_JOB_GRP'));
309: else */
310: -- changed for 5094780
311: IF G_HR_CROSS_BUSINESS_GROUP = 'Y'
312: THEN

Line 324: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');

320: -- parvw031.sql view
321: IF p_job_id is null THEN
322:
323: log_message('Get business group id from profile option');
324: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
325:
326: ELSE
327:
328: log_message('Get business group id using job id');