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: l_err_count number := 0;

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: l_err_count number := 0;
77:

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: l_err_count number := 0;
77:
78: type t_num_tbl is table of NUMBER index by binary_integer;

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

124: BEGIN
125:
126: l_stmt_num := 10;
127:
128: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
129:
130: fnd_file.put_line(fnd_file.log, 'Parameters to Refresh_JobCopies are :');
131: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);
132: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );