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'));
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:
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
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,
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,
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 );