[Home] [Help]
PACKAGE: APPS.GMD_VARIANT_TIME_POINT_GRP
Source
1 PACKAGE GMD_VARIANT_TIME_POINT_GRP AUTHID CURRENT_USER AS
2 /* $Header: GMDGSVTS.pls 115.3 2003/04/17 18:39:31 magupta noship $ */
3 --
4 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
5 -- directory of SQL Navigator
6 --
7 -- Purpose: Briefly explain the functionality of the package
8 --
9 -- MODIFICATION HISTORY
10 -- Person Date Comments
11 -- --------- ------ ------------------------------------------
12 -- Enter package declarations as shown below
13
14
15 PROCEDURE create_variants_time_points
16 (p_stability_study IN NUMBER,
17 p_material_source_id IN NUMBER,
18 x_return_status OUT NOCOPY VARCHAR2);
19
20 procedure create_variants
21 (p_ss_id NUMBER,
22 p_no_of_packages NUMBER,
23 p_material_source_id NUMBER,
24 p_storage_plan_id NUMBER,
25 p_base_spec_id NUMBER,
26 p_scheduled_start_date DATE,
27 p_actual_start_date DATE,
28 p_created_by NUMBER,
29 x_return_status OUT NOCOPY VARCHAR2);
30
31 procedure create_time_points
32 (p_variant_id NUMBER,
33 p_scheduled_start_date DATE,
34 p_base_spec_id NUMBER,
35 p_test_interval_plan_id NUMBER,
36 p_actual_date DATE,
37 p_samples_per_time_point NUMBER,
38 p_created_by NUMBER,
39 x_return_status OUT NOCOPY VARCHAR2);
40
41 PROCEDURE delete_variants
42 (p_material_source_id IN NUMBER,
43 x_return_status OUT NOCOPY VARCHAR2);
44
45 PROCEDURE delete_time_points
46 (p_variant_id IN NUMBER,
47 x_return_status OUT NOCOPY VARCHAR2);
48
49
50 PROCEDURE update_variant_seq
51 (ss_id IN NUMBER,
52 x_return_status OUT NOCOPY VARCHAR2);
53
54 PROCEDURE update_base_spec
55 (p_ss_id IN NUMBER,
56 p_base_spec_id IN NUMBER,
57 x_return_status OUT NOCOPY VARCHAR2 ) ;
58
59 PROCEDURE update_scheduled_start_date
60 (p_ss_id IN NUMBER,
61 p_scheduled_start_date IN DATE,
62 x_return_status OUT NOCOPY VARCHAR2 ) ;
63
64 PROCEDURE submit_srs_request
65 (p_variant_id IN NUMBER,
66 p_time_point_id IN NUMBER,
67 p_conc_id OUT NOCOPY NUMBER );
68
69 END GMD_VARIANT_TIME_POINT_GRP; -- Package