APPS.MSC_NETCHANGE_PKG dependencies on MSC_NEC_COMPARE_PLANS

Line 1824: from msc_nec_compare_plans

1820: cursor compare_exist is
1821: select compare_completion_date,
1822: compare_start_date,
1823: report_id
1824: from msc_nec_compare_plans
1825: where ((from_plan = p_from_plan and to_plan = p_to_plan) or
1826: (from_plan = p_to_plan and to_plan = p_from_plan));
1827:
1828: CURSOR exc_c(p_plan_id number) is

Line 1916: select msc_nec_compare_plans_s.nextval

1912: g_from_plan := p_from_plan;
1913: g_to_plan := p_to_plan;
1914: checkPlanStatus(p_from_plan, p_to_plan,p_plan_status,p_report_id);
1915: if p_plan_status = NOT_COMPARED then
1916: select msc_nec_compare_plans_s.nextval
1917: into p_report_id
1918: from dual;
1919:
1920: insert into msc_nec_compare_plans

Line 1920: insert into msc_nec_compare_plans

1916: select msc_nec_compare_plans_s.nextval
1917: into p_report_id
1918: from dual;
1919:
1920: insert into msc_nec_compare_plans
1921: (report_id,
1922: from_plan,
1923: to_plan,
1924: compare_start_date,

Line 1949: update msc_nec_compare_plans

1945: FND_FILE.PUT_LINE(FND_FILE.LOG,
1946: 'No need to recompare plans.');
1947: return;
1948: elsif p_plan_status = NEED_RECOMPARE then
1949: update msc_nec_compare_plans
1950: set compare_completion_date = to_date(null),
1951: compare_start_date = sysdate
1952: where report_id = p_report_id;
1953: commit;

Line 2043: update msc_nec_compare_plans

2039: trunc(sysdate),
2040: -1,
2041: -1 ;
2042:
2043: update msc_nec_compare_plans
2044: set compare_completion_date = sysdate
2045: where report_id = p_report_id;
2046:
2047: commit;

Line 2252: from msc_nec_compare_plans

2248: v_report_id number_arr;
2249: begin
2250: select report_id
2251: bulk collect into v_report_id
2252: from msc_nec_compare_plans
2253: where from_plan = p_plan_id or
2254: to_plan = p_plan_id
2255: for update of compare_completion_date nowait;
2256:

Line 2258: update msc_nec_compare_plans

2254: to_plan = p_plan_id
2255: for update of compare_completion_date nowait;
2256:
2257: forall a in 1..v_report_id.count
2258: update msc_nec_compare_plans
2259: set compare_completion_date = to_date(null),
2260: compare_start_date = to_date(null)
2261: where report_id = v_report_id(a);
2262:

Line 2267: MSC_UTIL.msc_debug('can not lock msc_nec_compare_plans table for update');

2263: commit;
2264: exception when no_data_found then
2265: null;
2266: when app_exception.record_lock_exception then
2267: MSC_UTIL.msc_debug('can not lock msc_nec_compare_plans table for update');
2268: END compare_plan_need_refresh;
2269:
2270: Function category_name(p_org_id number, p_instance_id number,
2271: p_item_id number,

Line 2314: from msc_nec_compare_plans

2310: p_plan_id IN NUMBER) is
2311:
2312: cursor compare_c is
2313: select report_id
2314: from msc_nec_compare_plans
2315: where from_plan = p_plan_id or
2316: to_plan = p_plan_id;
2317: p_report_id number;
2318: begin

Line 2326: delete msc_nec_compare_plans

2322: loop
2323: fetch compare_c INTO p_report_id;
2324: exit when compare_c%NOTFOUND;
2325:
2326: delete msc_nec_compare_plans
2327: where report_id = p_report_id;
2328:
2329: delete msc_nec_exc_dtl_compare
2330: where report_id = p_report_id;