APPS.FNDCP_SCH SQL Statements

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

Line: 67

FUNCTION last_updated_by_f RETURN NUMBER IS
BEGIN
   RETURN created_by_f;

Line: 72

FUNCTION last_update_date_f RETURN DATE IS
BEGIN
   RETURN creation_date_f;

Line: 77

FUNCTION last_update_login_f RETURN NUMBER IS
BEGIN
   return 0;

Line: 122

   SELECT application_id
     INTO application_id_ret
     FROM fnd_application
     WHERE application_short_name = application_name_in;

Line: 130

       SELECT application_id
         INTO application_id_ret
         FROM fnd_application_tl
        WHERE application_name = application_name_in
          AND rownum = 1;

Line: 153

  SELECT Release_Class_id
    INTO class_id
    FROM fnd_conc_release_classes
   WHERE application_id = class_application_id
     AND class_name = release_class_name;

Line: 177

  SELECT Disjunction_id
    INTO disj_id FROM fnd_conc_release_Disjs
   WHERE application_id = disj_application_id
     AND disj_name = Disjunction_name;

Line: 200

  SELECT Concurrent_Period_id
    INTO period_id
    FROM fnd_conc_release_periods
   WHERE application_id = period_application_id
     AND period_name = Concurrent_Period_name;

Line: 224

  SELECT concurrent_state_id
    INTO state_id
    FROM fnd_conc_release_states
   WHERE application_id = state_application_id
     AND state_name = Concurrent_state_name;

Line: 247

  SELECT LOOKUP_TYPE_ID
    INTO val_set_id
    FROM FND_CONC_STATE_LOOKUP_TYPES
   WHERE val_set_name = LOOKUP_TYPE_NAME;

Line: 278

  SELECT LOOKUP_VALUE
    INTO val_id
    FROM FND_CONC_STATE_LOOKUPS_TL L
    WHERE L.LOOKUP_TYPE_ID = set_id
         and L.MEANING = value_name
         and rownum = 1;

Line: 336

  my_last_update_login number := last_update_login_f;

Line: 337

  my_last_update_date date    := last_update_date_f;

Line: 338

  my_last_updated_by number   := last_updated_by_f;

Line: 343

  update FND_CONC_RELEASE_STATES
        SET STATUS = 1,
        LAST_UPDATE_DATE = my_last_update_date,
	last_updated_by = my_last_updated_by,
	last_update_login = my_last_update_login,
	creation_date = my_creation_date,
	created_by = my_created_by
        WHERE APPLICATION_ID = 0
        AND CONCURRENT_STATE_NAME = 'AFPSCHED_STATUS';

Line: 384

l_last_update_login number := last_update_login_f;

Line: 385

l_last_update_date date    := last_update_date_f;

Line: 386

l_last_updated_by number   := last_updated_by_f;

Line: 391

    SELECT language_code
      FROM fnd_languages
     WHERE installed_flag IN ('I', 'B');

Line: 410

  /* Do the update */
  update fnd_conc_release_classes c
            set c.enabled_flag  = 'Y',
                c.last_update_date  = l_last_update_date,
		c.last_updated_by   = l_last_updated_by,
		c.last_update_login = l_last_update_login
          where c.application_id = appl_id
	    and c.release_class_name = Class_Name;

Line: 435

l_last_update_login number := last_update_login_f;

Line: 436

l_last_update_date date    := last_update_date_f;

Line: 437

l_last_updated_by number   := last_updated_by_f;

Line: 442

    SELECT language_code
      FROM fnd_languages
     WHERE installed_flag IN ('I', 'B');

Line: 461

  /* Do the update */
 update fnd_conc_release_classes c
                set c.enabled_flag  = 'N',
                c.last_update_date  = l_last_update_date,
		c.last_updated_by   = l_last_updated_by,
		c.last_update_login = l_last_update_login
         where c.application_id = appl_id
		and c.release_class_name = Class_Name;

Line: 495

l_last_update_login number := last_update_login_f;

Line: 496

l_last_update_date date    := last_update_date_f;

Line: 497

l_last_updated_by number   := last_updated_by_f;

Line: 502

    SELECT language_code
      FROM fnd_languages
     WHERE installed_flag IN ('I', 'B');

Line: 549

  /* Do the update */
 update fnd_conc_release_classes c
                set RESUBMIT_INTERVAL= Resub_Interval,
		RESUBMIT_INTERVAL_UNIT_CODE = Resub_Int_Unit_Code,
                RESUBMIT_INTERVAL_TYPE_CODE = Resub_Int_Type_Code,
                c.last_update_date  = l_last_update_date,
                c.last_updated_by   = l_last_updated_by,
                c.last_update_login = l_last_update_login
         where c.application_id = appl_id
                and c.release_class_name = Class_Name;

