[Home] [Help]
PACKAGE: APPS.WIP_JOB_DTLS_SUBSTITUTIONS
Source
1 PACKAGE WIP_JOB_DTLS_SUBSTITUTIONS AS
2 /* $Header: wipjdsts.pls 120.2.12000000.1 2007/01/18 22:16:39 appldev ship $ */
3
4
5 Procedure Delete_Resource (p_group_id number,
6 p_wip_entity_id number,
7 p_organization_id number,
8 p_err_code out NOCOPY varchar2,
9 p_err_msg out NOCOPY varchar2);
10
11 Procedure Add_Resource (p_group_id number,
12 p_wip_entity_id number,
13 p_organization_id number,
14 p_err_code out NOCOPY varchar2,
15 p_err_msg out NOCOPY varchar2);
16
17
18 Procedure Change_Resource (p_group_id number,
19 p_wip_entity_id number,
20 p_organization_id number,
21 p_err_code out NOCOPY varchar2,
22 p_err_msg out NOCOPY varchar2);
23
24
25 Procedure Delete_Resource_Instance (p_group_id number,
26 p_wip_entity_id number,
27 p_organization_id number,
28 p_substitution_type number,
29 p_err_code out NOCOPY varchar2,
30 p_err_msg out NOCOPY varchar2);
31
32 Procedure Add_Resource_Instance (p_group_id number,
33 p_wip_entity_id number,
34 p_organization_id number,
35 p_err_code out NOCOPY varchar2,
36 p_err_msg out NOCOPY varchar2);
37
38
39 Procedure Change_Resource_Instance (p_group_id number,
40 p_wip_entity_id number,
41 p_organization_id number,
42 p_err_code out NOCOPY varchar2,
43 p_err_msg out NOCOPY varchar2);
44
45 Procedure Delete_Sub_Resource (p_group_id number,
46 p_wip_entity_id number,
47 p_organization_id number,
48 p_err_code out NOCOPY varchar2,
49 p_err_msg out NOCOPY varchar2);
50
51 Procedure Add_Sub_Resource (p_group_id number,
52 p_wip_entity_id number,
53 p_organization_id number,
54 p_err_code out NOCOPY varchar2,
55 p_err_msg out NOCOPY varchar2);
56
57
58
59 Procedure Change_Sub_Resource (p_group_id number,
60 p_wip_entity_id number,
61 p_organization_id number,
62 p_err_code out NOCOPY varchar2,
63 p_err_msg out NOCOPY varchar2);
64
65
66 Procedure Delete_Requirement (p_group_id number,
67 p_wip_entity_id number,
68 p_organization_id number,
69 p_err_code out NOCOPY varchar2,
70 p_err_msg out NOCOPY varchar2);
71
72
73 Procedure Add_Requirement (p_group_id number,
74 p_wip_entity_id number,
75 p_organization_id number,
76 p_err_code out NOCOPY varchar2,
77 p_err_msg out NOCOPY varchar2);
78
79
80 Procedure Change_Requirement (p_group_id number,
81 p_wip_entity_id number,
82 p_organization_id number,
83 p_err_code out NOCOPY varchar2,
84 p_err_msg out NOCOPY varchar2);
85
86 Procedure Add_Operation (p_group_id in number,
87 p_wip_entity_id in number,
88 p_organization_id in number,
89 x_err_code out NOCOPY varchar2,
90 x_err_msg out NOCOPY varchar2 ,
91 x_return_status out NOCOPY varchar2);
92
93 Procedure Change_Operation (p_group_id in number,
94 p_wip_entity_id in number,
95 p_organization_id in number,
96 x_err_code out NOCOPY varchar2,
97 x_err_msg out NOCOPY varchar2,
98 x_return_status out NOCOPY varchar2);
99
100 Procedure Verify_Operation (p_group_id in number,
101 p_wip_entity_id in number,
102 p_organization_id in number,
103 x_err_code out NOCOPY varchar2,
104 x_err_msg out NOCOPY varchar2,
105 x_return_status out NOCOPY varchar2);
106
107 Procedure Delete_Resource_Usage(p_wip_entity_id number,
108 p_organization_id number,
109 p_operation_seq_num number,
110 p_resource_seq_num number,
111 x_err_code out NOCOPY varchar2,
112 x_err_msg out NOCOPY varchar2);
113
114 Procedure Substitution_Res_Usages( p_group_id in number,
115 p_wip_entity_id in number,
116 p_organization_id in number,
117 x_err_code out NOCOPY varchar2,
118 x_err_msg out NOCOPY varchar2,
119 x_return_status out NOCOPY varchar2);
120
121 Procedure Sub_Usage (p_group_id in number,
122 p_wip_entity_id in number,
123 p_organization_id in number,
124 p_operation_seq_num in number,
125 p_resource_seq_num in number,
126 x_err_code out NOCOPY varchar2,
127 x_err_msg out NOCOPY varchar2,
128 x_return_status out NOCOPY varchar2);
129
130 Procedure Add_Default_Usage(p_wip_entity_id number,
131 p_organization_id number,
132 p_operation_seq_num number,
133 p_resource_seq_num number);
134
135
136 Function Num_Of_Usage(p_group_id number, /* Fix for bug#3636378 */
137 p_wip_entity_id number,
138 p_organization_id number,
139 p_operation_seq_num number,
140 p_resource_seq_num number) return number;
141
142 Procedure Delete_Op_Link (p_group_id in number,
143 p_wip_entity_id in number,
144 p_organization_id in number,
145 p_err_code out NOCOPY varchar2,
146 p_err_msg out NOCOPY varchar2);
147
148 Procedure Add_Op_Link (p_group_id in number,
149 p_wip_entity_id in number,
150 p_organization_id in number,
151 p_err_code out NOCOPY varchar2,
152 p_err_msg out NOCOPY varchar2);
153
154 Procedure Add_Serial_Association(p_group_id in number,
155 p_wip_entity_id in number,
156 p_organization_id in number,
157 x_err_code out NOCOPY varchar2,
158 x_err_msg out NOCOPY varchar2,
159 x_return_status out NOCOPY varchar2);
160
161 Procedure Change_Serial_Association(p_group_id in number,
162 p_wip_entity_id in number,
163 p_organization_id in number,
164 x_err_code out NOCOPY varchar2,
165 x_err_msg out NOCOPY varchar2,
166 x_return_status out NOCOPY varchar2);
167
168
169 Procedure Delete_Serial_Association(p_group_id in number,
170 p_wip_entity_id in number,
171 p_organization_id in number,
172 x_err_code out NOCOPY varchar2,
173 x_err_msg out NOCOPY varchar2,
174 x_return_status out NOCOPY varchar2);
175
176 Procedure Default_Serial_Associations(p_rowid in rowid,
177 p_wip_entity_id in number,
178 p_organization_id in number,
179 x_err_msg out NOCOPY varchar2,
180 x_return_status out NOCOPY varchar2);
181
182 Procedure Update_Cumulative_Time (
183 p_wip_entity_id in number,
184 p_operation_seq_num in number,
185 p_resource_seq_num in number);
186
187 END WIP_JOB_DTLS_SUBSTITUTIONS;