1332: -- API Body Begin
1333: -- Check for the open periods
1334: SELECT count(1)
1335: INTO l_period_count
1336: FROM cn_acc_period_statuses_v
1337: WHERE trunc(p_newtx_rec.processed_date)
1338: BETWEEN start_date AND end_date
1339: AND period_status IN ('O','F')
1340: AND org_id = p_newtx_rec.org_id;
1350: --
1351: BEGIN
1352: SELECT period_id
1353: INTO l_processed_period_id
1354: FROM cn_acc_period_statuses_v
1355: WHERE trunc(p_newtx_rec.processed_date)
1356: BETWEEN start_date AND end_date
1357: AND period_status IN ('O','F')
1358: AND org_id = p_newtx_rec.org_id;