APPS.GMD_VARIANT_TIME_POINT_GRP dependencies on GMD_SS_TIME_POINTS

Line 289: insert into gmd_ss_time_points

285: l_test_interval_plan_id := p_test_interval_plan_id;
286: end if;
287:
288: for l_time_interval_plan in c_time_interval_plan(l_test_interval_plan_id) loop
289: insert into gmd_ss_time_points
290: (
291: time_point_id,
292: name,
293: variant_id,

Line 372: SELECT time_point_id from gmd_ss_time_points

368: where material_source_id = p_material_source_id
369: for update of variant_id NOWAIT;
370:
371: CURSOR cr_time_points IS
372: SELECT time_point_id from gmd_ss_time_points
373: where variant_id in (select variant_id
374: from gmd_ss_variants
375: where material_source_id = p_material_source_id)
376: for update of time_point_id NOWAIT ;

Line 399: delete gmd_ss_time_points

395:
396: OPEN cr_time_points ;
397: CLOSE cr_time_points ;
398:
399: delete gmd_ss_time_points
400: where variant_id in (select variant_id
401: from gmd_ss_variants
402: where material_source_id = p_material_source_id);
403: delete gmd_ss_variants

Line 441: SELECT time_point_id from gmd_ss_time_points

437: -- mahesh.
438:
439:
440: CURSOR cr_time_points IS
441: SELECT time_point_id from gmd_ss_time_points
442: where variant_id = p_variant_id
443: for update of time_point_id NOWAIT ;
444:
445: record_lock EXCEPTION ;

Line 461: delete gmd_ss_time_points

457:
458: OPEN cr_time_points ;
459: CLOSE cr_time_points ;
460:
461: delete gmd_ss_time_points
462: where variant_id = p_variant_id;
463:
464:
465:

Line 527: SELECT spec_id from gmd_ss_time_points

523: where ss_id = p_ss_id
524: for update of default_spec_id NOWAIT;
525:
526: CURSOR cr_time_points IS
527: SELECT spec_id from gmd_ss_time_points
528: where variant_id in (select variant_id
529: from gmd_ss_variants
530: where ss_id = p_ss_id)
531: for update of spec_id NOWAIT ;

Line 557: UPDATE gmd_ss_time_points

553: UPDATE gmd_ss_variants
554: SET default_spec_id = p_base_spec_id
555: WHERE ss_id = p_ss_id ;
556:
557: UPDATE gmd_ss_time_points
558: SET spec_id = p_base_spec_id
559: WHERE variant_id in (select variant_id from gmd_ss_variants
560: where ss_id = p_ss_id) ;
561:

Line 592: SELECT spec_id from gmd_ss_time_points

588: where ss_id = p_ss_id
589: for update of scheduled_start_date NOWAIT;
590:
591: CURSOR cr_time_points IS
592: SELECT spec_id from gmd_ss_time_points
593: where variant_id in (select variant_id
594: from gmd_ss_variants
595: where ss_id = p_ss_id)
596: for update of spec_id NOWAIT ;

Line 623: UPDATE gmd_ss_time_points

619: UPDATE gmd_ss_variants
620: SET scheduled_start_date = p_scheduled_start_date
621: WHERE ss_id = p_ss_id ;
622:
623: UPDATE gmd_ss_time_points
624: SET scheduled_date = ADD_MONTHS(p_scheduled_start_date,((nvl(years_from_start,0) * 12 ) + nvl(months_from_start,0))) +
625: ((nvl(weeks_from_start,0) * 7 ) + nvl(days_from_start,0) + (nvl(hours_from_start,0)/24))
626: WHERE variant_id in (select variant_id from gmd_ss_variants
627: where ss_id = p_ss_id) ;