[Home] [Help]
PACKAGE: APPS.WIP_REQUIREMENT_VALIDATIONS
Source
1 PACKAGE WIP_REQUIREMENT_VALIDATIONS AUTHID CURRENT_USER AS
2 /* $Header: wiprqvds.pls 120.0 2005/05/25 07:33:52 appldev noship $ */
3
4 x_statement varchar2(2000);
5
6
7 /******************* DELETE REQUIREMENT ****************************/
8 /* inventory_item_id must not be null if load_type is 2, for DELETE */
9 Procedure Del_Req_Info_Exist(p_group_id in number,
10 p_wip_entity_id in number,
11 p_organization_id in number,
12 p_substitution_type in number,
13 p_operation_seq_num in number);
14
15
16 /* operations, resources, should all match and exist; for delete */
17 Procedure REQ_JOB_Match (p_group_id in number,
18 p_wip_entity_id in number,
19 p_organization_id in number,
20 p_substitution_type in number,
21 p_operation_seq_num in number,
22 p_inventory_item_id_old in number);
23
24 /* for delete only */
25 Procedure Safe_Delete (p_group_id in number,
26 p_wip_entity_id in number,
27 p_organization_id in number,
28 p_substitution_type in number,
29 p_operation_seq_num in number,
30 p_inventory_item_id_old in number);
31
32
33 /* main delete, call the above three */
34 Procedure Delete_Req(p_group_id in number,
35 p_wip_entity_id in number,
36 p_organization_id in number,
37 p_substitution_type in number);
38
39
40 /************************ ADD REQUIREMENT ******************/
41
42 /* inventory_item_id, quantity_per_assembly must not be null
43 if load_type is 2, for ADD */
44 Procedure Add_Req_Info_Exist(p_group_id in number,
45 p_wip_entity_id in number,
46 p_organization_id in number,
47 p_substitution_type in number,
48 p_operation_seq_num in number);
49
50 /* operations, resources, should NOT exist; for add */
51 Procedure REQ_JOB_NOT_EXIST (p_group_id in number,
52 p_wip_entity_id in number,
53 p_organization_id in number,
54 p_substitution_type in number,
55 p_operation_seq_num in number,
56 p_inventory_item_id_new in number);
57
58
59 /* for add only */
60 Procedure Valid_Requirement(p_group_id in number,
61 p_wip_entity_id in number,
62 p_organization_id in number,
63 p_substitution_type in number,
64 p_operation_seq_num in number,
65 p_inventory_item_id_new in number);
66
67 /* main add, call the above three */
68 Procedure add_Req(p_group_id in number,
69 p_wip_entity_id in number,
70 p_organization_id in number,
71 p_substitution_type in number);
72
73
74 /* called after defaulting */
75 Procedure Post_Default(p_group_id number,
76 p_wip_entity_id number,
77 p_organization_id number,
78 p_substitution_type number,
79 p_operation_seq_num number,
80 p_inventory_item_id_new number);
81
82 /************************ CHANGE REQUIREMENT ******************/
83 Procedure Change_Req(p_group_id in number,
84 p_wip_entity_id in number,
85 p_organization_id in number,
86 p_substitution_type in number);
87
88 Procedure Chng_Req_Info_Exist(p_group_id number,
89 p_wip_entity_id number,
90 p_organization_id number,
91 p_substitution_type number,
92 p_operation_seq_num number);
93
94
95 /**************** Utilities for ERROR ***********************/
96
97 /* all required columns are not null */
98 function IS_Error(p_group_id number,
99 p_wip_entity_id number,
100 p_organization_id number,
101 p_substitution_type number,
102 p_operation_seq_num number,
103 p_inventory_item_id_old number,
104 p_inventory_item_id_new number) return number;
105
106 /* culomns could be null */
107 function Info_Missing(p_group_id number,
108 p_wip_entity_id number,
109 p_organization_id number,
110 p_substitution_type number,
111 p_operation_seq_num number) return number;
112
113
114 END WIP_REQUIREMENT_VALIDATIONS;