eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_ACCESS_HOURS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 174


select
ASSIGNED_FLAG,
WORKING_FLAG ,
APPROVED_FLAG ,
COMPLETED_FLAG,
CANCELLED_FLAG,
REJECTED_FLAG,
ACCEPTED_FLAG,
ON_HOLD_FLAG ,
SCHEDULABLE_FLAG,
CLOSED_FLAG,
DELETE_ALLOWED_FLAG,
TASK_STATUS_FLAG ,
ASSIGNMENT_STATUS_FLAG,
SCHEDULED_START_DATE,
SCHEDULED_END_DATE,
START_DATE_TYPE,
END_DATE_TYPE,
ACTUAL_START_DATE,
ACTUAL_END_DATE
from
jtf_task_statuses_vl jtsv,jtf_tasks_b jtb
where
jtb.task_id=p_task_id
and
jtsv.task_status_id=jtb.task_status_id ;

Line: 211


l_DELETE_ALLOWED_FLAG  		 varchar2(1);

Line: 225


l_DELETE_ALLOWED_FLAG,l_TASK_STATUS_FLAG ,l_ASSIGNMENT_STATUS_FLAG ,l_scheduled_start_date,l_scheduled_end_date,l_start_date_type, l_end_date_type,l_actual_start_date,l_actual_end_date;

Line: 287


select
ACCESSHOUR_REQUIRED,
AFTER_HOURS_FLAG,
MONDAY_FIRST_START,
MONDAY_FIRST_END,
MONDAY_SECOND_START,
MONDAY_SECOND_END,
TUESDAY_FIRST_START,
TUESDAY_FIRST_END,
TUESDAY_SECOND_START,
TUESDAY_SECOND_END,
WEDNESDAY_FIRST_START,
WEDNESDAY_FIRST_END,
WEDNESDAY_SECOND_START,
WEDNESDAY_SECOND_END,
THURSDAY_FIRST_START,
THURSDAY_FIRST_END,
THURSDAY_SECOND_START,
THURSDAY_SECOND_END,
FRIDAY_FIRST_START,
FRIDAY_FIRST_END,
FRIDAY_SECOND_START,
FRIDAY_SECOND_END,
SATURDAY_FIRST_START,
SATURDAY_FIRST_END,
SATURDAY_SECOND_START,
SATURDAY_SECOND_END,
SUNDAY_FIRST_START,
SUNDAY_FIRST_END,
SUNDAY_SECOND_START,
SUNDAY_SECOND_END,
DESCRIPTION
from csf_access_hours_vl
where task_id=p_task_id;

Line: 361


IF l_task_status ='W' or l_task_status='X' or (l_task_status='A' and p_calling_routine='DELETE_ROW') then
fnd_message.set_name('CSF','CSF_ACCESS_INVALID_STATUS');-- require message

Line: 367


IF l_task_status ='A' and p_CALLING_ROUTINE='INSERT_ROW' then
IF          p_MONDAY_FIRST_START is not NULL
OR          p_MONDAY_FIRST_END is not NULL
OR          p_TUESDAY_FIRST_START is not NULL
OR          p_TUESDAY_FIRST_END is not NULL
OR          p_WEDNESDAY_FIRST_START is not NULL
OR          p_WEDNESDAY_FIRST_END is not NULL
OR          p_THURSDAY_FIRST_START is not NULL
OR          p_THURSDAY_FIRST_END is not NULL
OR          p_FRIDAY_FIRST_START  is not NULL
OR          p_FRIDAY_FIRST_END  is not NULL
OR          p_SATURDAY_FIRST_START  is not NULL
OR          p_SATURDAY_FIRST_END  is not NULL
OR          p_SUNDAY_FIRST_START is not NULL
OR          p_SUNDAY_FIRST_END is not NULL
OR          p_MONDAY_SECOND_START is not NULL
OR          p_MONDAY_SECOND_END is not NULL
OR          p_TUESDAY_SECOND_START is not NULL
OR          p_TUESDAY_SECOND_END  is not NULL
OR          p_WEDNESDAY_SECOND_START is not NULL
OR          p_WEDNESDAY_SECOND_END is not NULL
OR          p_THURSDAY_SECOND_START is not NULL
OR          p_THURSDAY_SECOND_END is not NULL
OR          p_FRIDAY_SECOND_START is not NULL
OR          p_FRIDAY_SECOND_END is not NULL
OR          p_SATURDAY_SECOND_START is not NULL
OR          p_SATURDAY_SECOND_END is not NULL
OR          p_SUNDAY_SECOND_START is not NULL
OR          p_SUNDAY_SECOND_END is not NULL
OR          p_DESCRIPTION is  null
OR          nvl(p_ACCESS_HOUR_REQD,'N')='Y'
OR          nvl(p_AFTER_HOURS_FLAG,'N') ='Y'
then
fnd_message.set_name('CSF','CSF_ACCESS_INVALID_INSERT');---require message

