APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on CN_PERIOD_STATUSES

Line 291: l_period_name cn_period_statuses.period_name%TYPE;

287: l_liab_account_id NUMBER;
288: l_expense_account_id NUMBER;
289: l_ee_piped_sql_from CLOB;
290:
291: l_period_name cn_period_statuses.period_name%TYPE;
292: l_period_exist_count NUMBER;
293: l_period_end_date DATE;
294: l_exp_name_source cn_calc_sql_exps.name%TYPE;
295: l_period_id cn_period_statuses.period_id%TYPE;

Line 295: l_period_id cn_period_statuses.period_id%TYPE;

291: l_period_name cn_period_statuses.period_name%TYPE;
292: l_period_exist_count NUMBER;
293: l_period_end_date DATE;
294: l_exp_name_source cn_calc_sql_exps.name%TYPE;
295: l_period_id cn_period_statuses.period_id%TYPE;
296: --defined by Naren to fix bug 13606519
297:
298: l_quota_count NUMBER:=0;
299:

Line 2348: select COUNT(period_id) into l_period_exist_count from cn_period_statuses where start_date <= p_start_date and end_date >= p_start_date AND org_id = p_org_id AND period_status='O';

2344: v_period_quotas_tbl.DELETE;
2345:
2346: IF p_start_date IS NOT NULL THEN
2347:
2348: select COUNT(period_id) into l_period_exist_count from cn_period_statuses where start_date <= p_start_date and end_date >= p_start_date AND org_id = p_org_id AND period_status='O';
2349:
2350: IF l_period_exist_count=0 THEN
2351:
2352: ROLLBACK TO Create_PlanElement;

Line 2361: select period_id into l_period_id from cn_period_statuses where start_date <= p_start_date and end_date >= p_start_date AND org_id = p_org_id;

2357: RAISE FND_API.G_EXC_ERROR;
2358:
2359: END IF; --end of l_period_exist_count
2360:
2361: select period_id into l_period_id from cn_period_statuses where start_date <= p_start_date and end_date >= p_start_date AND org_id = p_org_id;
2362:
2363: END IF;
2364:
2365: FOR i IN 0..v_node_sibling_length_Next-1 LOOP

Line 2405: FROM cn_period_statuses

2401:
2402:
2403: l_period_exist_count:=0;
2404: SELECT count(period_name) INTO l_period_exist_count
2405: FROM cn_period_statuses
2406: WHERE period_name = l_period_name
2407: AND org_id = p_org_id;
2408:
2409: IF l_period_exist_count <> 0 THEN

Line 2412: FROM cn_period_statuses

2408:
2409: IF l_period_exist_count <> 0 THEN
2410:
2411: SELECT end_date INTO l_period_end_date
2412: FROM cn_period_statuses
2413: WHERE period_name = l_period_name
2414: AND org_id = p_org_id;
2415:
2416: IF p_end_date IS NULL AND NVL(v_plan_element_rec.end_date,l_period_end_date) >= l_period_end_date THEN