APPS.GMD_STABILITY_STUDIES_GRP dependencies on GMD_STABILITY_STUDIES_B

Line 8: FROM gmd_stability_studies_b

4: FUNCTION Stability_Study_Exist(p_stability_study_no IN VARCHAR2 )
5: RETURN BOOLEAN IS
6: CURSOR Cur_get_stability_study IS
7: SELECT '1'
8: FROM gmd_stability_studies_b
9: WHERE ss_no = p_stability_study_no;
10: l_temp VARCHAR2(1);
11: BEGIN
12: IF (p_stability_study_no IS NOT NULL) THEN

Line 107: FROM gmd_stability_studies_b

103: END IF;
104:
105: -- Retrieving inventory item id INVCONV
106: SELECT inventory_item_id, organization_id INTO l_inventory_item_id, l_organization_id -- INVCONV
107: FROM gmd_stability_studies_b
108: WHERE ss_id = (SELECT ss_id FROM gmd_ss_material_sources WHERE source_id = p_source_id);
109:
110: SELECT source_organization_id INTO l_source_organization_id
111: FROM gmd_ss_material_sources

Line 280: FROM gmd_stability_studies_b

276:
277: x_return_status := FND_API.G_RET_STS_SUCCESS;
278:
279: SELECT inventory_item_id INTO l_inventory_item_id -- INVCONV
280: FROM gmd_stability_studies_b
281: WHERE ss_id = p_ss_id;
282:
283: -- check is sufficient inventory is there for the material source containing the lot.
284:

Line 372: FROM gmd_stability_studies_b

368: END IF;
369:
370: SELECT organization_id,material_sources_cnt, inventory_item_id
371: INTO l_organization_id ,l_material_sources_cnt , l_inventory_item_id -- INVCONV
372: FROM gmd_stability_studies_b
373: WHERE ss_id = p_ss_id ;
374:
375: -- Sample no. generation should be automatic and not manual.
376: l_progress := '020';

Line 550: FROM gmd_stability_studies_b

546:
547: l_progress := '020';
548:
549: SELECT inventory_item_id INTO l_inventory_item_id -- INVCONV
550: FROM gmd_stability_studies_b
551: WHERE ss_id = p_ss_id ;
552:
553: -- each material source must have sampling event and lot associated with it.
554:

Line 678: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_STABILITY_STUDIES_B'

674: AND target_status = p_target_status
675: AND entity_type = 'STABILITY' ;
676:
677: IF l_pending_status IS NULL OR l_rework_status IS NULL THEN
678: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_STABILITY_STUDIES_B'
679: , p_id => p_ss_id
680: , p_source_status => p_start_status
681: , p_target_status => p_target_status
682: , p_mode => 'A'

Line 739: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_STABILITY_STUDIES_B'

735: -- to request for approval and kick off the workflow.
736: -- if no approvals are setup , workflow will send notification to the owner of stability study.
737: -- removing the call to AME api's.
738:
739: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_STABILITY_STUDIES_B'
740: , p_id => p_ss_id
741: , p_source_status => p_start_status
742: , p_target_status => p_target_status
743: , p_mode => 'P'