APPS.GMD_VARIANT_TIME_POINT_GRP dependencies on GMD_SS_TIME_POINTS

Line 296: insert into gmd_ss_time_points

292: l_test_interval_plan_id := p_test_interval_plan_id;
293: end if;
294:
295: for l_time_interval_plan in c_time_interval_plan(l_test_interval_plan_id) loop
296: insert into gmd_ss_time_points
297: (
298: time_point_id,
299: name,
300: variant_id,

Line 379: SELECT time_point_id from gmd_ss_time_points

375: where material_source_id = p_material_source_id
376: for update of variant_id NOWAIT;
377:
378: CURSOR cr_time_points IS
379: SELECT time_point_id from gmd_ss_time_points
380: where variant_id in (select variant_id
381: from gmd_ss_variants
382: where material_source_id = p_material_source_id)
383: for update of time_point_id NOWAIT ;

Line 406: delete gmd_ss_time_points

402:
403: OPEN cr_time_points ;
404: CLOSE cr_time_points ;
405:
406: delete gmd_ss_time_points
407: where variant_id in (select variant_id
408: from gmd_ss_variants
409: where material_source_id = p_material_source_id);
410: delete gmd_ss_variants

Line 448: SELECT time_point_id from gmd_ss_time_points

444: -- mahesh.
445:
446:
447: CURSOR cr_time_points IS
448: SELECT time_point_id from gmd_ss_time_points
449: where variant_id = p_variant_id
450: for update of time_point_id NOWAIT ;
451:
452: record_lock EXCEPTION ;

Line 468: delete gmd_ss_time_points

464:
465: OPEN cr_time_points ;
466: CLOSE cr_time_points ;
467:
468: delete gmd_ss_time_points
469: where variant_id = p_variant_id;
470:
471:
472:

Line 534: SELECT spec_id from gmd_ss_time_points

530: where ss_id = p_ss_id
531: for update of default_spec_id NOWAIT;
532:
533: CURSOR cr_time_points IS
534: SELECT spec_id from gmd_ss_time_points
535: where variant_id in (select variant_id
536: from gmd_ss_variants
537: where ss_id = p_ss_id)
538: for update of spec_id NOWAIT ;

Line 564: UPDATE gmd_ss_time_points

560: UPDATE gmd_ss_variants
561: SET default_spec_id = p_base_spec_id
562: WHERE ss_id = p_ss_id ;
563:
564: UPDATE gmd_ss_time_points
565: SET spec_id = p_base_spec_id
566: WHERE variant_id in (select variant_id from gmd_ss_variants
567: where ss_id = p_ss_id) ;
568:

Line 599: SELECT spec_id from gmd_ss_time_points

595: where ss_id = p_ss_id
596: for update of scheduled_start_date NOWAIT;
597:
598: CURSOR cr_time_points IS
599: SELECT spec_id from gmd_ss_time_points
600: where variant_id in (select variant_id
601: from gmd_ss_variants
602: where ss_id = p_ss_id)
603: for update of spec_id NOWAIT ;

Line 630: UPDATE gmd_ss_time_points

626: UPDATE gmd_ss_variants
627: SET scheduled_start_date = p_scheduled_start_date
628: WHERE ss_id = p_ss_id ;
629:
630: UPDATE gmd_ss_time_points
631: SET scheduled_date = ADD_MONTHS(p_scheduled_start_date,((nvl(years_from_start,0) * 12 ) + nvl(months_from_start,0))) +
632: ((nvl(weeks_from_start,0) * 7 ) + nvl(days_from_start,0) + (nvl(hours_from_start,0)/24))
633: WHERE variant_id in (select variant_id from gmd_ss_variants
634: where ss_id = p_ss_id) ;