APPS.FNDCP_SCH dependencies on FND_CONC_RELEASE_STATES

Line 226: FROM fnd_conc_release_states

222:
223: BEGIN
224: SELECT concurrent_state_id
225: INTO state_id
226: FROM fnd_conc_release_states
227: WHERE application_id = state_application_id
228: AND state_name = Concurrent_state_name;
229:
230: RETURN state_id;

Line 343: update FND_CONC_RELEASE_STATES

339: my_creation_date date := creation_date_f;
340: my_created_by number := created_by_f;
341:
342: Begin
343: update FND_CONC_RELEASE_STATES
344: SET STATUS = 1,
345: LAST_UPDATE_DATE = my_last_update_date,
346: last_updated_by = my_last_updated_by,
347: last_update_login = my_last_update_login,

Line 1039: from fnd_CONC_RELEASE_STATES

1035: d_id := Disj_id_f(d_app_id,Disj_Name);
1036:
1037: SELECT lookup_type_id
1038: into t_id
1039: from fnd_CONC_RELEASE_STATES
1040: where CONCURRENT_STATE_ID = s_id
1041: and application_id = s_app_id;
1042:
1043: v_id := Val_id_f(null,State_Value,t_id);

Line 1700: select fnd_conc_release_states_s.nextval

1696: end if;
1697: end if;
1698:
1699: /* Get new ID */
1700: select fnd_conc_release_states_s.nextval
1701: into obj_id
1702: from sys.dual;
1703:
1704: appl_id := application_id_f(application);

Line 1707: insert into fnd_conc_release_states

1703:
1704: appl_id := application_id_f(application);
1705:
1706: /* Do the insert */
1707: insert into fnd_conc_release_states
1708: (application_id, concurrent_state_id,
1709: concurrent_state_name, enabled_flag, LOOKUP_TYPE_ID, STATUS,
1710: last_update_date, last_updated_by, last_update_login,
1711: creation_date, created_by, updated_flag)

Line 1720: insert into fnd_conc_release_states_tl

1716:
1717:
1718: -- insert rows for each installed language into the tl table
1719: for lang_rec in lang_cur loop
1720: insert into fnd_conc_release_states_tl
1721: (application_id, concurrent_state_id, language,
1722: creation_date, created_by,
1723: last_update_date, last_updated_by, last_update_login,
1724: description, USER_CONCURRENT_STATE_NAME, source_lang)

Line 1755: from fnd_conc_release_States

1751: appl_id := application_id_f(Application);
1752:
1753: select 'Y'
1754: into dummy
1755: from fnd_conc_release_States
1756: where application_id = appl_id
1757: and Concurrent_state_name = state_Name
1758: and rownum = 1;
1759: