1 Package Wip_Flow_Utilities as
2 /* $Header: wipfcoms.pls 120.0 2005/05/25 07:36:14 appldev noship $ */
3
4 function Subs_Check(
5 p_parent_id in number,
6 p_organization_id in number,
7 p_err_num in out nocopy number,
8 p_err_mesg in out nocopy varchar2
9 ) return number;
10
11 function Revision_Generation(
12 p_interface_id in number,
13 p_err_num in out nocopy number,
14 p_err_mesg in out nocopy varchar2) return number;
15
16 function Generate_Issue_Locator_Id(
17 p_parent_id in number,
18 p_organization_id in number,
19 p_src_prj_id in number,
20 p_src_tsk_id in number,
21 p_wip_entity_id in number,
22 p_err_num in out nocopy number,
23 p_err_mesg in out nocopy varchar2) return number;
24
25 function Pre_Inv_Validations(
26 p_interface_id in number,
27 p_org_id in number,
28 p_user_id in number,
29 p_login_id in number,
30 p_appl_id in number,
31 p_prog_id in number,
32 p_reqstid in number,
33 p_err_num in out nocopy number,
34 p_err_mesg in out nocopy varchar2,
35 p_hdr_id in out nocopy number)
36 return number;
37
38 function Post_Inv_Validations(
39 p_interface_id in number,
40 p_org_id in number,
41 p_user_id in number,
42 p_login_id in number,
43 p_appl_id in number,
44 p_prog_id in number,
45 p_reqstid in number,
46 p_err_num in out nocopy number,
47 p_err_mesg in out nocopy varchar2,
48 p_hdr_id in number,
49 p_org_hdr_id in number)
50 return number ;
51 function Post_Transaction_Cleanup(
52 p_header_id in number)
53 return number;
54
55 procedure Create_Flow_Schedules(
56 p_header_id in number);
57
58 function Create_Flow_Schedule(
59 p_wip_entity_id in number,
60 p_organization_id in number,
61 p_last_update_date in date,
62 p_last_updated_by in number,
63 p_creation_date in date,
64 p_created_by in number,
65 p_last_update_login in number,
66 p_request_id in number,
67 p_program_application_id in number,
68 p_program_id in number,
69 p_program_update_date in date,
70 p_primary_item_id in number,
71 p_class_code in varchar2,
72 p_scheduled_start_date in date,
73 p_date_closed in date,
74 p_planned_quantity in number,
75 p_quantity_completed in number,
76 p_quantity_scrapped in number, -- CFM Scrap
77 p_mps_sched_comp_date in date,
78 p_mps_net_quantity in number,
79 p_bom_revision in varchar2,
80 p_routing_revision in varchar2,
81 p_bom_revision_date in date,
82 p_routing_revision_date in date,
83 p_alternate_bom_designator in varchar2,
84 p_alternate_routing_designator in varchar2,
85 p_completion_subinventory in varchar2,
86 p_completion_locator_id in number,
87 p_demand_class in varchar2,
88 p_scheduled_completion_date in date,
89 p_schedule_group_id in number,
90 p_build_sequence in number,
91 p_line_id in number,
92 p_project_id in number,
93 p_task_id in number,
94 p_status in number,
95 p_schedule_number in varchar2,
96 p_scheduled_flag in number,
97 p_unit_number IN VARCHAR2,
98 p_attribute_category in varchar2,
99 p_attribute1 in varchar2,
100 p_attribute2 in varchar2,
101 p_attribute3 in varchar2,
102 p_attribute4 in varchar2,
103 p_attribute5 in varchar2,
104 p_attribute6 in varchar2,
105 p_attribute7 in varchar2,
106 p_attribute8 in varchar2,
107 p_attribute9 in varchar2,
108 p_attribute10 in varchar2,
109 p_attribute11 in varchar2,
110 p_attribute12 in varchar2,
111 p_attribute13 in varchar2,
112 p_attribute14 in varchar2,
113 p_attribute15 in varchar2 )
114 return number;
115
116 procedure Delete_Flow_Schedules(
117 p_header_id in number);
118
119 procedure Delete_Flow_Schedule(
120 p_wip_entity_id in number );
121
122 function Update_Flow_Schedule(
123 p_wip_entity_id in number,
124 p_quantity_completed in number, -- CFM Scrap (primary qty)
125 p_quantity_scrapped IN NUMBER, -- CFM Scrap (primary qty)
126 p_transaction_date in date,
127 p_schedule_flag in varchar2,
128 p_last_updated_by number) -- Fix for Bug#2517396
129 return number;
130
131 function Status_Change(
132 p_planned_qty number,
133 p_cur_completed_qty number,
134 p_qty_completed number)
135 return number;
136
137 Procedure Update_Completion_UOM(
138 p_item_id in number,
139 p_org_id in number,
140 p_txn_qty in number,
141 p_txn_uom in varchar2,
142 p_pri_qty in out nocopy number);
143
144 function Check_Validation_Errors(
145 p_header_id in number,
146 p_err_num in out nocopy number,
147 p_err_mesg in out nocopy varchar2 )
148 return number;
149
150 function Flow_Error_Cleanup(
151 p_txn_int_id in number,
152 p_wip_entity_id in number,
153 p_user_id in number,
154 p_login_id in number,
155 p_err_mesg in out nocopy varchar2
156 ) return number;
157
158 PROCEDURE Construct_Wip_Line_Ops(p_routing_sequence_id IN NUMBER,
159 p_terminal_op_seq_num IN NUMBER,
160 p_terminal_op_seq_id IN NUMBER,
161 p_date IN DATE DEFAULT NULL);
162
163 FUNCTION line_op_exists(p_op_seq_id IN NUMBER) RETURN NUMBER;
164 pragma restrict_references(line_op_exists, WNDS, WNPS);
165
166 PROCEDURE clear_wip_line_ops_cache;
167 PROCEDURE show_wip_line_ops(x_all_ops OUT NOCOPY VARCHAR2);
168 FUNCTION Line_Op_same_or_prior(p_routing_sequence_id IN NUMBER,
169 p_eff_date IN DATE,
170 p_line_op_seq1_id IN NUMBER,
171 p_line_op_seq1_num IN NUMBER,
172 p_line_op_seq2_id IN NUMBER,
173 p_line_op_seq2_num IN NUMBER,
174 p_destroy_cache IN VARCHAR2) RETURN NUMBER;
175
176 FUNCTION same_or_prior_safe(p_routing_sequence_id IN NUMBER,
177 p_eff_date IN DATE,
178 p_line_op_seq1_id IN NUMBER,
179 p_line_op_seq1_num IN NUMBER,
180 p_line_op_seq2_id IN NUMBER,
181 p_line_op_seq2_num IN NUMBER) RETURN NUMBER;
182 pragma restrict_references(same_or_prior_safe, WNDS, WNPS);
183
184 PROCEDURE get_line_op_from_event(p_routing_sequence_id IN NUMBER,
185 p_eff_date IN DATE,
186 p_event_op_seq_num IN NUMBER,
187 x_line_op_seq_num OUT NOCOPY NUMBER,
188 x_line_op_seq_id OUT NOCOPY NUMBER);
189 pragma restrict_references(get_line_op_from_event, WNDS, WNPS);
190
191 FUNCTION event_to_lineop_seq_num(p_routing_sequence_id IN NUMBER,
192 p_eff_date IN DATE,
193 p_event_op_seq_num IN NUMBER) RETURN NUMBER;
194 pragma restrict_references(event_to_lineop_seq_num, WNDS, WNPS);
195
196 FUNCTION Event_in_same_or_prior_lineop(p_routing_sequence_id IN NUMBER,
197 p_eff_date IN DATE,
198 p_event_op_seq_num IN NUMBER,
199 p_line_op_seq_num IN NUMBER,
200 p_destroy_cache IN VARCHAR2) RETURN NUMBER;
201
202 FUNCTION same_or_prior_lineop_safe(p_routing_sequence_id IN NUMBER,
203 p_eff_date IN DATE,
204 p_event_op_seq_num IN NUMBER,
205 p_line_op_seq_num IN NUMBER) RETURN NUMBER;
206 pragma restrict_references(same_or_prior_lineop_safe, WNDS, WNPS);
207
208 PROCEDURE Default_lots(txn_interface_id IN NUMBER, txn_source_name IN VARCHAR2,
209 txn_type_id IN NUMBER, wip_entity_id IN NUMBER);
210
211 end Wip_Flow_Utilities;