Line: 586

last_update_login number := last_update_login_f;

Line: 587

last_update_date date    := last_update_date_f;

Line: 588

last_updated_by number   := last_updated_by_f;

Line: 595

    SELECT language_code
      FROM fnd_languages
     WHERE installed_flag IN ('I', 'B');

Line: 618

    select fnd_conc_release_classes_s.nextval
      into obj_id
      from sys.dual;

Line: 624

    /* Do the insert */
  insert into fnd_conc_release_classes
		(application_id, release_class_id, release_class_name,
		 enabled_flag, class_type,
                 last_update_date, last_updated_by, last_update_login,
                 creation_date, created_by, updated_flag)
	values
		(appl_id, obj_id,  Class_Name,
		 'Y', 'X',
		 last_update_date, last_updated_by, last_update_login,
		 creation_date, created_by, 'Y');

Line: 638

    insert into fnd_conc_release_classes_tl
                (application_id, release_class_id, language,
                 creation_date, created_by,
                 last_update_date, last_updated_by, last_update_login,
                 description, user_release_class_name, source_lang)
           values
                (appl_id, obj_id, lang_rec.language_code,
                 creation_date, created_by,
                 last_update_date, last_updated_by, last_update_login,
                 description, User_Class_Name, cur_lang);

Line: 672

  select 'Y'
  into dummy
  from fnd_conc_release_classes
  where application_id = appl_id
  and release_class_name = Class_Name
  and rownum = 1;

Line: 711

last_update_login number := last_update_login_f;

Line: 712

last_update_date date    := last_update_date_f;

Line: 713

last_updated_by number   := last_updated_by_f;

Line: 731

  insert into FND_CONC_REL_CONJ_MEMBERS
	(CLASS_APPLICATION_ID, RELEASE_CLASS_ID, DISJUNCTION_APPLICATION_ID,
	 DISJUNCTION_ID, created_by, last_update_login,
	 last_update_date, last_updated_by, creation_date)
	Values
	(c_app_id, c_id, d_app_id, d_id, created_by, last_update_login,
	 last_update_date, last_updated_by, creation_date);

Line: 739

  update FND_CONC_RELEASE_CLASSES
  set updated_flag = 'Y'
  where APPLICATION_ID = c_app_id
    and RELEASE_CLASS_ID = c_id;

Line: 792

  DELETE FROM FND_CONC_REL_CONJ_MEMBERS
  WHERE CLASS_APPLICATION_ID = c_app_id
    AND RELEASE_CLASS_ID = c_id
    AND DISJUNCTION_APPLICATION_ID = d_app_id
    AND DISJUNCTION_ID = d_id;

Line: 842

    select 'Y'
    into dummy
    from fnd_conc_rel_conj_members
    where CLASS_APPLICATION_ID = c_appl_id
      and RELEASE_CLASS_ID = c_id
      and DISJUNCTION_APPLICATION_ID = d_appl_id
      and DISJUNCTION_ID = d_id
      and rownum = 1;

Line: 882

last_update_login number := last_update_login_f;

Line: 883

last_update_date date    := last_update_date_f;

Line: 884

last_updated_by number   := last_updated_by_f;

Line: 891

    SELECT language_code
      FROM fnd_languages
     WHERE installed_flag IN ('I', 'B');

Line: 913

    select fnd_conc_release_disjs_s.nextval
      into obj_id
      from sys.dual;

Line: 919

    /* Do the insert */
  insert into fnd_conc_release_disjs
                (application_id, disjunction_id, disjunction_name,
                 enabled_flag,
                 last_update_date, last_updated_by, last_update_login,
                 creation_date, created_by, updated_flag)
        values
                (appl_id, obj_id,  Disj_Name,
                 'Y',
                 last_update_date, last_updated_by, last_update_login,
                 creation_date, created_by, 'Y');

Line: 934

    insert into fnd_conc_release_disjs_tl
                (application_id, disjunction_id, language,
                 creation_date, created_by,
                 last_update_date, last_updated_by, last_update_login,
                 description, user_disjunction_name, source_lang)
           values
                (appl_id, obj_id, lang_rec.language_code,
                 creation_date, created_by,
                 last_update_date, last_updated_by, last_update_login,
                 description, User_Disj_Name, cur_lang);

Line: 967

  select 'Y'
  into dummy
  from fnd_conc_release_Disjs
  where application_id = appl_id
  and Disjunction_name = Disj_Name
  and rownum = 1;

Line: 1017

last_update_login number := last_update_login_f;

Line: 1018

last_update_date date    := last_update_date_f;

Line: 1019

last_updated_by number   := last_updated_by_f;

Line: 1037

  SELECT lookup_type_id
  into t_id
  from fnd_CONC_RELEASE_STATES
  where CONCURRENT_STATE_ID = s_id
  and application_id = s_app_id;

Line: 1046

  insert into FND_CONC_REL_DISJ_MEMBERS
        (DISJUNCTION_APPLICATION_ID, DISJUNCTION_ID, STATE_APPLICATION_ID,
         STATE_ID, STATUS_VALUE, NEGATION_FLAG,
         PERIOD_OR_STATE_FLAG, created_by,
	 last_update_login, last_update_date, last_updated_by, creation_date)
        Values
        (d_app_id, d_id, s_app_id, s_id, v_id, Negation_Flag,
	 'S', created_by,
	 last_update_login, last_update_date, last_updated_by, creation_date);

Line: 1056

  update FND_CONC_RELEASE_DISJS
  set updated_flag = 'Y'
  where APPLICATION_ID = d_app_id
    and DISJUNCTION_ID = d_id;

Line: 1094

last_update_login number := last_update_login_f;

Line: 1095

last_update_date date    := last_update_date_f;

Line: 1096

last_updated_by number   := last_updated_by_f;

Line: 1114

  insert into FND_CONC_REL_DISJ_MEMBERS
        (DISJUNCTION_APPLICATION_ID, DISJUNCTION_ID, PERIOD_APPLICATION_ID,
         PERIOD_ID,PERIOD_OR_STATE_FLAG,NEGATION_FLAG,created_by,
	last_update_login, last_update_date, last_updated_by, creation_date)
        Values
        (d_app_id, d_id, p_app_id, p_id, 'P', Negation_Flag, created_by,
	 last_update_login, last_update_date, last_updated_by, creation_date);

Line: 1122

  update FND_CONC_RELEASE_DISJS
  set updated_flag = 'Y'
  where APPLICATION_ID = d_app_id
    and DISJUNCTION_ID = d_id;

Line: 1183

  DELETE FROM FND_CONC_REL_DISJ_MEMBERS
  WHERE DISJUNCTION_APPLICATION_ID = d_app_id
    AND DISJUNCTION_ID = d_id
    AND PERIOD_OR_STATE_FLAG = Member_Type
    AND DECODE(Member_Type, 'S', STATE_APPLICATION_ID,
				 PERIOD_APPLICATION_ID) = m_app_id
    AND DECODE(Member_Type, 'S', STATE_ID,
                                 PERIOD_ID) = m_id;

Line: 1246

    select 'Y'
    into dummy
    from fnd_conc_rel_disj_members
    where DISJUNCTION_APPLICATION_ID = d_app_id
      and DISJUNCTION_ID = d_id
      and PERIOD_OR_STATE_FLAG = Member_Type
      AND DECODE(Member_Type, 'S', STATE_APPLICATION_ID,
                                 PERIOD_APPLICATION_ID) = m_app_id
      AND DECODE(Member_Type, 'S', STATE_ID,
                                 PERIOD_ID) = m_id
      and rownum = 1;

Line: 1285

  select 'Y'
  into dummy
  from fnd_conc_release_periods
  where application_id = appl_id
  and Concurrent_period_name = Period_Name
  and rownum = 1;

Line: 1335

last_update_login number := last_update_login_f;

Line: 1336

last_update_date date    := last_update_date_f;

Line: 1337

last_updated_by number   := last_updated_by_f;

Line: 1344

    SELECT language_code
      FROM fnd_languages
     WHERE installed_flag IN ('I', 'B');

Line: 1371

    select fnd_conc_release_periods_s.nextval
      into obj_id
      from sys.dual;

Line: 1377

    /* Do the insert */
  insert into fnd_conc_release_periods
                (application_id, concurrent_period_id,
                 concurrent_period_name, enabled_flag, Periodicity_code,
                 Period_Length, Period_Start_time, Period_Stop_time,
                 last_update_date, last_updated_by, last_update_login,
                 creation_date, created_by, updated_flag)
        values
                (appl_id, obj_id,  Period_Name, 'Y', Period_Type,
		 Period_Length, Period_Start, Period_Stop,
                 last_update_date, last_updated_by, last_update_login,
                 creation_date, created_by, 'Y');

Line: 1393

    insert into fnd_conc_release_periods_tl
                (application_id, concurrent_period_id, language,
                 creation_date, created_by,
                 last_update_date, last_updated_by, last_update_login,
                 description, user_concurrent_period_name, source_lang)
           values
                (appl_id, obj_id, lang_rec.language_code,
                 creation_date, created_by,
                 last_update_date, last_updated_by, last_update_login,
                 description, User_period_Name, cur_lang);

Line: 1427

last_update_login number := last_update_login_f;

Line: 1428

last_update_date date    := last_update_date_f;

Line: 1429

last_updated_by number   := last_updated_by_f;

Line: 1436

    SELECT language_code
      FROM fnd_languages
     WHERE installed_flag IN ('I', 'B');

Line: 1458

    select FND_CONC_STATE_LOOKUP_TYPES_S.nextval
      into obj_id
      from sys.dual;

Line: 1462

    /* Do the insert */
  insert into FND_CONC_STATE_LOOKUP_TYPES
                (LOOKUP_TYPE_ID, LOOKUP_TYPE_NAME, enabled_flag,
                 last_update_date, last_updated_by, last_update_login,
                 creation_date, created_by)
        values
                (obj_id,  Set_Name, 'Y',
                 last_update_date, last_updated_by, last_update_login,
                 creation_date, created_by);

Line: 1474

    insert into FND_CONC_STATE_LOOKUP_TYPES_TL
                (LOOKUP_TYPE_ID, language,
                 creation_date, created_by,
                 last_update_date, last_updated_by, last_update_login,
                 description, USER_LOOKUP_TYPE_NAME, source_lang)
           values
                (obj_id, lang_rec.language_code,
                 creation_date, created_by,
                 last_update_date, last_updated_by, last_update_login,
                 description, User_set_Name, cur_lang);

Line: 1506

last_update_login number := last_update_login_f;

Line: 1507

last_update_date date    := last_update_date_f;

Line: 1508

last_updated_by number   := last_updated_by_f;

Line: 1515

    SELECT language_code
      FROM fnd_languages
     WHERE installed_flag IN ('I', 'B');

Line: 1539

    select FND_CONC_STATE_LOOKUPS_S.nextval
      into obj_id
      from sys.dual;

Line: 1543

    /* Do the insert */
  insert into FND_CONC_STATE_LOOKUPS
                (LOOKUP_TYPE_ID, LOOKUP_VALUE, enabled_flag,
                 last_update_date, last_updated_by, last_update_login,
                 creation_date, created_by)
        values
                (t_id,  obj_id, 'Y',
                 last_update_date, last_updated_by, last_update_login,
                 creation_date, created_by);

Line: 1555

    insert into FND_CONC_STATE_LOOKUPS_TL
                (LOOKUP_TYPE_ID, LOOKUP_VALUE, language, MEANING,
                 creation_date, created_by,
                 last_update_date, last_updated_by, last_update_login,
                 description, source_lang)
           values
                (t_id, obj_id, lang_rec.language_code, Value_Name,
                 creation_date, created_by,
                 last_update_date, last_updated_by, last_update_login,
                 description, cur_lang);

Line: 1583

  select 'Y'
  into dummy
  from fnd_conc_state_lookup_types
  where LOOKUP_TYPE_NAME= Set_Name
  and rownum = 1;

Line: 1617

  select 'Y'
  into dummy
  from fnd_conc_state_lookups_tl
  where meaning=Value_Name
  and LOOKUP_TYPE_ID = t_id
  and rownum = 1;

Line: 1663

last_update_login number := last_update_login_f;

Line: 1664

last_update_date date    := last_update_date_f;

Line: 1665

last_updated_by number   := last_updated_by_f;

Line: 1672

    SELECT language_code
      FROM fnd_languages
     WHERE installed_flag IN ('I', 'B');

Line: 1700

    select fnd_conc_release_states_s.nextval
      into obj_id
      from sys.dual;

Line: 1706

    /* Do the insert */
  insert into fnd_conc_release_states
                (application_id, concurrent_state_id,
                 concurrent_state_name, enabled_flag, LOOKUP_TYPE_ID, STATUS,
                 last_update_date, last_updated_by, last_update_login,
                 creation_date, created_by, updated_flag)
        values
                (appl_id, obj_id,  State_Name, 'Y', t_id, v_id,
                 last_update_date, last_updated_by, last_update_login,
                 creation_date, created_by, 'Y');

Line: 1720

    insert into fnd_conc_release_states_tl
                (application_id, concurrent_state_id, language,
                 creation_date, created_by,
                 last_update_date, last_updated_by, last_update_login,
                 description, USER_CONCURRENT_STATE_NAME, source_lang)
           values
                (appl_id, obj_id, lang_rec.language_code,
                 creation_date, created_by,
                 last_update_date, last_updated_by, last_update_login,
                 description, User_state_Name, cur_lang);

Line: 1753

  select 'Y'
  into dummy
  from fnd_conc_release_States
  where application_id = appl_id
  and Concurrent_state_name = state_Name
  and rownum = 1;