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 87: from gmd_ss_variants a

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

Line 180: insert into gmd_ss_variants

176:
177: -- JD changed whse_code to storage_subinventory.
178: -- JD changed location to storage_locator_id.
179:
180: insert into gmd_ss_variants
181: (variant_id,
182: variant_no,
183: ss_id,
184: material_source_id,

Line 280: gmd_ss_variants b

276: if (p_test_interval_plan_id IS NULL) then
277: select a.test_interval_plan_id
278: into l_test_interval_plan_id
279: from gmd_storage_plan_details a,
280: gmd_ss_variants b
281: where a.storage_plan_detail_id = b.storage_plan_detail_id
282: and b.variant_id = p_variant_id
283: ;
284: else

Line 360: from gmd_ss_variants

356: (p_material_source_id IN NUMBER,
357: x_return_status OUT NOCOPY VARCHAR2) IS
358: Cursor c_ss_id is
359: select ss_id
360: from gmd_ss_variants
361: where material_source_id = p_material_source_id;
362: l_return_status VARCHAR2(1);
363: l_ss_id NUMBER;
364:

Line 367: SELECT variant_id from gmd_ss_variants

363: l_ss_id NUMBER;
364:
365: -- mahesh.
366: CURSOR cr_variants IS
367: SELECT variant_id from gmd_ss_variants
368: where material_source_id = p_material_source_id
369: for update of variant_id NOWAIT;
370:
371: CURSOR cr_time_points IS

Line 374: from gmd_ss_variants

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 ;
377:
378: record_lock EXCEPTION ;

Line 401: from gmd_ss_variants

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
404: where material_source_id = p_material_source_id;
405:

Line 403: delete gmd_ss_variants

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
404: where material_source_id = p_material_source_id;
405:
406: update_variant_seq(l_ss_id, l_return_status);
407:

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

412: END IF;
413: IF cr_time_points%ISOPEN THEN
414: CLOSE cr_time_points;
415: END IF;
416: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
417: x_return_status := FND_API.G_RET_STS_ERROR ;
418: WHEN OTHERS THEN
419: GMD_API_PUB.Log_Message('GMD_API_ERROR',
420: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.DELETE_VARIANTS',

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

468:
469: IF cr_time_points%ISOPEN THEN
470: CLOSE cr_time_points;
471: END IF;
472: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
473: x_return_status := FND_API.G_RET_STS_ERROR ;
474: WHEN OTHERS THEN
475: GMD_API_PUB.Log_Message('GMD_API_ERROR',
476: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.DELETE_TIME_POINTS',

Line 487: from gmd_ss_variants a

483: l_variant_num NUMBER;
484: begin
485: select nvl(max(a.variant_no),0)
486: into l_variant_num
487: from gmd_ss_variants a
488: where a.ss_id = p_ss_id
489: ;
490:
491: return l_variant_num;

Line 499: from gmd_ss_variants

495: (ss_id IN NUMBER,
496: x_return_status OUT NOCOPY VARCHAR2) is
497: cursor c_variant_no (p_ss_id NUMBER) is
498: select variant_id,variant_no, rownum
499: from gmd_ss_variants
500: where ss_id = p_ss_id
501: order by variant_no;
502: begin
503: for l_variant_no in c_variant_no(ss_id) loop

Line 504: update gmd_ss_variants

500: where ss_id = p_ss_id
501: order by variant_no;
502: begin
503: for l_variant_no in c_variant_no(ss_id) loop
504: update gmd_ss_variants
505: set variant_no = l_variant_no.rownum
506: where variant_id = l_variant_no.variant_id;
507: end loop;
508: EXCEPTION

Line 522: SELECT default_spec_id from gmd_ss_variants

518: p_base_spec_id IN NUMBER,
519: x_return_status OUT NOCOPY VARCHAR2 ) IS
520: -- mahesh.
521: CURSOR cr_variants IS
522: SELECT default_spec_id from gmd_ss_variants
523: where ss_id = p_ss_id
524: for update of default_spec_id NOWAIT;
525:
526: CURSOR cr_time_points IS

Line 529: from gmd_ss_variants

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 ;
532:
533: record_lock EXCEPTION ;

Line 553: UPDATE gmd_ss_variants

549:
550: OPEN cr_time_points ;
551: CLOSE cr_time_points ;
552:
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

Line 559: WHERE variant_id in (select variant_id from gmd_ss_variants

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:
562: EXCEPTION
563: WHEN RECORD_LOCK THEN -- mahesh

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

566: END IF;
567: IF cr_time_points%ISOPEN THEN
568: CLOSE cr_time_points;
569: END IF;
570: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
571: x_return_status := FND_API.G_RET_STS_ERROR ;
572: WHEN REQ_FIELDS_MISSING THEN
573: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_BASE_SPEC');
574: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 587: SELECT scheduled_start_date from gmd_ss_variants

583: p_scheduled_start_date IN DATE,
584: x_return_status OUT NOCOPY VARCHAR2 ) IS
585: -- mahesh.
586: CURSOR cr_variants IS
587: SELECT scheduled_start_date from gmd_ss_variants
588: where ss_id = p_ss_id
589: for update of scheduled_start_date NOWAIT;
590:
591: CURSOR cr_time_points IS

Line 594: from gmd_ss_variants

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 ;
597:
598: record_lock EXCEPTION ;

Line 619: UPDATE gmd_ss_variants

615:
616: OPEN cr_time_points ;
617: CLOSE cr_time_points ;
618:
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

Line 626: WHERE variant_id in (select variant_id from gmd_ss_variants

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) ;
628:
629:
630:

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

635: END IF;
636: IF cr_time_points%ISOPEN THEN
637: CLOSE cr_time_points;
638: END IF;
639: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
640: x_return_status := FND_API.G_RET_STS_ERROR ;
641: WHEN REQ_FIELDS_MISSING THEN
642: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_SCHEDULED_START_DATE');
643: x_return_status := FND_API.G_RET_STS_ERROR ;