Line: 410


IF p_CALLING_ROUTINE='UPDATE_ROW' then
/*open c_existing_values(p_TASK_ID);

Line: 449


IF p_CALLING_ROUTINE='INSERT_ROW' or p_CALLING_ROUTINE='UPDATE_ROW' then

-- both flags should not be set to Y together

if nvl(p_ACCESS_HOUR_REQD,'N') ='Y' and nvl(p_AFTER_HOURS_FLAG,'N') ='Y' then
fnd_message.set_name('CSF','CSF_ACCESS_BOTH_FLAGS_INV');-- require message

Line: 664


          p_LAST_UPDATED_BY    NUMBER ,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER ,
  --        p_commit in     varchar2 default fnd_api.g_false,
          x_return_status            OUT NOCOPY            VARCHAR2,
	  x_msg_data                 OUT NOCOPY            VARCHAR2,
	  x_msg_count                OUT NOCOPY            NUMBER


)

          IS

   l_api_version CONSTANT Number := 1.0 ;

Line: 687


CURSOR C_EXISTS(p_task_id number) is select 'Y' from csf_access_hours_vl where task_id=p_task_id;

Line: 726


p_CALLING_ROUTINE => 'INSERT_ROW',
p_TASK_ID => p_TASK_ID,
p_ACCESS_HOUR_REQD=>nvl(p_ACCESS_HOUR_REQD,'N'),
p_AFTER_HOURS_FLAG =>nvl(p_AFTER_HOURS_FLAG,'N'),
p_MONDAY_FIRST_START =>p_MONDAY_FIRST_START,
p_MONDAY_FIRST_END  =>p_MONDAY_FIRST_END,
p_TUESDAY_FIRST_START  =>p_TUESDAY_FIRST_START,
p_TUESDAY_FIRST_END   =>p_TUESDAY_FIRST_END,
p_WEDNESDAY_FIRST_START =>p_WEDNESDAY_FIRST_START,
p_WEDNESDAY_FIRST_END  =>p_WEDNESDAY_FIRST_END ,
p_THURSDAY_FIRST_START  =>p_THURSDAY_FIRST_START ,
p_THURSDAY_FIRST_END  =>p_THURSDAY_FIRST_END,
p_FRIDAY_FIRST_START  =>p_FRIDAY_FIRST_START,
p_FRIDAY_FIRST_END  =>p_FRIDAY_FIRST_END ,
p_SATURDAY_FIRST_START =>p_SATURDAY_FIRST_START,
p_SATURDAY_FIRST_END  => p_SATURDAY_FIRST_END ,
p_SUNDAY_FIRST_START =>p_SUNDAY_FIRST_START ,
p_SUNDAY_FIRST_END  =>p_SUNDAY_FIRST_END   ,
p_MONDAY_SECOND_START => p_MONDAY_SECOND_START,
p_MONDAY_SECOND_END  =>p_MONDAY_SECOND_END  ,
p_TUESDAY_SECOND_START  =>p_TUESDAY_SECOND_START ,
p_TUESDAY_SECOND_END   =>p_TUESDAY_SECOND_END,
p_WEDNESDAY_SECOND_START =>p_WEDNESDAY_SECOND_START,
p_WEDNESDAY_SECOND_END  => p_WEDNESDAY_SECOND_END ,
p_THURSDAY_SECOND_START  =>p_THURSDAY_SECOND_START ,
p_THURSDAY_SECOND_END  => p_THURSDAY_SECOND_END ,
p_FRIDAY_SECOND_START  => p_FRIDAY_SECOND_START,
p_FRIDAY_SECOND_END  => p_FRIDAY_SECOND_END ,
p_SATURDAY_SECOND_START =>p_SATURDAY_SECOND_START ,
p_SATURDAY_SECOND_END  =>p_SATURDAY_SECOND_END  ,
p_SUNDAY_SECOND_START =>p_SUNDAY_SECOND_START ,
p_SUNDAY_SECOND_END  =>p_SUNDAY_SECOND_END  ,
p_DESCRIPTION => p_DESCRIPTION,
x_return_status            => l_return_status,
x_msg_count                => l_msg_count,
x_msg_data                 => l_msg_data

);

Line: 854


PROCEDURE UPDATE_ACCESS_HOURS(
          p_ACCESS_HOUR_ID   IN  NUMBER,
          p_TASK_ID    NUMBER,
          p_API_VERSION NUMBER,
          p_init_msg_list varchar2 ,
          p_commit        varchar2 ,
          p_ACCESS_HOUR_REQD VARCHAR2 ,
          p_AFTER_HOURS_FLAG VARCHAR2 ,
          p_MONDAY_FIRST_START DATE, --default TO_DATE(NULL),
          p_MONDAY_FIRST_END DATE, --default TO_DATE(NULL),
          p_MONDAY_SECOND_START DATE, --default TO_DATE(NULL),
          p_MONDAY_SECOND_END DATE, --default TO_DATE(NULL),
          p_TUESDAY_FIRST_START DATE, --default TO_DATE(NULL),
          p_TUESDAY_FIRST_END DATE, --default  TO_DATE(NULL) ,
          p_TUESDAY_SECOND_START DATE, --default TO_DATE(NULL),
          p_TUESDAY_SECOND_END DATE, --default TO_DATE(NULL) ,
          p_WEDNESDAY_FIRST_START DATE, --default TO_DATE(NULL),
          p_WEDNESDAY_FIRST_END DATE, -- default TO_DATE(NULL),
          p_WEDNESDAY_SECOND_START DATE, --default TO_DATE(NULL),
          p_WEDNESDAY_SECOND_END DATE,-- default TO_DATE(NULL),
          p_THURSDAY_FIRST_START DATE, --default TO_DATE(NULL),
          p_THURSDAY_FIRST_END DATE, --default TO_DATE(NULL),
          p_THURSDAY_SECOND_START DATE, --default TO_DATE(NULL),
          p_THURSDAY_SECOND_END DATE, --default TO_DATE(NULL),
          p_FRIDAY_FIRST_START DATE,-- default TO_DATE(NULL),
          p_FRIDAY_FIRST_END DATE,-- default TO_DATE(NULL),
          p_FRIDAY_SECOND_START DATE, --default TO_DATE(NULL),
          p_FRIDAY_SECOND_END DATE,-- default TO_DATE(NULL),
          p_SATURDAY_FIRST_START DATE, --default TO_DATE(NULL),
          p_SATURDAY_FIRST_END DATE, --default TO_DATE(NULL),
          p_SATURDAY_SECOND_START DATE,-- default TO_DATE(NULL),
          p_SATURDAY_SECOND_END DATE, --default TO_DATE(NULL),
          p_SUNDAY_FIRST_START DATE, --default TO_DATE(NULL),
          p_SUNDAY_FIRST_END DATE, -- default TO_DATE(NULL),
          p_SUNDAY_SECOND_START DATE, --default TO_DATE(NULL),
          p_SUNDAY_SECOND_END DATE, --default TO_DATE(NULL),
          p_DESCRIPTION VARCHAR2 DEFAULT null,
          px_object_version_number in out nocopy number,
          p_CREATED_BY    NUMBER default null,
          p_CREATION_DATE    DATE default null,
          p_LAST_UPDATED_BY    NUMBER default null,
          p_LAST_UPDATE_DATE    DATE default null,
          p_LAST_UPDATE_LOGIN    NUMBER default null,
          x_return_status            OUT NOCOPY            VARCHAR2,
	  x_msg_data                 OUT NOCOPY            VARCHAR2,
	  x_msg_count                OUT NOCOPY            NUMBER

          )

 IS
          l_api_name_full constant varchar2(50) := 'CSF_ACCESS_HOURS_PUB.UPDATE_ACCESS_HOURS';

Line: 917


select
ACCESSHOUR_REQUIRED,
AFTER_HOURS_FLAG,
MONDAY_FIRST_START,
MONDAY_FIRST_END,
MONDAY_SECOND_START,
MONDAY_SECOND_END,
TUESDAY_FIRST_START,
TUESDAY_FIRST_END,
TUESDAY_SECOND_START,
TUESDAY_SECOND_END,
WEDNESDAY_FIRST_START,
WEDNESDAY_FIRST_END,
WEDNESDAY_SECOND_START,
WEDNESDAY_SECOND_END,
THURSDAY_FIRST_START,
THURSDAY_FIRST_END,
THURSDAY_SECOND_START,
THURSDAY_SECOND_END,
FRIDAY_FIRST_START,
FRIDAY_FIRST_END,
FRIDAY_SECOND_START,
FRIDAY_SECOND_END,
SATURDAY_FIRST_START,
SATURDAY_FIRST_END,
SATURDAY_SECOND_START,
SATURDAY_SECOND_END,
SUNDAY_FIRST_START,
SUNDAY_FIRST_END,
SUNDAY_SECOND_START,
SUNDAY_SECOND_END,
DESCRIPTION,
object_version_number
from csf_access_hours_vl
where task_id=p_task_id;

Line: 990


CURSOR C_EXISTS(p_task_id number) is select 'Y' from csf_access_hours_vl where task_id=p_task_id;

Line: 993


SAVEPOINT update_access_hours_pub;

Line: 1264


p_CALLING_ROUTINE => 'UPDATE_ROW',
p_TASK_ID => p_TASK_ID,
p_ACCESS_HOUR_REQD=>l_ACCESS_HOUR_REQD,
p_AFTER_HOURS_FLAG =>l_AFTER_HOURS_FLAG,
p_MONDAY_FIRST_START =>l_MONDAY_FIRST_START,
p_MONDAY_FIRST_END  =>l_MONDAY_FIRST_END,
p_TUESDAY_FIRST_START  =>l_TUESDAY_FIRST_START,
p_TUESDAY_FIRST_END   =>l_TUESDAY_FIRST_END,
p_WEDNESDAY_FIRST_START =>l_WEDNESDAY_FIRST_START,
p_WEDNESDAY_FIRST_END  =>l_WEDNESDAY_FIRST_END ,
p_THURSDAY_FIRST_START  =>l_THURSDAY_FIRST_START ,
p_THURSDAY_FIRST_END  =>l_THURSDAY_FIRST_END,
p_FRIDAY_FIRST_START  =>l_FRIDAY_FIRST_START,
p_FRIDAY_FIRST_END  =>l_FRIDAY_FIRST_END ,
p_SATURDAY_FIRST_START =>l_SATURDAY_FIRST_START,
p_SATURDAY_FIRST_END  => l_SATURDAY_FIRST_END ,
p_SUNDAY_FIRST_START =>l_SUNDAY_FIRST_START ,
p_SUNDAY_FIRST_END  =>l_SUNDAY_FIRST_END   ,
p_MONDAY_SECOND_START => l_MONDAY_SECOND_START,
p_MONDAY_SECOND_END  =>l_MONDAY_SECOND_END  ,
p_TUESDAY_SECOND_START  =>l_TUESDAY_SECOND_START ,
p_TUESDAY_SECOND_END   =>l_TUESDAY_SECOND_END,
p_WEDNESDAY_SECOND_START =>l_WEDNESDAY_SECOND_START,
p_WEDNESDAY_SECOND_END  => l_WEDNESDAY_SECOND_END ,
p_THURSDAY_SECOND_START  =>l_THURSDAY_SECOND_START ,
p_THURSDAY_SECOND_END  => l_THURSDAY_SECOND_END ,
p_FRIDAY_SECOND_START  => l_FRIDAY_SECOND_START,
p_FRIDAY_SECOND_END  => l_FRIDAY_SECOND_END ,
p_SATURDAY_SECOND_START =>l_SATURDAY_SECOND_START ,
p_SATURDAY_SECOND_END  =>l_SATURDAY_SECOND_END  ,
p_SUNDAY_SECOND_START =>l_SUNDAY_SECOND_START ,
p_SUNDAY_SECOND_END  =>l_SUNDAY_SECOND_END  ,
p_DESCRIPTION => l_DESCRIPTION,
x_return_status            => l_return_status,
x_msg_count                => l_msg_count,
x_msg_data                 => l_msg_data

);

Line: 1312


CSF_ACCESS_HOURS_PVT.UPDATE_ACCESS_HOURS(
p_API_VERSION => 1.0,
p_INIT_MSG_LIST => 'F',
p_ACCESS_HOUR_ID =>p_ACCESS_HOUR_ID,
p_TASK_ID=>p_TASK_ID,
p_ACCESS_HOUR_REQD=>l_ACCESS_HOUR_REQD,
p_AFTER_HOURS_FLAG =>l_AFTER_HOURS_FLAG,
p_MONDAY_FIRST_START =>l_MONDAY_FIRST_START,
p_MONDAY_FIRST_END  =>l_MONDAY_FIRST_END,
p_TUESDAY_FIRST_START  =>l_TUESDAY_FIRST_START,
p_TUESDAY_FIRST_END   =>l_TUESDAY_FIRST_END,
p_WEDNESDAY_FIRST_START =>l_WEDNESDAY_FIRST_START,
p_WEDNESDAY_FIRST_END  =>l_WEDNESDAY_FIRST_END ,
p_THURSDAY_FIRST_START  =>l_THURSDAY_FIRST_START ,
p_THURSDAY_FIRST_END  =>l_THURSDAY_FIRST_END,
p_FRIDAY_FIRST_START  =>l_FRIDAY_FIRST_START,
p_FRIDAY_FIRST_END  =>l_FRIDAY_FIRST_END ,
p_SATURDAY_FIRST_START =>l_SATURDAY_FIRST_START,
p_SATURDAY_FIRST_END  => l_SATURDAY_FIRST_END ,
p_SUNDAY_FIRST_START =>l_SUNDAY_FIRST_START ,
p_SUNDAY_FIRST_END  =>l_SUNDAY_FIRST_END   ,
p_MONDAY_SECOND_START => l_MONDAY_SECOND_START,
p_MONDAY_SECOND_END  =>l_MONDAY_SECOND_END  ,
p_TUESDAY_SECOND_START  =>l_TUESDAY_SECOND_START ,
p_TUESDAY_SECOND_END   =>l_TUESDAY_SECOND_END,
p_WEDNESDAY_SECOND_START =>l_WEDNESDAY_SECOND_START,
p_WEDNESDAY_SECOND_END  => l_WEDNESDAY_SECOND_END ,
p_THURSDAY_SECOND_START  =>l_THURSDAY_SECOND_START ,
p_THURSDAY_SECOND_END  => l_THURSDAY_SECOND_END ,
p_FRIDAY_SECOND_START  => l_FRIDAY_SECOND_START,
p_FRIDAY_SECOND_END  => l_FRIDAY_SECOND_END ,
p_SATURDAY_SECOND_START =>l_SATURDAY_SECOND_START ,
p_SATURDAY_SECOND_END  =>l_SATURDAY_SECOND_END  ,
p_SUNDAY_SECOND_START =>l_SUNDAY_SECOND_START ,
p_SUNDAY_SECOND_END  =>l_SUNDAY_SECOND_END  ,
p_DESCRIPTION => l_DESCRIPTION,
px_object_version_number => px_object_version_number,
p_commit                 => nvl(p_commit,fnd_Api.g_false),
x_return_status            => l_return_status,
x_msg_count                => l_msg_count,
x_msg_data                 => l_msg_data

    );

Line: 1369


ROLLBACK TO update_access_hours_pub;

Line: 1376


ROLLBACK TO  update_access_hours_pub;

Line: 1383


ROLLBACK TO  update_access_hours_pub;

Line: 1390


END  UPDATE_ACCESS_HOURS;

Line: 1392


PROCEDURE DELETE_ACCESS_HOURS(
    p_TASK_ID    NUMBER,
    p_ACCESS_HOUR_ID  NUMBER,
    p_API_VERSION NUMBER,
    p_init_msg_list varchar2 default null,
  --  p_commit in     varchar2 default fnd_api.g_false,
    x_return_status            OUT NOCOPY            VARCHAR2,
    x_msg_data                 OUT NOCOPY            VARCHAR2,
    x_msg_count                OUT NOCOPY            NUMBER)
 IS
   l_return_status    varchar2(100);

Line: 1405


   l_api_name_full constant varchar2(50) := 'CSF_ACCESS_HOURS_PUB.DELETE_ACCESS_HOURS';

Line: 1413


CURSOR C_EXISTS(p_task_id number) is select 'Y' from csf_access_hours_vl where task_id=p_task_id;

Line: 1416


SAVEPOINT delete_access_hours_pub;

Line: 1452


p_CALLING_ROUTINE => 'DELETE_ROW',
p_TASK_ID => p_TASK_ID,
x_return_status            => l_return_status,
x_msg_count                => l_msg_count,
x_msg_data                 => l_msg_data

);

Line: 1469


CSF_ACCESS_HOURS_PVT.DELETE_ACCESS_HOURS(
p_API_VERSION => 1.0,
p_INIT_MSG_LIST => 'F',
p_ACCESS_HOUR_ID =>p_ACCESS_HOUR_ID,
p_commit =>fnd_api.g_true, --p_commit,--fnd_api.g_true,
x_return_status            => l_return_status,
x_msg_count                => l_msg_count,
x_msg_data                 => l_msg_data
);

Line: 1483


  /* DELETE FROM CSF_ACCESS_HOURS_B
    WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;*/

