APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_FORM_QUERY

Line 500: INSERT INTO msc_form_query

496: l_bkt_start_date := NULL;
497: l_bkt_end_date := NULL;
498: END IF;
499:
500: INSERT INTO msc_form_query
501: (query_id, last_update_date, last_updated_by,creation_date, created_by,
502: NUMBER1,NUMBER2,NUMBER3,
503: NUMBER4,NUMBER5,CHAR1,
504: DATE1,DATE2,DATE3,

Line 2031: SELECT msc_form_query_s.nextval

2027:
2028: -- Get default category set
2029: l_default_category_set_id := get_cat_set_id(p_plan_id);
2030:
2031: SELECT msc_form_query_s.nextval
2032: INTO p_query_id
2033: FROM dual;
2034:
2035: IF org_id IS NOT NULL THEN

Line 2059: INSERT INTO msc_form_query

2055: END IF;
2056:
2057: IF p_period_type = CALENDAR_TYPE_MFG THEN
2058:
2059: INSERT INTO msc_form_query
2060: (
2061: query_id,
2062: NUMBER1, -- PLAN_ID
2063: CREATED_BY, -- RECORD_TYPE

Line 2165: INSERT INTO msc_form_query

2161: );
2162:
2163: ELSIF p_period_type = CALENDAR_TYPE_BIS THEN
2164:
2165: INSERT INTO msc_form_query
2166: (
2167: query_id,
2168: NUMBER1, -- PLAN_ID
2169: CREATED_BY, -- RECORD_TYPE

Line 2276: SELECT msc_form_query_s.nextval

2272: l_planlist PlanList;
2273: l_index BINARY_INTEGER;
2274: BEGIN
2275:
2276: SELECT msc_form_query_s.nextval
2277: INTO query_id
2278: FROM dual;
2279:
2280: IF org_id IS NOT NULL THEN

Line 2329: SELECT msc_form_query_s.nextval

2325:
2326: -- Get default category set
2327: l_default_category_set_id := get_cat_set_id(plan_id);
2328:
2329: SELECT msc_form_query_s.nextval
2330: INTO p_query_id
2331: FROM dual;
2332:
2333: IF org_id IS NOT NULL THEN

Line 2365: INSERT INTO msc_form_query

2361: l_sr_instance_id, l_sr_tp_id,
2362: l_sr_cat_instance_id, l_sr_cat_id, p_item_id, customer_id, customer_class_code,p_abc_id,p_query_Id);
2363: ELSIF p_period_type = CALENDAR_TYPE_BIS THEN
2364: -- BIS implies Inventory Budget report: No items, no customer/customer class
2365: INSERT INTO msc_form_query
2366: (
2367: query_id,
2368: NUMBER1, -- PLAN_ID
2369: CREATED_BY, -- RECORD_TYPE