[Home] [Help]
PACKAGE: APPS.OUTSIDE_PROC_SV
Source
1 PACKAGE outside_proc_sv AUTHID CURRENT_USER AS
2 /* $Header: POXOPROS.pls 115.5 2002/11/23 03:02:34 sbull ship $*/
3
4 /*===========================================================================
5 PROCEDURE NAME: get_entity_default
6
7 DESCRIPTION: defaults the values for the Job
8
9 PARAMETERS: x_entity_id
10 x_dest_org_id
11 x_entity_name
12 x_entity_type
13
14 DESIGN REFERENCES: ../POXPOMPO.doc
15
16
17 ALGORITHM:
18
19 NOTES:
20 OPEN ISSUES:
21
22 CLOSED ISSUES:
23
24 CHANGE HISTORY: ALOCATEL Last Change on 7/12
25 ===========================================================================*/
26
27 PROCEDURE get_entity_defaults (x_entity_id IN NUMBER,
28 x_dest_org_id IN NUMBER,
29 x_entity_name IN OUT NOCOPY VARCHAR2,
30 x_entity_type IN OUT NOCOPY VARCHAR2);
31
32 PROCEDURE test_get_entity_defaults (x_entity_id IN NUMBER,
33 x_dest_org_id IN NUMBER);
34
35
36
37 /*===========================================================================
38 PROCEDURE NAME: get_wip_line_defaults
39
40 DESCRIPTION: Defaults the values for the line
41
42 PARAMETERS: x_entity_id
43 x_dest_org_id
44 x_entity_name
45 x_entity_type
46
47 DESIGN REFERENCES: ../POXPOMPO.doc
48
49
50 ALGORITHM:
51
52 NOTES:
53 OPEN ISSUES:
54
55 CLOSED ISSUES:
56
57 CHANGE HISTORY: ALOCATEL Last Change on 7/12
58 ===========================================================================*/
59
60 PROCEDURE get_wip_line_defaults (x_line_id IN NUMBER,
61 x_dest_org_id IN NUMBER,
62 x_wip_line_code IN OUT NOCOPY VARCHAR2);
63
64
65 PROCEDURE test_get_wip_line_defaults (x_line_id IN NUMBER,
66 x_dest_org_id IN NUMBER);
67
68
69 /*===========================================================================
70 PROCEDURE NAME: get_operation_defaults
71
72 DESCRIPTION: Defaults the values for the Operation
73
74 PARAMETERS: x_entity_id
75 x_dest_org_id
76 x_entity_name
77 x_entity_type
78
79 DESIGN REFERENCES: ../POXPOMPO.doc
80
81
82 ALGORITHM:
83
84 NOTES:
85 OPEN ISSUES:
86
87 CLOSED ISSUES:
88
89 CHANGE HISTORY: ALOCATEL Last Change on 7/12
90 ===========================================================================*/
91
92 PROCEDURE get_operation_defaults(x_wip_repetitive_schedule_id IN NUMBER,
93 x_wip_operation_seq_num IN NUMBER,
94 x_entity_id IN NUMBER,
95 x_dest_org_id IN NUMBER,
96 x_bom_department_code IN OUT NOCOPY VARCHAR2,
97 x_wip_operation_code IN OUT NOCOPY VARCHAR2);
98
99 /*===========================================================================
100 PROCEDURE NAME: get_resource_defaults
101
102 DESCRIPTION: Defaults the values for the Resource
103
104 PARAMETERS: x_entity_id
105 x_dest_org_id
106 x_entity_name
107 x_entity_type
108
109 DESIGN REFERENCES: ../POXPOMPO.doc
110
111
112 ALGORITHM:
113
114 NOTES:
115 OPEN ISSUES:
116
117 CLOSED ISSUES:
118
119 CHANGE HISTORY: ALOCATEL Last Change on 7/12
120 ===========================================================================*/
121
122 PROCEDURE get_resource_defaults(x_bom_resource_id IN NUMBER,
123 x_dest_org_id IN NUMBER,
124 x_bom_resource_code IN OUT NOCOPY VARCHAR2,
125 x_bom_resource_unit IN OUT NOCOPY VARCHAR2,
126 x_bom_cost_element_id IN OUT NOCOPY NUMBER);
127
128 /*===========================================================================
129 PROCEDURE NAME: calc_assy_res_qty
130
131 DESCRIPTION: Defaults the values for the Assembly and Resource
132 quantities
133
134 PARAMETERS: x_quantity_ordered
135 x_wip_repetitive_schedule_id
136 x_wip_operation_seq_num
137 x_wip_resource_seq_num
138 x_entity_id
139 x_dest_org_id
140 x_usage_rate_or_amount
141 x_assembly_quantity
142 x_resource_quantity
143
144 DESIGN REFERENCES: ../POXPOMPO.doc
145
146
147 ALGORITHM:
148
149 NOTES:
150 OPEN ISSUES:
151
152 CLOSED ISSUES:
153
154 CHANGE HISTORY: ALOCATEL Last Change on 7/12
155 ===========================================================================*/
156
157 PROCEDURE calc_assy_res_qty(x_outside_op_uom_type IN VARCHAR2,
158 x_quantity_ordered IN NUMBER,
159 x_wip_repetitive_schedule_id IN NUMBER,
160 x_wip_operation_seq_num IN NUMBER,
161 x_wip_resource_seq_num IN NUMBER,
162 x_entity_id IN NUMBER,
163 x_dest_org_id IN NUMBER,
164 x_usage_rate_or_amount IN OUT NOCOPY NUMBER,
165 x_assembly_quantity IN OUT NOCOPY NUMBER,
166 x_resource_quantity IN OUT NOCOPY NUMBER);
167
168
169 /*===========================================================================
170 PROCEDURE NAME: get_unit_type
171
172 DESCRIPTION: x_op_uom_type_dsp
173 x_op_uom_type
174
175 PARAMETERS:
176
177 DESIGN REFERENCES: ../POXPOMPO.doc
178
179
180 ALGORITHM:
181
182 NOTES:
183 OPEN ISSUES:
184
185 CLOSED ISSUES:
186
187 CHANGE HISTORY: ALOCATEL Last Change on 7/12
188 ===========================================================================*/
189
190 PROCEDURE get_unit_type (x_op_uom_type_dsp IN VARCHAR2,
191 x_op_uom_type IN OUT NOCOPY VARCHAR2);
192
193 PROCEDURE test_get_unit_type (x_op_uom_type_dsp IN VARCHAR2);
194
195 PROCEDURE get_project_task_num(x_project_id IN NUMBER,
196 x_task_id IN NUMBER,
197 x_project IN OUT NOCOPY VARCHAR2,
198 x_task IN OUT NOCOPY VARCHAR2);
199
200
201 /*===========================================================================
202 FUNCTION NAME: prj_id_to_num
203
204 DESCRIPTION: This function returns project number for the input
205 project_id. It reads both the PA projects as well as
206 PJM.
207
208 PARAMETERS: X_project_id in number
209
210 DESIGN REFERENCES:
211
212 ALGORITHM:
213
214 NOTES: Created for the code fix on bug 1793862
215
219
216 OPEN ISSUES:
217
218 CLOSED ISSUES:
220 CHANGE HISTORY: SKTIWARI Created on 31-AUG-2001
221 ===========================================================================*/
222 FUNCTION prj_id_to_num (X_project_id in number) return varchar2;
223
224 end outside_proc_sv;