APPS.JTF_CALENDARS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ERROR out NOCOPY VARCHAR2,
  X_ROWID in out NOCOPY VARCHAR2,
  X_CALENDAR_ID in out NOCOPY NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_CALENDAR_TYPE in VARCHAR2,
  X_CALENDAR_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from JTF_CALENDARS_B
    where CALENDAR_ID = X_CALENDAR_ID;

Line: 60

        select count(*) into temp_count
          FROM JTF_CALENDARS_VL
          WHERE upper(calendar_name) = upper(X_CALENDAR_NAME)
          AND UPPER(calendar_type) = upper(X_CALENDAR_TYPE)
	  --- Added for bug 5123027 by abraina
          and (
               start_date_active <= nvl(X_END_DATE_ACTIVE,to_date('12/31/9999','mm/dd/yyyy'))
          and
               nvl(end_date_active,to_date('12/31/9999','mm/dd/yyyy')) >= X_START_DATE_ACTIVE
               ) ;

Line: 100

			SELECT 	JTF_CALENDARS_S.nextval
			INTO	v_calendar_id
			FROM	dual;

Line: 106

		   insert into JTF_CALENDARS_B (
		    OBJECT_VERSION_NUMBER,
		    CALENDAR_ID,
		    START_DATE_ACTIVE,
		    END_DATE_ACTIVE,
		    ATTRIBUTE1,
		    ATTRIBUTE2,
		    ATTRIBUTE3,
		    ATTRIBUTE4,
		    ATTRIBUTE5,
		    ATTRIBUTE6,
		    ATTRIBUTE7,
		    ATTRIBUTE8,
		    ATTRIBUTE9,
		    ATTRIBUTE10,
		    ATTRIBUTE11,
		    ATTRIBUTE12,
		    ATTRIBUTE13,
		    ATTRIBUTE14,
		    ATTRIBUTE15,
		    ATTRIBUTE_CATEGORY,
		    CALENDAR_TYPE,
		    CREATION_DATE,
		    CREATED_BY,
		    LAST_UPDATE_DATE,
		    LAST_UPDATED_BY,
		    LAST_UPDATE_LOGIN
		  ) values (
		    nvl(X_OBJECT_VERSION_NUMBER,1),
		    v_calendar_id,
		    X_START_DATE_ACTIVE,
		    X_END_DATE_ACTIVE,
		    X_ATTRIBUTE1,
		    X_ATTRIBUTE2,
		    X_ATTRIBUTE3,
		    X_ATTRIBUTE4,
		    X_ATTRIBUTE5,
		    X_ATTRIBUTE6,
		    X_ATTRIBUTE7,
		    X_ATTRIBUTE8,
		    X_ATTRIBUTE9,
		    X_ATTRIBUTE10,
		    X_ATTRIBUTE11,
		    X_ATTRIBUTE12,
		    X_ATTRIBUTE13,
		    X_ATTRIBUTE14,
		    X_ATTRIBUTE15,
		    X_ATTRIBUTE_CATEGORY,
		    X_CALENDAR_TYPE,
		    sysdate,
		    FND_GLOBAL.USER_ID,
		    sysdate,
		    FND_GLOBAL.USER_ID,
		    NULL
		  );

Line: 162

		  insert into JTF_CALENDARS_TL (
		    CALENDAR_ID,
		    CALENDAR_NAME,
		    DESCRIPTION,
		    CREATED_BY,
		    CREATION_DATE,
		    LAST_UPDATED_BY,
		    LAST_UPDATE_DATE,
		    LAST_UPDATE_LOGIN,
		    LANGUAGE,
		    SOURCE_LANG
		  ) select
		    v_calendar_id,
		    X_CALENDAR_NAME,
		    X_DESCRIPTION,
		    FND_GLOBAL.USER_ID,
		    sysdate,
		    FND_GLOBAL.USER_ID,
		    sysdate,
		    NULL,
		    L.LANGUAGE_CODE,
		    userenv('LANG')
		  from FND_LANGUAGES L
		  where L.INSTALLED_FLAG in ('I', 'B')
		  and not exists
		    (select NULL
		    from JTF_CALENDARS_TL T
		    where T.CALENDAR_ID = X_CALENDAR_ID
		    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 201

end INSERT_ROW;

Line: 228

  cursor c is select
      OBJECT_VERSION_NUMBER,
      START_DATE_ACTIVE,
      END_DATE_ACTIVE,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE_CATEGORY,
      CALENDAR_TYPE
    from JTF_CALENDARS_B
    where CALENDAR_ID = X_CALENDAR_ID
    for update of CALENDAR_ID nowait;

Line: 254

  cursor c1 is select
      CALENDAR_NAME,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from JTF_CALENDARS_TL
    where CALENDAR_ID = X_CALENDAR_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of CALENDAR_ID nowait;

Line: 267

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

Line: 335

procedure UPDATE_ROW (
  X_ERROR out NOCOPY VARCHAR2,
  X_CALENDAR_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in OUT NOCOPY NUMBER,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_CALENDAR_TYPE in VARCHAR2,
  X_CALENDAR_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
		v_error CHAR := 'N';

Line: 389

      select count(*) into temp_count
      FROM jtf_calendars_vl
      WHERE upper(calendar_name) = upper(X_CALENDAR_NAME)
      AND UPPER(calendar_type) = upper(X_CALENDAR_TYPE)
      --- Added for bug 5123027 by abraina
          and (
               start_date_active <= nvl(X_END_DATE_ACTIVE,to_date('12/31/9999','mm/dd/yyyy'))
          and
               nvl(end_date_active,to_date('12/31/9999','mm/dd/yyyy')) >= X_START_DATE_ACTIVE
               )
      AND calendar_id <> X_CALENDAR_ID;

Line: 433

		  update JTF_CALENDARS_B set
		    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
		    START_DATE_ACTIVE = X_START_DATE_ACTIVE,
		    END_DATE_ACTIVE = X_END_DATE_ACTIVE,
		    ATTRIBUTE1 = X_ATTRIBUTE1,
		    ATTRIBUTE2 = X_ATTRIBUTE2,
		    ATTRIBUTE3 = X_ATTRIBUTE3,
		    ATTRIBUTE4 = X_ATTRIBUTE4,
		    ATTRIBUTE5 = X_ATTRIBUTE5,
		    ATTRIBUTE6 = X_ATTRIBUTE6,
		    ATTRIBUTE7 = X_ATTRIBUTE7,
		    ATTRIBUTE8 = X_ATTRIBUTE8,
		    ATTRIBUTE9 = X_ATTRIBUTE9,
		    ATTRIBUTE10 = X_ATTRIBUTE10,
		    ATTRIBUTE11 = X_ATTRIBUTE11,
		    ATTRIBUTE12 = X_ATTRIBUTE12,
		    ATTRIBUTE13 = X_ATTRIBUTE13,
		    ATTRIBUTE14 = X_ATTRIBUTE14,
		    ATTRIBUTE15 = X_ATTRIBUTE15,
		    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
		    CALENDAR_TYPE = X_CALENDAR_TYPE,
		    LAST_UPDATE_DATE = sysdate,
		    LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
		    LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
		  where CALENDAR_ID = X_CALENDAR_ID;

Line: 463

		  update JTF_CALENDARS_TL set
		    CALENDAR_NAME = X_CALENDAR_NAME,
		    DESCRIPTION = X_DESCRIPTION,
		    LAST_UPDATE_DATE = sysdate,
		    LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
		    LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
		    SOURCE_LANG = userenv('LANG')
		  where CALENDAR_ID = X_CALENDAR_ID
		  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 477

end UPDATE_ROW;

Line: 483

 X_LAST_UPDATE_DATE in date,
 X_LAST_UPDATED_BY in number,
 X_LAST_UPDATE_LOGIN in number)
is
begin

Update JTF_CALENDARS_TL set
calendar_name		= nvl(X_CALENDAR_NAME,calendar_name),
description		= nvl(X_DESCRIPTION,description),
last_update_date	= nvl(x_last_update_date,sysdate),
last_updated_by		= x_last_updated_by,
last_update_login	= 0,
source_lang		= userenv('LANG')
where calendar_id		= X_CALENDAR_ID
and userenv('LANG') in (LANGUAGE,SOURCE_LANG);

Line: 501

procedure DELETE_ROW (
  X_CALENDAR_ID in NUMBER
) is
begin
  delete from JTF_CALENDARS_TL
  where CALENDAR_ID = X_CALENDAR_ID;

Line: 512

  delete from JTF_CALENDARS_B
  where CALENDAR_ID = X_CALENDAR_ID;

Line: 518

end DELETE_ROW;

Line: 523

  delete from JTF_CALENDARS_TL T
  where not exists
    (select NULL
    from JTF_CALENDARS_B B
    where B.CALENDAR_ID = T.CALENDAR_ID
    );

Line: 530

  update JTF_CALENDARS_TL T set (
      CALENDAR_NAME,
      DESCRIPTION
    ) = (select
      B.CALENDAR_NAME,
      B.DESCRIPTION
    from JTF_CALENDARS_TL B
    where B.CALENDAR_ID = T.CALENDAR_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.CALENDAR_ID,
      T.LANGUAGE
  ) in (select
      SUBT.CALENDAR_ID,
      SUBT.LANGUAGE
    from JTF_CALENDARS_TL SUBB, JTF_CALENDARS_TL SUBT
    where SUBB.CALENDAR_ID = SUBT.CALENDAR_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.CALENDAR_NAME <> SUBT.CALENDAR_NAME
      or (SUBB.CALENDAR_NAME is null and SUBT.CALENDAR_NAME is not null)
      or (SUBB.CALENDAR_NAME is not null and SUBT.CALENDAR_NAME is null)
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
  ));

