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_PVT SQL Statements

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

Line: 63


          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE ,
          p_LAST_UPDATE_LOGIN    NUMBER ,
          p_commit in     varchar2 ,
          x_return_status            OUT NOCOPY            VARCHAR2,
	      x_msg_data                 OUT NOCOPY            VARCHAR2,
	      x_msg_count                OUT NOCOPY            NUMBER,
		  p_data_chg_frm_ui			 VARCHAR2
)

          IS
   CURSOR c_next_seq IS SELECT CSF_ACCESS_HOURS_B_S1.nextval FROM sys.dual;

Line: 84


Cursor c_check_b is select ROWID from csf_access_hours_b where access_hour_id=x_access_hour_id;

Line: 85


Cursor c_check_tl is select ROWID from csf_access_hours_tl where access_hour_id=x_access_hour_id;

Line: 104


     INSERT INTO CSF_ACCESS_HOURS_B(
          ACCESS_HOUR_ID,
          TASK_ID  ,
          CREATED_BY ,
          CREATION_DATE,
          LAST_UPDATED_BY,
          LAST_UPDATE_DATE,
          LAST_UPDATE_LOGIN,
          ACCESSHOUR_REQUIRED,
          AFTER_HOURS_FLAG,
          MONDAY_FIRST_START,
          MONDAY_FIRST_END,
          TUESDAY_FIRST_START,
          TUESDAY_FIRST_END ,
          WEDNESDAY_FIRST_START,
          WEDNESDAY_FIRST_END,
          THURSDAY_FIRST_START ,
          THURSDAY_FIRST_END ,
          FRIDAY_FIRST_START ,
          FRIDAY_FIRST_END ,
          SATURDAY_FIRST_START,
          SATURDAY_FIRST_END ,
          SUNDAY_FIRST_START ,
          SUNDAY_FIRST_END,
          MONDAY_SECOND_START,
          MONDAY_SECOND_END,
          TUESDAY_SECOND_START,
          TUESDAY_SECOND_END ,
          WEDNESDAY_SECOND_START,
          WEDNESDAY_SECOND_END,
          THURSDAY_SECOND_START ,
          THURSDAY_SECOND_END ,
          FRIDAY_SECOND_START ,
          FRIDAY_SECOND_END ,
          SATURDAY_SECOND_START,
          SATURDAY_SECOND_END ,
          SUNDAY_SECOND_START ,
          SUNDAY_SECOND_END,
          OBJECT_VERSION_NUMBER,
		  DATA_CHANGED_FRM_UI

          ) VALUES (
           x_ACCESS_HOUR_ID,
           p_TASK_ID,
           fnd_global.user_id,
           sysdate,
           g_user_id,
           sysdate,
           g_login_id,
           p_ACCESS_HOUR_REQD,
           p_AFTER_HOURS_FLAG,
           decode( p_MONDAY_FIRST_START,TO_DATE(NULL), TO_DATE(NULL), TO_DATE('5-01-1970 '||TO_CHAR(p_MONDAY_FIRST_START,'hh24:mi'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_MONDAY_FIRST_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('5-01-1970 '||to_char(p_MONDAY_FIRST_END,'hh24:mi'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_TUESDAY_FIRST_START, TO_DATE(NULL),TO_DATE(NULL), TO_DATE('6-01-1970'||to_char(p_TUESDAY_FIRST_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_TUESDAY_FIRST_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('6-01-1970'||to_char(p_TUESDAY_FIRST_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_WEDNESDAY_FIRST_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('7-01-1970'||to_char(p_WEDNESDAY_FIRST_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_WEDNESDAY_FIRST_END,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('7-01-1970'||to_char(p_WEDNESDAY_FIRST_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_THURSDAY_FIRST_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('1-01-1970'||to_char(p_THURSDAY_FIRST_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_THURSDAY_FIRST_END,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('1-01-1970'||to_char(p_THURSDAY_FIRST_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_FRIDAY_FIRST_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('2-01-1970'||to_char(p_FRIDAY_FIRST_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_FRIDAY_FIRST_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('2-01-1970'||to_char(p_FRIDAY_FIRST_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_SATURDAY_FIRST_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('3-01-1970'||to_char(p_SATURDAY_FIRST_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_SATURDAY_FIRST_END,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('3-01-1970'||to_char(p_SATURDAY_FIRST_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_SUNDAY_FIRST_START,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('4-01-1970'||to_char(p_SUNDAY_FIRST_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_SUNDAY_FIRST_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('4-01-1970'||to_char(p_SUNDAY_FIRST_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_MONDAY_SECOND_START,TO_DATE(NULL), TO_DATE(NULL), TO_DATE('5-01-1970 '||TO_CHAR(p_MONDAY_SECOND_START,'hh24:mi'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_MONDAY_SECOND_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('5-01-1970 '||to_char(p_MONDAY_SECOND_END,'hh24:mi'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_TUESDAY_SECOND_START, TO_DATE(NULL),TO_DATE(NULL), TO_DATE('6-01-1970'||to_char(p_TUESDAY_SECOND_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_TUESDAY_SECOND_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('6-01-1970'||to_char(p_TUESDAY_SECOND_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_WEDNESDAY_SECOND_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('7-01-1970'||to_char(p_WEDNESDAY_SECOND_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_WEDNESDAY_SECOND_END,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('7-01-1970'||to_char(p_WEDNESDAY_SECOND_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_THURSDAY_SECOND_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('1-01-1970'||to_char(p_THURSDAY_SECOND_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_THURSDAY_SECOND_END,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('1-01-1970'||to_char(p_THURSDAY_SECOND_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_FRIDAY_SECOND_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('2-01-1970'||to_char(p_FRIDAY_SECOND_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_FRIDAY_SECOND_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('2-01-1970'||to_char(p_FRIDAY_SECOND_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_SATURDAY_SECOND_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('3-01-1970'||to_char(p_SATURDAY_SECOND_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_SATURDAY_SECOND_END,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('3-01-1970'||to_char(p_SATURDAY_SECOND_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_SUNDAY_SECOND_START,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('4-01-1970'||to_char(p_SUNDAY_SECOND_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode( p_SUNDAY_SECOND_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('4-01-1970'||to_char(p_SUNDAY_SECOND_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
           decode (px_OBJECT_VERSION_NUMBER,NULL,1,px_OBJECT_VERSION_NUMBER),
		   nvl(p_data_chg_frm_ui,'N')

           );

Line: 197


    insert into CSF_ACCESS_HOURS_TL(
    ACCESS_HOUR_ID,
    DESCRIPTION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    x_ACCESS_HOUR_ID,
    p_DESCRIPTION,
   fnd_global.user_id,
           sysdate,
           g_user_id,
           sysdate,
           g_login_id,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where l.installed_flag in ('I','B')
  and not exists
    (select NULL
    from CSF_ACCESS_HOURS_TL T
    where T.ACCESS_HOUR_ID= x_ACCESS_HOUR_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 263


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

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

Line: 322


   Update CSF_ACCESS_HOURS_B
    SET

  LAST_UPDATE_DATE            = sysdate,
  LAST_UPDATED_BY             = g_user_id,
  LAST_UPDATE_LOGIN           = g_login_id,
  ACCESSHOUR_REQUIRED         = p_ACCESS_HOUR_REQD,
  AFTER_HOURS_FLAG            = p_AFTER_HOURS_FLAG,
  MONDAY_FIRST_START                = decode( p_MONDAY_FIRST_START,TO_DATE(NULL), TO_DATE(NULL), TO_DATE('5-01-1970 '||TO_CHAR(p_MONDAY_FIRST_START,'hh24:mi'),'DD-MM-RRRR HH24:MI:SS')),
  MONDAY_FIRST_END                  = decode( p_MONDAY_FIRST_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('5-01-1970 '||to_char(p_MONDAY_FIRST_END,'hh24:mi'),'DD-MM-RRRR HH24:MI:SS')),
  TUESDAY_FIRST_START               = decode( p_TUESDAY_FIRST_START, TO_DATE(NULL),TO_DATE(NULL), TO_DATE('6-01-1970'||to_char(p_TUESDAY_FIRST_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  TUESDAY_FIRST_END                 = decode( p_TUESDAY_FIRST_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('6-01-1970'||to_char(p_TUESDAY_FIRST_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  WEDNESDAY_FIRST_START             = decode( p_WEDNESDAY_FIRST_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('7-01-1970'||to_char(p_WEDNESDAY_FIRST_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  WEDNESDAY_FIRST_END               = decode( p_WEDNESDAY_FIRST_END,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('7-01-1970'||to_char(p_WEDNESDAY_FIRST_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  THURSDAY_FIRST_START              = decode( p_THURSDAY_FIRST_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('1-01-1970'||to_char(p_THURSDAY_FIRST_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  THURSDAY_FIRST_END                = decode( p_THURSDAY_FIRST_END,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('1-01-1970'||to_char(p_THURSDAY_FIRST_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  FRIDAY_FIRST_START                = decode( p_FRIDAY_FIRST_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('2-01-1970'||to_char(p_FRIDAY_FIRST_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  FRIDAY_FIRST_END                  = decode( p_FRIDAY_FIRST_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('2-01-1970'||to_char(p_FRIDAY_FIRST_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  SATURDAY_FIRST_START              = decode( p_SATURDAY_FIRST_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('3-01-1970'||to_char(p_SATURDAY_FIRST_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  SATURDAY_FIRST_END                = decode( p_SATURDAY_FIRST_END,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('3-01-1970'||to_char(p_SATURDAY_FIRST_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  SUNDAY_FIRST_START                = decode( p_SUNDAY_FIRST_START,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('4-01-1970'||to_char(p_SUNDAY_FIRST_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  SUNDAY_FIRST_END                  = decode( p_SUNDAY_FIRST_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('4-01-1970'||to_char(p_SUNDAY_FIRST_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  MONDAY_SECOND_START                = decode( p_MONDAY_SECOND_START,TO_DATE(NULL), TO_DATE(NULL), TO_DATE('5-01-1970 '||TO_CHAR(p_MONDAY_SECOND_START,'hh24:mi'),'DD-MM-RRRR HH24:MI:SS')),
  MONDAY_SECOND_END                  = decode( p_MONDAY_SECOND_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('5-01-1970 '||to_char(p_MONDAY_SECOND_END,'hh24:mi'),'DD-MM-RRRR HH24:MI:SS')),
  TUESDAY_SECOND_START               = decode( p_TUESDAY_SECOND_START, TO_DATE(NULL),TO_DATE(NULL), TO_DATE('6-01-1970'||to_char(p_TUESDAY_SECOND_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  TUESDAY_SECOND_END                 = decode( p_TUESDAY_SECOND_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('6-01-1970'||to_char(p_TUESDAY_SECOND_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  WEDNESDAY_SECOND_START             = decode( p_WEDNESDAY_SECOND_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('7-01-1970'||to_char(p_WEDNESDAY_SECOND_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  WEDNESDAY_SECOND_END               = decode( p_WEDNESDAY_SECOND_END,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('7-01-1970'||to_char(p_WEDNESDAY_SECOND_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  THURSDAY_SECOND_START              = decode( p_THURSDAY_SECOND_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('1-01-1970'||to_char(p_THURSDAY_SECOND_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  THURSDAY_SECOND_END                = decode( p_THURSDAY_SECOND_END,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('1-01-1970'||to_char(p_THURSDAY_SECOND_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  FRIDAY_SECOND_START                = decode( p_FRIDAY_SECOND_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('2-01-1970'||to_char(p_FRIDAY_SECOND_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  FRIDAY_SECOND_END                  = decode( p_FRIDAY_SECOND_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('2-01-1970'||to_char(p_FRIDAY_SECOND_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  SATURDAY_SECOND_START              = decode( p_SATURDAY_SECOND_START, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('3-01-1970'||to_char(p_SATURDAY_SECOND_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  SATURDAY_SECOND_END                = decode( p_SATURDAY_SECOND_END,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('3-01-1970'||to_char(p_SATURDAY_SECOND_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  SUNDAY_SECOND_START                = decode( p_SUNDAY_SECOND_START,  TO_DATE(NULL), TO_DATE(NULL), TO_DATE('4-01-1970'||to_char(p_SUNDAY_SECOND_START,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  SUNDAY_SECOND_END                  = decode( p_SUNDAY_SECOND_END, TO_DATE(NULL), TO_DATE(NULL), TO_DATE('4-01-1970'||to_char(p_SUNDAY_SECOND_END,'hh24:mi:ss'),'DD-MM-RRRR HH24:MI:SS')),
  OBJECT_VERSION_NUMBER       		 = px_object_version_number,
  DATA_CHANGED_FRM_UI                = nvl(p_data_chg_frm_ui,'N')
  where ACCESS_HOUR_ID = p_ACCESS_HOUR_ID
  and   TASK_ID=p_TASK_ID;

Line: 369


 update CSF_ACCESS_HOURS_TL set
    DESCRIPTION = p_DESCRIPTION,
    LAST_UPDATE_DATE            = sysdate,
  LAST_UPDATED_BY             = g_user_id,
  LAST_UPDATE_LOGIN           = g_login_id,
    SOURCE_LANG = userenv('LANG')
  where ACCESS_HOUR_ID = p_ACCESS_HOUR_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 413


END Update_Access_Hours;

Line: 415


PROCEDURE Delete_Access_Hours(
	  p_API_VERSION              IN                     NUMBER,
	  p_INIT_MSG_LIST            IN                     VARCHAR2 ,
      p_ACCESS_HOUR_ID  		 NUMBER,
      p_commit in     			 varchar2 ,
      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: 428


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

Line: 431


 DELETE FROM CSF_ACCESS_HOURS_TL
    WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;

Line: 438


   DELETE FROM CSF_ACCESS_HOURS_B
    WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;

Line: 475


 END Delete_Access_Hours;

Line: 494


      select object_version_number
      from csf_access_hours_b
      where access_hour_id = p_access_hour_id
      for update of access_hour_id nowait;

Line: 511


      fnd_message.set_name('FND', 'FORM_RECORD_DELETED');