eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_VARIANT_TIME_POINT_GRP dependencies on GMD_SS_VARIANTS

Line 88: from gmd_ss_variants a

84: from
85: (select count(*) cnt,
86: material_source_id,
87: storage_spec_id
88: from gmd_ss_variants a
89: where a.ss_id = p_stability_study
90: group by material_source_id, storage_spec_id);
91:
92: l_package_cnt := l_stab_study.packages_cnt - l_package_cnt;

Line 187: insert into gmd_ss_variants

183:
184: -- JD changed whse_code to storage_subinventory.
185: -- JD changed location to storage_locator_id.
186:
187: insert into gmd_ss_variants
188: (variant_id,
189: variant_no,
190: ss_id,
191: material_source_id,

Line 287: gmd_ss_variants b

283: if (p_test_interval_plan_id IS NULL) then
284: select a.test_interval_plan_id
285: into l_test_interval_plan_id
286: from gmd_storage_plan_details a,
287: gmd_ss_variants b
288: where a.storage_plan_detail_id = b.storage_plan_detail_id
289: and b.variant_id = p_variant_id
290: ;
291: else

Line 367: from gmd_ss_variants

363: (p_material_source_id IN NUMBER,
364: x_return_status OUT NOCOPY VARCHAR2) IS
365: Cursor c_ss_id is
366: select ss_id
367: from gmd_ss_variants
368: where material_source_id = p_material_source_id;
369: l_return_status VARCHAR2(1);
370: l_ss_id NUMBER;
371:

Line 374: SELECT variant_id from gmd_ss_variants

370: l_ss_id NUMBER;
371:
372: -- mahesh.
373: CURSOR cr_variants IS
374: SELECT variant_id from gmd_ss_variants
375: where material_source_id = p_material_source_id
376: for update of variant_id NOWAIT;
377:
378: CURSOR cr_time_points IS

Line 381: from gmd_ss_variants

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 ;
384:
385: record_lock EXCEPTION ;

Line 408: from gmd_ss_variants

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
411: where material_source_id = p_material_source_id;
412:

Line 410: delete gmd_ss_variants

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
411: where material_source_id = p_material_source_id;
412:
413: update_variant_seq(l_ss_id, l_return_status);
414:

Line 423: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');

419: END IF;
420: IF cr_time_points%ISOPEN THEN
421: CLOSE cr_time_points;
422: END IF;
423: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
424: x_return_status := FND_API.G_RET_STS_ERROR ;
425: WHEN OTHERS THEN
426: GMD_API_PUB.Log_Message('GMD_API_ERROR',
427: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.DELETE_VARIANTS',

Line 479: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');

475:
476: IF cr_time_points%ISOPEN THEN
477: CLOSE cr_time_points;
478: END IF;
479: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
480: x_return_status := FND_API.G_RET_STS_ERROR ;
481: WHEN OTHERS THEN
482: GMD_API_PUB.Log_Message('GMD_API_ERROR',
483: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.DELETE_TIME_POINTS',

Line 494: from gmd_ss_variants a

490: l_variant_num NUMBER;
491: begin
492: select nvl(max(a.variant_no),0)
493: into l_variant_num
494: from gmd_ss_variants a
495: where a.ss_id = p_ss_id
496: ;
497:
498: return l_variant_num;

Line 506: from gmd_ss_variants

502: (ss_id IN NUMBER,
503: x_return_status OUT NOCOPY VARCHAR2) is
504: cursor c_variant_no (p_ss_id NUMBER) is
505: select variant_id,variant_no, rownum
506: from gmd_ss_variants
507: where ss_id = p_ss_id
508: order by variant_no;
509: begin
510: for l_variant_no in c_variant_no(ss_id) loop

Line 511: update gmd_ss_variants

507: where ss_id = p_ss_id
508: order by variant_no;
509: begin
510: for l_variant_no in c_variant_no(ss_id) loop
511: update gmd_ss_variants
512: set variant_no = l_variant_no.rownum
513: where variant_id = l_variant_no.variant_id;
514: end loop;
515: EXCEPTION

Line 529: SELECT default_spec_id from gmd_ss_variants

525: p_base_spec_id IN NUMBER,
526: x_return_status OUT NOCOPY VARCHAR2 ) IS
527: -- mahesh.
528: CURSOR cr_variants IS
529: SELECT default_spec_id from gmd_ss_variants
530: where ss_id = p_ss_id
531: for update of default_spec_id NOWAIT;
532:
533: CURSOR cr_time_points IS

Line 536: from gmd_ss_variants

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 ;
539:
540: record_lock EXCEPTION ;

Line 560: UPDATE gmd_ss_variants

556:
557: OPEN cr_time_points ;
558: CLOSE cr_time_points ;
559:
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

Line 566: WHERE variant_id in (select variant_id from gmd_ss_variants

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:
569: EXCEPTION
570: WHEN RECORD_LOCK THEN -- mahesh

Line 577: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');

573: END IF;
574: IF cr_time_points%ISOPEN THEN
575: CLOSE cr_time_points;
576: END IF;
577: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
578: x_return_status := FND_API.G_RET_STS_ERROR ;
579: WHEN REQ_FIELDS_MISSING THEN
580: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_BASE_SPEC');
581: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 594: SELECT scheduled_start_date from gmd_ss_variants

590: p_scheduled_start_date IN DATE,
591: x_return_status OUT NOCOPY VARCHAR2 ) IS
592: -- mahesh.
593: CURSOR cr_variants IS
594: SELECT scheduled_start_date from gmd_ss_variants
595: where ss_id = p_ss_id
596: for update of scheduled_start_date NOWAIT;
597:
598: CURSOR cr_time_points IS

Line 601: from gmd_ss_variants

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 ;
604:
605: record_lock EXCEPTION ;

Line 626: UPDATE gmd_ss_variants

622:
623: OPEN cr_time_points ;
624: CLOSE cr_time_points ;
625:
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

Line 633: WHERE variant_id in (select variant_id from gmd_ss_variants

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) ;
635:
636:
637:

Line 646: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');

642: END IF;
643: IF cr_time_points%ISOPEN THEN
644: CLOSE cr_time_points;
645: END IF;
646: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
647: x_return_status := FND_API.G_RET_STS_ERROR ;
648: WHEN REQ_FIELDS_MISSING THEN
649: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_SCHEDULED_START_DATE');
650: x_return_status := FND_API.G_RET_STS_ERROR ;