APPS.FNDCP_SCH dependencies on FND_CONC_RELEASE_PERIODS

Line 202: FROM fnd_conc_release_periods

198:
199: BEGIN
200: SELECT Concurrent_Period_id
201: INTO period_id
202: FROM fnd_conc_release_periods
203: WHERE application_id = period_application_id
204: AND period_name = Concurrent_Period_name;
205:
206: RETURN period_id;

Line 1287: from fnd_conc_release_periods

1283: appl_id := application_id_f(Application);
1284:
1285: select 'Y'
1286: into dummy
1287: from fnd_conc_release_periods
1288: where application_id = appl_id
1289: and Concurrent_period_name = Period_Name
1290: and rownum = 1;
1291:

Line 1371: select fnd_conc_release_periods_s.nextval

1367: end if;
1368: end if;
1369:
1370: /* Get new ID */
1371: select fnd_conc_release_periods_s.nextval
1372: into obj_id
1373: from sys.dual;
1374:
1375: appl_id := application_id_f(application);

Line 1378: insert into fnd_conc_release_periods

1374:
1375: appl_id := application_id_f(application);
1376:
1377: /* Do the insert */
1378: insert into fnd_conc_release_periods
1379: (application_id, concurrent_period_id,
1380: concurrent_period_name, enabled_flag, Periodicity_code,
1381: Period_Length, Period_Start_time, Period_Stop_time,
1382: last_update_date, last_updated_by, last_update_login,

Line 1393: insert into fnd_conc_release_periods_tl

1389:
1390:
1391: -- insert rows for each installed language into the tl table
1392: for lang_rec in lang_cur loop
1393: insert into fnd_conc_release_periods_tl
1394: (application_id, concurrent_period_id, language,
1395: creation_date, created_by,
1396: last_update_date, last_updated_by, last_update_login,
1397: description, user_concurrent_period_name, source_lang)