APPS.FNDCP_SCH dependencies on FND_CONC_STATE_LOOKUP_TYPES

Line 249: FROM FND_CONC_STATE_LOOKUP_TYPES

245:
246: BEGIN
247: SELECT LOOKUP_TYPE_ID
248: INTO val_set_id
249: FROM FND_CONC_STATE_LOOKUP_TYPES
250: WHERE val_set_name = LOOKUP_TYPE_NAME;
251:
252: RETURN val_set_id;
253:

Line 1458: select FND_CONC_STATE_LOOKUP_TYPES_S.nextval

1454: end if;
1455: end if;
1456:
1457: /* Get new ID */
1458: select FND_CONC_STATE_LOOKUP_TYPES_S.nextval
1459: into obj_id
1460: from sys.dual;
1461:
1462: /* Do the insert */

Line 1463: insert into FND_CONC_STATE_LOOKUP_TYPES

1459: into obj_id
1460: from sys.dual;
1461:
1462: /* Do the insert */
1463: insert into FND_CONC_STATE_LOOKUP_TYPES
1464: (LOOKUP_TYPE_ID, LOOKUP_TYPE_NAME, enabled_flag,
1465: last_update_date, last_updated_by, last_update_login,
1466: creation_date, created_by)
1467: values

Line 1474: insert into FND_CONC_STATE_LOOKUP_TYPES_TL

1470: creation_date, created_by);
1471:
1472: -- insert rows for each installed language into the tl table
1473: for lang_rec in lang_cur loop
1474: insert into FND_CONC_STATE_LOOKUP_TYPES_TL
1475: (LOOKUP_TYPE_ID, language,
1476: creation_date, created_by,
1477: last_update_date, last_updated_by, last_update_login,
1478: description, USER_LOOKUP_TYPE_NAME, source_lang)

Line 1585: from fnd_conc_state_lookup_types

1581: message_init;
1582:
1583: select 'Y'
1584: into dummy
1585: from fnd_conc_state_lookup_types
1586: where LOOKUP_TYPE_NAME= Set_Name
1587: and rownum = 1;
1588:
1589: return TRUE;