[Home] [Help]
PACKAGE: APPS.GMD_SPEC_GRP
Source
1 PACKAGE GMD_SPEC_GRP AS
2 /* $Header: GMDGSPCS.pls 120.0 2005/05/25 19:51:44 appldev noship $ */
3
4 -- Start of comments
5 --+==========================================================================+
6 --| Copyright (c) 1998 Oracle Corporation |
7 --| Redwood Shores, CA, USA |
8 --| All rights reserved. |
9 --+==========================================================================+
10 --| File Name : GMDGSPCS.pls |
11 --| Package Name : GMD_Spec_GRP |
12 --| Type : Group |
13 --| |
14 --| Notes |
15 --| This package contains group layer APIs for Specification Entity |
16 --| |
17 --| HISTORY |
18 --| Chetan Nagar 26-Jul-2002 Created. |
19 --| Saikiran Vankadari 07-Feb-2005 Changed as part of Convergence |
20 --| |
21 --+==========================================================================+
22 -- End of comments
23
24
25
26 PROCEDURE validate_spec_header
27 (
28 p_spec_header IN gmd_specifications%ROWTYPE
29 , p_called_from IN VARCHAR2 DEFAULT 'API'
30 , p_operation IN VARCHAR2
31 , x_return_status OUT NOCOPY VARCHAR2
32 );
33
34 FUNCTION spec_vers_exist(p_spec_name VARCHAR2, p_spec_vers NUMBER)
35 RETURN BOOLEAN;
36
37 FUNCTION spec_test_exist(p_spec_id NUMBER, p_test_id NUMBER)
38 RETURN BOOLEAN;
39
40 FUNCTION spec_reference_tests_exist(p_spec_id NUMBER, p_exp_test_seq NUMBER, p_exp_test_id NUMBER)
41 RETURN BOOLEAN;
42
43 FUNCTION spec_owner_orgn_valid(p_responsibility_id NUMBER, p_owner_organization_id NUMBER)
44 RETURN BOOLEAN;
45
46 -- KYH BUG 2904004 BEGIN
47 FUNCTION uom_class_combo_exist(p_spec_id NUMBER, p_test_id NUMBER, p_to_uom VARCHAR2)
48 RETURN BOOLEAN;
49 -- KYH BUG 2904004 END
50
51 PROCEDURE validate_spec_test
52 ( p_spec_test IN gmd_spec_tests%ROWTYPE
53 , p_called_from IN VARCHAR2 DEFAULT 'API'
54 , p_operation IN VARCHAR2
55 , x_spec_test OUT NOCOPY gmd_spec_tests%ROWTYPE
56 , x_return_status OUT NOCOPY VARCHAR2) ;
57
58 PROCEDURE validate_after_insert_all(
59 p_spec_id IN NUMBER,
60 x_return_status OUT NOCOPY VARCHAR2) ;
61
62 PROCEDURE validate_after_delete_test(
63 p_spec_id IN NUMBER,
64 x_return_status OUT NOCOPY VARCHAR2) ;
65
66 PROCEDURE VALIDATE_BEFORE_DELETE(
67 p_spec_id IN NUMBER
68 , x_return_status OUT NOCOPY VARCHAR2
69 , x_message_data OUT NOCOPY VARCHAR2);
70
71 PROCEDURE VALIDATE_BEFORE_DELETE(
72 p_spec_id IN NUMBER
73 , p_test_id IN NUMBER
74 , x_return_status OUT NOCOPY VARCHAR2
75 , x_message_data OUT NOCOPY VARCHAR2);
76
77 FUNCTION spec_test_seq_exist(p_spec_id IN NUMBER ,
78 p_seq IN NUMBER ,
79 p_exclude_test_id IN NUMBER DEFAULT NULL)
80 RETURN BOOLEAN;
81
82 FUNCTION spec_test_min_target_max_valid(p_test_id IN NUMBER,
83 p_test_type IN VARCHAR2,
84 p_validation_level IN VARCHAR2 DEFAULT 'FULL',
85 p_st_min IN NUMBER,
86 p_st_target IN NUMBER,
87 p_st_max IN NUMBER,
88 p_t_min IN NUMBER,
89 p_t_max IN NUMBER)
90 RETURN BOOLEAN;
91
92 FUNCTION value_in_num_range_display(p_test_id IN NUMBER,
93 p_value IN NUMBER,
94 x_return_status OUT NOCOPY VARCHAR2)
95 RETURN BOOLEAN ;
96
97 FUNCTION SPEC_TEST_EXP_ERROR_REGION_VAL(p_validation_level VARCHAR2 DEFAULT 'FULL',
98 p_exp_error_type VARCHAR2,
99 p_test_min NUMBER,
100 p_below_spec_min NUMBER,
101 p_spec_test_min NUMBER,
102 p_above_spec_min NUMBER,
103 p_spec_test_target NUMBER,
104 p_below_spec_max NUMBER,
105 p_spec_test_max NUMBER,
106 p_above_spec_max NUMBER,
107 p_test_max NUMBER)
108 RETURN BOOLEAN;
109
110 FUNCTION spec_test_precisions_valid(p_spec_display_precision IN NUMBER,
111 p_spec_report_precision IN NUMBER,
112 p_test_display_precision IN NUMBER,
113 p_test_report_precision IN NUMBER)
114 RETURN BOOLEAN;
115
116 FUNCTION record_updateable_with_status(p_status NUMBER)
117 RETURN BOOLEAN;
118
119 FUNCTION spec_used_in_sample(p_spec_id NUMBER)
120 RETURN BOOLEAN;
121
122 FUNCTION VERSION_CONTROL_STATE(p_entity VARCHAR2, p_entity_id NUMBER)
123 RETURN VARCHAR2 ;
124
125 PROCEDURE create_specification(p_spec_id IN NUMBER,
126 x_spec_id OUT NOCOPY NUMBER,
127 x_return_status OUT NOCOPY VARCHAR2);
128
129 PROCEDURE change_status
130 (
131 p_table_name IN VARCHAR2
132 , p_id IN NUMBER
133 , p_source_status IN NUMBER
134 , p_target_status IN NUMBER
135 , p_mode IN VARCHAR2
136 , p_entity_type IN VARCHAR2 DEFAULT 'S'
137 , x_return_status OUT NOCOPY VARCHAR2
138 , x_message OUT NOCOPY VARCHAR2
139 );
140
141
142 PROCEDURE Get_Who
143 ( p_user_name IN fnd_user.user_name%TYPE
144 , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
145 );
146
147 END GMD_Spec_GRP;
148