DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PUB dependencies on FND_PROFILE

Line 70: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND

66: l_bom_rev_basis NUMBER; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
67: l_new_rev_date_bom DATE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
68: l_rtg_revision WIP_DISCRETE_JOBS.ROUTING_REVISION%TYPE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
69: l_bom_revision WIP_DISCRETE_JOBS.BOM_REVISION%TYPE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
70: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
71: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
72: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
73: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
74: fnd_profile.value('SERVER_TIMEZONE_ID'));

Line 71: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND

67: l_new_rev_date_bom DATE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
68: l_rtg_revision WIP_DISCRETE_JOBS.ROUTING_REVISION%TYPE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
69: l_bom_revision WIP_DISCRETE_JOBS.BOM_REVISION%TYPE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
70: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
71: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
72: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
73: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
74: fnd_profile.value('SERVER_TIMEZONE_ID'));
75:

Line 72: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND

68: l_rtg_revision WIP_DISCRETE_JOBS.ROUTING_REVISION%TYPE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
69: l_bom_revision WIP_DISCRETE_JOBS.BOM_REVISION%TYPE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
70: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
71: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
72: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
73: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
74: fnd_profile.value('SERVER_TIMEZONE_ID'));
75:
76: CURSOR refresh_jobs IS

Line 73: fnd_profile.value('CLIENT_TIMEZONE_ID') <>

69: l_bom_revision WIP_DISCRETE_JOBS.BOM_REVISION%TYPE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
70: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
71: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
72: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
73: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
74: fnd_profile.value('SERVER_TIMEZONE_ID'));
75:
76: CURSOR refresh_jobs IS
77: SELECT wdj.wip_entity_id,

Line 74: fnd_profile.value('SERVER_TIMEZONE_ID'));

70: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
71: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
72: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
73: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
74: fnd_profile.value('SERVER_TIMEZONE_ID'));
75:
76: CURSOR refresh_jobs IS
77: SELECT wdj.wip_entity_id,
78: we.wip_entity_name,

Line 141: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');

137: BEGIN
138:
139: l_stmt_num := 10;
140:
141: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
142:
143: fnd_file.put_line(fnd_file.log, 'Parameters to Refresh_JobCopies are :');
144: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);
145: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );