APPS.GL_PERIODS_PKG dependencies on GL_PERIOD_STATUSES

Line 381: FROM gl_period_statuses ps,

377: -- Check for use with actuals
378: DECLARE
379: CURSOR chk_actual IS
380: SELECT 'Opened'
381: FROM gl_period_statuses ps,
382: gl_ledgers led
383: WHERE ps.application_id IN (101, 275, 283)
384: AND ps.period_name = check_period_used.period_name
385: AND ps.closing_status <> 'N'

Line 853: -- Insert rows in gl_period_statuses for this period

849: RAISE NO_DATA_FOUND;
850: end if;
851: CLOSE C;
852:
853: -- Insert rows in gl_period_statuses for this period
854: gl_period_statuses_pkg.insert_period(
855: X_period_set_name,
856: X_period_name,
857: X_start_date,

Line 854: gl_period_statuses_pkg.insert_period(

850: end if;
851: CLOSE C;
852:
853: -- Insert rows in gl_period_statuses for this period
854: gl_period_statuses_pkg.insert_period(
855: X_period_set_name,
856: X_period_name,
857: X_start_date,
858: X_end_date,

Line 1135: -- Update any rows in gl_period_statuses for this period

1131: if (SQL%NOTFOUND) then
1132: RAISE NO_DATA_FOUND;
1133: end if;
1134:
1135: -- Update any rows in gl_period_statuses for this period
1136: gl_period_statuses_pkg.update_period(
1137: X_period_set_name,
1138: X_period_name_old,
1139: X_period_name,

Line 1136: gl_period_statuses_pkg.update_period(

1132: RAISE NO_DATA_FOUND;
1133: end if;
1134:
1135: -- Update any rows in gl_period_statuses for this period
1136: gl_period_statuses_pkg.update_period(
1137: X_period_set_name,
1138: X_period_name_old,
1139: X_period_name,
1140: X_start_date,

Line 1235: -- Delete any rows in gl_period_statuses

1231: if (SQL%NOTFOUND) then
1232: RAISE NO_DATA_FOUND;
1233: end if;
1234:
1235: -- Delete any rows in gl_period_statuses
1236: -- associated with this period
1237: gl_period_statuses_pkg.delete_period(
1238: X_period_set_name,
1239: X_period_name_old);

Line 1237: gl_period_statuses_pkg.delete_period(

1233: end if;
1234:
1235: -- Delete any rows in gl_period_statuses
1236: -- associated with this period
1237: gl_period_statuses_pkg.delete_period(
1238: X_period_set_name,
1239: X_period_name_old);
1240:
1241:

Line 1282: -- Maintain quarter_start_date in GL_PERIODS and GL_PERIOD_STATUSES tables

1278: --x_quarter_start_date DATE;
1279:
1280: BEGIN
1281:
1282: -- Maintain quarter_start_date in GL_PERIODS and GL_PERIOD_STATUSES tables
1283: -- in Insert_row call to this procedure should be put before actual insert in the tables
1284: -- in Delete_Row call to this procedure should be put after actual update/delete
1285:
1286: -- For quarter_start_date get existing_quarter_start_date:

Line 1316: UPDATE gl_period_statuses

1312: AND quarter_num = x_quarter_num
1313: AND period_type = x_period_type
1314: AND period_year = x_period_year;
1315:
1316: UPDATE gl_period_statuses
1317: SET quarter_start_date = x_quarter_start_date
1318: WHERE
1319: quarter_num = x_quarter_num
1320: AND period_type = x_period_type

Line 1344: --Maintain year_start_date in GL_PERIODS and GL_PERIOD_STATUSES tables

1340: --x_year_start_date DATE;
1341:
1342: BEGIN
1343:
1344: --Maintain year_start_date in GL_PERIODS and GL_PERIOD_STATUSES tables
1345:
1346: -- For year_start_date get existing_year_start_date:
1347: SELECT min(start_date)
1348: INTO existing_year_start_date

Line 1373: UPDATE gl_period_statuses

1369: period_set_name = x_period_set_name
1370: AND period_type = x_period_type
1371: AND period_year = x_period_year;
1372:
1373: UPDATE gl_period_statuses
1374: SET year_start_date = x_year_start_date
1375: WHERE
1376: period_type = x_period_type
1377: AND period_year = x_period_year

Line 1485: -- and year_start_date columns in the GL_PERIODS and GL_PERIOD_STATUSES

1481: x_LAST_UPDATE_LOGIN
1482: );
1483:
1484: -- the following is logic for maintaining the quarter_start_date
1485: -- and year_start_date columns in the GL_PERIODS and GL_PERIOD_STATUSES
1486: -- IF the year has changed:
1487: -- do 1.(maintain_year_start_date) and
1488: -- 2.(maintain_quarter_start_date) for:
1489: -- new year