APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_FORM_QUERY

Line 514: INSERT INTO msc_form_query

510: l_bkt_start_date := NULL;
511: l_bkt_end_date := NULL;
512: END IF;
513:
514: INSERT INTO msc_form_query
515: (query_id, last_update_date, last_updated_by,creation_date, created_by,
516: NUMBER1,NUMBER2,NUMBER3,
517: NUMBER4,NUMBER5,CHAR1,
518: DATE1,DATE2,DATE3,

Line 2446: SELECT msc_form_query_s.nextval

2442:
2443: -- Get default category set
2444: l_default_category_set_id := get_cat_set_id(p_plan_id);
2445:
2446: SELECT msc_form_query_s.nextval
2447: INTO p_query_id
2448: FROM dual;
2449:
2450: IF org_id IS NOT NULL THEN

Line 2474: INSERT INTO msc_form_query

2470: END IF;
2471:
2472: IF p_period_type = CALENDAR_TYPE_MFG THEN
2473:
2474: INSERT INTO msc_form_query
2475: (
2476: query_id,
2477: NUMBER1, -- PLAN_ID
2478: CREATED_BY, -- RECORD_TYPE

Line 2580: INSERT INTO msc_form_query

2576: );
2577:
2578: ELSIF p_period_type = CALENDAR_TYPE_BIS THEN
2579:
2580: INSERT INTO msc_form_query
2581: (
2582: query_id,
2583: NUMBER1, -- PLAN_ID
2584: CREATED_BY, -- RECORD_TYPE

Line 2691: SELECT msc_form_query_s.nextval

2687: l_planlist PlanList;
2688: l_index BINARY_INTEGER;
2689: BEGIN
2690:
2691: SELECT msc_form_query_s.nextval
2692: INTO query_id
2693: FROM dual;
2694:
2695: IF org_id IS NOT NULL THEN

Line 2744: SELECT msc_form_query_s.nextval

2740:
2741: -- Get default category set
2742: l_default_category_set_id := get_cat_set_id(plan_id);
2743:
2744: SELECT msc_form_query_s.nextval
2745: INTO p_query_id
2746: FROM dual;
2747:
2748: IF org_id IS NOT NULL THEN

Line 2780: INSERT INTO msc_form_query

2776: l_sr_instance_id, l_sr_tp_id,
2777: l_sr_cat_instance_id, l_sr_cat_id, p_item_id, customer_id, customer_class_code,p_abc_id,p_query_Id);
2778: ELSIF p_period_type = CALENDAR_TYPE_BIS THEN
2779: -- BIS implies Inventory Budget report: No items, no customer/customer class
2780: INSERT INTO msc_form_query
2781: (
2782: query_id,
2783: NUMBER1, -- PLAN_ID
2784: CREATED_BY, -- RECORD_TYPE