[Home] [Help]
PACKAGE: APPS.WIP_RESOURCE_VALIDATIONS
Source
1 PACKAGE WIP_RESOURCE_VALIDATIONS AS
2 /* $Header: wiprsvds.pls 120.0 2005/05/25 08:07:09 appldev noship $ */
3
4 x_statement varchar2(2000);
5
6
7 /**************** DELETE RESOURCES ************************************/
8
9 /* resource_seq_num, resource_id_old must not be null when delete resource */
10 Procedure Del_Res_Info_Exist(p_group_id number,
11 p_wip_entity_id number,
12 p_organization_id number,
13 p_substitution_type number,
14 p_operation_seq_num number);
15
16
17 /* job/operations/resource_seq/resource_id_old all match and exist;
18 called when Delete Resources */
19 Procedure RES_JOB_Match (p_group_id number,
20 p_wip_entity_id number,
21 p_organization_id number,
22 p_substitution_type number,
23 p_operation_seq_num number,
24 p_resource_seq_num number,
25 p_resource_id_old number);
26
27 /* check WCTI, WT for job/ops/resource match */
28 Procedure Safe_Delete (p_group_id number,
29 p_wip_entity_id number,
30 p_organization_id number,
31 p_substitution_type number,
32 p_operation_seq_num number,
33 p_resource_seq_num number,
34 p_resource_id_old number);
35
36 /* outside processing; called by Delete */
37 Procedure Safe_PO (p_group_id number,
38 p_wip_entity_id number,
39 p_organization_id number,
40 p_substitution_type number,
41 p_operation_seq_num number,
42 p_resource_seq_num number,
43 p_resource_id_old number);
44
45 /* main procedure, call the above four */
46 Procedure Delete_Resource (p_group_id number,
47 p_wip_entity_id number,
48 p_organization_id number,
49 p_substitution_type number);
50
51 /***********************ADD RESOURCES ***********************************/
52 /* when add resources, resource_seq_num, resource_id_new and
53 usage_rate_or_amount can not be null */
54 Procedure Add_Res_Info_Exist(p_group_id number,
55 p_wip_entity_id number,
56 p_organization_id number,
57 p_substitution_type number,
58 p_operation_seq_num number);
59
60 /* called when Add; resource-to-be-added should be valid */
61 Procedure Valid_Resource(p_group_id number,
62 p_wip_entity_id number,
63 p_organization_id number,
64 p_substitution_type number,
65 p_operation_seq_num number,
66 p_resource_seq_num number,
67 p_resource_id_new number);
68
69
70 /* called when Add; resource_seq_num shouldn't exist */
71 Procedure Resource_Seq_Num(p_group_id number,
72 p_wip_entity_id number,
73 p_organization_id number,
74 p_substitution_type number,
75 p_operation_seq_num number,
76 p_resource_seq_num number);
77
78 /* called when Add; should be greater than or equal to 0 */
79 Procedure Usage_Rate_Or_Amount(p_group_id number,
80 p_wip_entity_id number,
81 p_organization_id number,
82 p_substitution_type number,
83 p_operation_seq_num number,
84 p_resource_seq_num number,
85 p_resource_id_new number,
86 p_usage_rate_or_amount number);
87
88 /* bug 2951776 - Check that Assigned_Units is greater than 0 */
89 Procedure Assigned_Units(p_group_id number,
90 p_wip_entity_id number,
91 p_organization_id number,
92 p_load_type number,
93 p_substitution_type number,
94 p_operation_seq_num number,
95 p_resource_seq_num number);
96
97 /* main procedure to add resource, call the above */
98 Procedure Add_Resource(p_group_id number,
99 p_wip_entity_id number,
100 p_organization_id number,
101 p_substitution_type number);
102
103 /**************** CAHNGE RESOURCES ************************************/
104
105 Procedure Change_Resource(p_group_id number,
106 p_wip_entity_id number,
107 p_organization_id number,
108 p_substitution_type number);
109
110 Procedure Validate_Assigned_Units(p_group_id number,
111 p_wip_entity_id number,
112 p_organization_id number,
113 p_substitution_type number,
114 p_operation_seq_num number,
115 p_resource_seq_num number);
116
117
118 Procedure Chng_Res_Info_Exist(p_group_id number,
119 p_wip_entity_id number,
120 p_organization_id number,
121 p_substitution_type number,
122 p_operation_seq_num number);
123
124 Procedure Check_Res_Substitution(p_group_id number,
125 p_wip_entity_id number,
126 p_organization_id number,
127 p_substitution_type number,
128 p_operation_seq_num number,
129 p_resource_seq_num number,
130 p_resource_id_old number);
131
132 /********************** ERROR HANDLING *********************************/
133 /* Is there errors for the previous validations? It doesn't pass more resource
134 parameters, because it is unique up to resource_seq_num */
135 function IS_Error(p_group_id number,
136 p_wip_entity_id number,
137 p_organization_id number,
138 p_substitution_type number,
139 p_operation_seq_num number,
140 p_resource_seq_num number) return number;
141
142 /* Check errors occurred when there could be NULL data */
143 function Info_Missing(p_group_id number,
144 p_wip_entity_id number,
145 p_organization_id number,
146 p_substitution_type number,
147 p_operation_seq_num number) return number;
148
149
150
151 /**************** Validation for substitute resources ******************/
152 Procedure Substitute_Info (p_group_id number,
153 p_wip_entity_id number,
154 p_organization_id number,
155 p_substitution_type number,
156 p_operation_seq_num number,
157 p_resource_seq_num number);
158
159 Procedure Delete_Sub_Resource (p_group_id number,
160 p_wip_entity_id number,
161 p_organization_id number,
162 p_substitution_type number);
163
164 Procedure Add_Sub_Resource(p_group_id number,
165 p_wip_entity_id number,
166 p_organization_id number,
167 p_substitution_type number);
168
169 Procedure Change_Sub_Resource(p_group_id number,
170 p_wip_entity_id number,
171 p_organization_id number,
172 p_substitution_type number);
173
174 Procedure Check_Sub_Groups (p_group_id NUMBER,
175 p_organization_id NUMBER,
176 p_wip_entity_id NUMBER);
177
178
179 END WIP_RESOURCE_VALIDATIONS;