Line: 556

  insert into JTF_CALENDARS_TL (
    CALENDAR_ID,
    CALENDAR_NAME,
    DESCRIPTION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.CALENDAR_ID,
    B.CALENDAR_NAME,
    B.DESCRIPTION,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from JTF_CALENDARS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from JTF_CALENDARS_TL T
    where T.CALENDAR_ID = B.CALENDAR_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 606

	procedure UPDATE_TASK(task_id IN NUMBER, task_name IN CHAR, description IN CHAR, priority IN NUMBER, planned_start_date IN DATE,
				planned_end_date IN DATE, task_status_id IN NUMBER) IS
		l_rs varchar2(1) ;

Line: 617

		select jtf_tasks_b.object_version_number
		into x
		from jtf_tasks_b
		where task_id = v_task_id;

Line: 622

		jtf_tasks_pub.update_task(
				P_API_VERSION  		=> 1.0 ,
				P_INIT_MSG_LIST 	=> fnd_api.g_false ,
				P_COMMIT   		=> fnd_api.g_false ,
				P_TASK_ID   		=> v_task_id ,
				P_TASK_NAME   		=> task_name  ,
				P_TASK_STATUS_ID	=> task_status_id,
				P_DESCRIPTION		=> 'Hard Coded',
				P_TASK_PRIORITY_ID	=> priority,
				p_object_version_number => x ,
				p_planned_start_date 	=> planned_start_date ,
				p_planned_end_date 	=> planned_end_date ,
				p_bound_mode_code 	=> 'y',
				X_RETURN_STATUS   	=> l_rs,
				X_MSG_COUNT   		=> l_msg_count,
				X_MSG_DATA   		=> l_msg_data);

Line: 640

			select	task_assignment_id
			into	v_task_assignment_id
			from 	jtf_task_assignments
			where	task_id = v_task_id;

Line: 645

			select 	object_version_number
			into 	x
			from	jtf_task_assignments
			where 	task_assignment_id = v_task_assignment_id;

Line: 650

		jtf_task_assignments_pub.update_task_assignment(
				P_API_VERSION           => 1 ,
				p_init_msg_list 	=>  fnd_api.g_true ,
				p_commit 		=>  fnd_api.g_true ,
				p_task_assignment_id 	=> v_task_assignment_id,
				p_object_version_number => x ,
				P_ACTUAL_EFFORT 	=> NULL,
				P_ACTUAL_EFFORT_UOM 	=> NULL,
				P_ALARM_TYPE_CODE 	=> NULL ,
				P_ALARM_CONTACT 	=> NULL ,
				P_SCHED_TRAVEL_DURATION => NULL,
				P_SCHED_TRAVEL_DURATION_UOM => NULL ,
				p_shift_construct_id 	=> null ,
				P_ASSIGNMENT_STATUS_ID 	=>	task_status_id,
				X_RETURN_STATUS   	=>   l_rs ,
				X_MSG_COUNT   		=>  l_msg_count ,
				X_MSG_DATA   		=>   l_msg_data  ) ;