1 PACKAGE GMD_STABILITY_STUDIES_GRP AS
2 /* $Header: GMDGSSTS.pls 120.1 2005/08/16 07:46:40 svankada noship $ */
3
4 FUNCTION Stability_Study_Exist
5 (
6 p_stability_study_no IN VARCHAR2 ) RETURN BOOLEAN;
7
8 FUNCTION calculate_end_date
9 ( p_storage_plan_id IN NUMBER,
10 p_start_date IN DATE ) RETURN DATE ;
11
12 -- INVCONV
13 /* This procedure is being called from the post-forms-commit trigger of the Stability Studies form.
14 This procedure is not required because when we select sample group from the material sources form,
15 all the validations being done in this procedure are done there itself. So, this procedure will be removed.*/
16 /*PROCEDURE validate_sampling_event( p_ss_id IN NUMBER ,
17 p_item_id IN NUMBER,
18 p_base_spec_id IN NUMBER) ; */
19
20 PROCEDURE calculate_sample_qty(
21 -- p_ss_id IN NUMBER, INVCONV
22 p_source_id IN NUMBER,
23 --p_item_id IN NUMBER, INVCONV
24 p_sample_qty OUT NOCOPY NUMBER,
25 p_sample_uom OUT NOCOPY VARCHAR2,
26 x_return_status OUT NOCOPY VARCHAR2) ;
27
28 -- not needed now for INVCONV
29
30 --FUNCTION check_doc_numbering( p_doc_type IN VARCHAR2 ,
31 -- p_orgn_code IN VARCHAR2 ) RETURN NUMBER ;
32
33 PROCEDURE ss_approval_checklist_ok(p_ss_id IN NUMBER ,
34 x_return_status OUT NOCOPY VARCHAR2) ;
35
36 PROCEDURE ss_launch_checklist_ok(p_ss_id IN NUMBER ,
37 x_return_status OUT NOCOPY VARCHAR2) ;
38
39 PROCEDURE change_ss_status( p_ss_id IN NUMBER,
40 p_start_status IN NUMBER,
41 p_target_status IN NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_message OUT NOCOPY VARCHAR2 ) ;
44
45 END GMD_STABILITY_STUDIES_GRP;
[Home] [Help]