Line: 1502


ROLLBACK TO delete_access_hours_pub;

Line: 1509


ROLLBACK TO  delete_access_hours_pub;

Line: 1516


ROLLBACK TO  delete_access_hours_pub;

Line: 1522


 END DELETE_ACCESS_HOURS;

Line: 1524


PROCEDURE update_access_hours(
    p_api_version           number
  , p_init_msg_list         varchar2
  , p_commit                varchar2
  , p_task_id               number
  , p_access_hour_reqd      varchar2
  , x_object_version_number in out nocopy number
  , x_return_status         out nocopy varchar2
  , x_msg_data              out nocopy varchar2
  , x_msg_count             out nocopy number
  )
IS
          l_api_name_full constant varchar2(50) := 'CSF_ACCESS_HOURS_PUB.UPDATE_ACCESS_HOURS-2';

Line: 1543


select
ACCESS_HOUR_ID,
ACCESSHOUR_REQUIRED,
AFTER_HOURS_FLAG,
DESCRIPTION,
object_version_number
from csf_access_hours_vl
where task_id=p_task_id;

Line: 1561


SAVEPOINT update_access_hours_pub2;

Line: 1598


UPDATE_ACCESS_HOURS(
          p_ACCESS_HOUR_ID => l_rec.access_hour_id,
          p_TASK_ID  =>P_TASK_ID,
          p_API_VERSION =>l_api_version,
          p_init_msg_list =>nvl(p_init_msg_list,fnd_api.g_false),
          p_commit => nvl(p_commit,fnd_api.g_false),
          p_ACCESS_HOUR_REQD=>p_Access_hour_reqd ,
          p_AFTER_HOURS_FLAG=> l_rec.after_hours_flag,
          p_MONDAY_FIRST_START =>NULL,
          p_MONDAY_FIRST_END =>NULL,
          p_MONDAY_SECOND_START =>NULL,
          p_MONDAY_SECOND_END =>NULL,
          p_TUESDAY_FIRST_START =>NULL,
          p_TUESDAY_FIRST_END => NULL,
          p_TUESDAY_SECOND_START =>NULL,
          p_TUESDAY_SECOND_END => NULL,
          p_WEDNESDAY_FIRST_START => NULL,
          p_WEDNESDAY_FIRST_END =>NULL,
          p_WEDNESDAY_SECOND_START => NULL,
          p_WEDNESDAY_SECOND_END =>NULL,
          p_THURSDAY_FIRST_START =>NULL,
          p_THURSDAY_FIRST_END =>NULL,
          p_THURSDAY_SECOND_START =>NULL,
          p_THURSDAY_SECOND_END =>NULL,
          p_FRIDAY_FIRST_START =>NULL,
          p_FRIDAY_FIRST_END => NULL,
          p_FRIDAY_SECOND_START =>NULL,
          p_FRIDAY_SECOND_END =>NULL,
          p_SATURDAY_FIRST_START =>NULL,
          p_SATURDAY_FIRST_END =>NULL,
          p_SATURDAY_SECOND_START => NULL,
          p_SATURDAY_SECOND_END =>NULL,
          p_SUNDAY_FIRST_START =>NULL,
          p_SUNDAY_FIRST_END => NULL,
          p_SUNDAY_SECOND_START =>NULL,
          p_SUNDAY_SECOND_END =>NULL,
          p_DESCRIPTION=> l_rec.description,
          px_object_version_number=>l_object_version_number,
          x_return_status=>x_return_status,
	  x_msg_data => x_msg_data,
	  x_msg_count=> x_msg_count
   );

Line: 1644


ROLLBACK TO update_access_hours_pub2;

Line: 1651


ROLLBACK TO  update_access_hours_pub2;

Line: 1658


ROLLBACK TO  update_access_hours_pub2;

Line: 1665


END UPDATE_ACCESS_HOURS;