[Home] [Help]
PACKAGE: APPS.GMD_VALIDITY_RULES
Source
1 PACKAGE GMD_VALIDITY_RULES AS
2 /* $Header: GMDPRVRS.pls 120.3.12000000.1 2007/01/16 18:21:33 appldev ship $ */
3
4
5 TYPE gmd_val_rules_out IS RECORD
6 ( recipe_validity_rule_id gmd_recipe_validity_rules.recipe_validity_rule_id%type ,
7 recipe_id gmd_recipe_validity_rules.recipe_id%type ,
8 orgn_code gmd_recipe_validity_rules.orgn_code%type ,
9 -- NPD Conv. Added organization_id, revision. Modified item_id to inventory_item_id.
10 organization_id gmd_recipe_validity_rules.organization_id%type ,
11 revision gmd_recipe_validity_rules.revision%type ,
12 inventory_item_id gmd_recipe_validity_rules.inventory_item_id%type ,
13 -- End NPD Conv.
14 recipe_use gmd_recipe_validity_rules.recipe_use%type ,
15 preference gmd_recipe_validity_rules.preference%type ,
16 start_date gmd_recipe_validity_rules.start_date%type ,
17 end_date gmd_recipe_validity_rules.end_date%type ,
18 min_qty gmd_recipe_validity_rules.min_qty%type ,
19 max_qty gmd_recipe_validity_rules.max_qty%type ,
20 std_qty gmd_recipe_validity_rules.std_qty%type ,
21 -- NPD Conv. Changed item_um to detail_uom
22 detail_uom gmd_recipe_validity_rules.detail_uom%type ,
23 -- End NPD Conv.
24 inv_min_qty gmd_recipe_validity_rules.inv_min_qty%type ,
25 inv_max_qty gmd_recipe_validity_rules.inv_max_qty%type ,
26 planned_process_loss gmd_recipe_validity_rules.planned_process_loss%type ,
27 validity_rule_status gmd_recipe_validity_rules.validity_rule_status%type ,
28 --lab_type gmd_recipe_validity_rules.lab_type%type ,
29 formula_id NUMBER ,
30 routing_id NUMBER ,
31 unit_cost NUMBER ,
32 total_cost NUMBER ,
33 text_code gmd_recipe_validity_rules.text_code%type ,
34 created_by gmd_recipe_validity_rules.created_by%type ,
35 last_updated_by gmd_recipe_validity_rules.last_updated_by%type ,
36 last_update_date gmd_recipe_validity_rules.last_update_date%type ,
37 creation_date gmd_recipe_validity_rules.creation_date%type ,
38 last_update_login gmd_recipe_validity_rules.last_update_login%type ,
39 attribute_category gmd_recipe_validity_rules.attribute_category%type ,
40 attribute1 gmd_recipe_validity_rules.attribute1%type ,
41 attribute2 gmd_recipe_validity_rules.attribute2%type ,
42 attribute3 gmd_recipe_validity_rules.attribute3%type ,
43 attribute4 gmd_recipe_validity_rules.attribute4%type ,
44 attribute5 gmd_recipe_validity_rules.attribute5%type ,
45 attribute6 gmd_recipe_validity_rules.attribute6%type ,
46 attribute7 gmd_recipe_validity_rules.attribute7%type ,
47 attribute8 gmd_recipe_validity_rules.attribute8%type ,
48 attribute9 gmd_recipe_validity_rules.attribute9%type ,
49 attribute10 gmd_recipe_validity_rules.attribute10%type ,
50 attribute11 gmd_recipe_validity_rules.attribute11%type ,
51 attribute12 gmd_recipe_validity_rules.attribute12%type ,
52 attribute13 gmd_recipe_validity_rules.attribute13%type ,
53 attribute14 gmd_recipe_validity_rules.attribute14%type ,
54 attribute15 gmd_recipe_validity_rules.attribute15%type ,
55 attribute16 gmd_recipe_validity_rules.attribute16%type ,
56 attribute17 gmd_recipe_validity_rules.attribute17%type ,
57 attribute18 gmd_recipe_validity_rules.attribute18%type ,
58 attribute19 gmd_recipe_validity_rules.attribute19%type ,
59 attribute20 gmd_recipe_validity_rules.attribute20%type ,
60 attribute21 gmd_recipe_validity_rules.attribute21%type ,
61 attribute22 gmd_recipe_validity_rules.attribute22%type ,
62 attribute23 gmd_recipe_validity_rules.attribute23%type ,
63 attribute24 gmd_recipe_validity_rules.attribute24%type ,
64 attribute25 gmd_recipe_validity_rules.attribute25%type ,
65 attribute26 gmd_recipe_validity_rules.attribute26%type ,
66 attribute27 gmd_recipe_validity_rules.attribute27%type ,
67 attribute28 gmd_recipe_validity_rules.attribute28%type ,
68 attribute29 gmd_recipe_validity_rules.attribute29%type ,
69 attribute30 gmd_recipe_validity_rules.attribute30%type
70
71 );
72
73 -- Record for finding Least Cost VR
74 TYPE least_cost_rec IS RECORD
75 (
76 recipe_validity_rule_id gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE,
77 unit_cost NUMBER,
78 total_cost NUMBER,
79 index_no NUMBER);
80
81 TYPE least_cost_tbl IS TABLE OF least_cost_rec
82 INDEX BY BINARY_INTEGER;
83
84 TYPE recipe_validity_tbl IS TABLE OF gmd_val_rules_out
85 INDEX BY BINARY_INTEGER;
86
87 -- NPD Conv. Added p_organization_id parameter.
88 PROCEDURE get_validity_rules(p_api_version IN NUMBER ,
89 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
90 p_recipe_no IN VARCHAR2 := NULL ,
91 p_recipe_version IN NUMBER := NULL ,
92 p_recipe_id IN NUMBER := NULL ,
93 p_total_input IN NUMBER := NULL ,
94 p_total_output IN NUMBER := NULL ,
95 p_formula_id IN NUMBER := NULL ,
96 p_item_id IN NUMBER := NULL ,
97 p_revision IN VARCHAR2 := NULL ,
98 p_item_no IN VARCHAR2 := NULL ,
99 p_product_qty IN NUMBER := NULL ,
100 p_uom IN VARCHAR2 := NULL ,
101 p_recipe_use IN VARCHAR2 := NULL ,
102 p_orgn_code IN VARCHAR2 := NULL ,
103 p_organization_id IN NUMBER := NULL ,
104 p_least_cost_validity IN VARCHAR2 := 'F' ,
105 p_start_date IN DATE := NULL ,
106 p_end_date IN DATE := NULL ,
107 p_status_type IN VARCHAR2 := NULL ,
108 p_validity_rule_id IN NUMBER := NULL ,
109 x_return_status OUT NOCOPY VARCHAR2 ,
110 x_msg_count OUT NOCOPY NUMBER ,
111 x_msg_data OUT NOCOPY VARCHAR2 ,
112 x_return_code OUT NOCOPY NUMBER ,
113 X_recipe_validity_out OUT NOCOPY recipe_validity_tbl);
114
115 PROCEDURE get_output_ratio(p_formula_id IN NUMBER,
116 p_batch_output IN NUMBER,
117 p_yield_um IN VARCHAR2,
118 p_formula_output IN NUMBER,
119 x_return_status OUT NOCOPY VARCHAR2,
120 X_output_ratio OUT NOCOPY NUMBER);
121
122 PROCEDURE get_ingredprod_ratio(p_formula_id IN NUMBER,
123 p_yield_um IN VARCHAR2,
124 X_ingred_prod_ratio OUT NOCOPY NUMBER,
125 x_return_status OUT NOCOPY VARCHAR2);
126
127 PROCEDURE get_batchformula_ratio(p_formula_id IN NUMBER,
128 p_batch_input IN NUMBER,
129 p_yield_um IN VARCHAR2,
130 p_formula_input IN NUMBER,
131 X_batchformula_ratio OUT NOCOPY NUMBER,
132 X_return_status OUT NOCOPY VARCHAR2);
133
134 PROCEDURE get_contributing_qty(p_formula_id IN NUMBER,
135 p_recipe_id IN NUMBER,
136 p_batchformula_ratio IN NUMBER,
137 p_yield_um IN VARCHAR2,
138 X_contributing_qty OUT NOCOPY NUMBER,
139 X_return_status OUT NOCOPY VARCHAR2);
140
141 PROCEDURE get_input_ratio(p_formula_id IN NUMBER,
142 p_contributing_qty IN NUMBER,
143 p_yield_um IN VARCHAR2,
144 p_formula_output IN NUMBER,
145 X_output_ratio OUT NOCOPY NUMBER,
146 X_return_status OUT NOCOPY VARCHAR2);
147
148 PROCEDURE uom_conversion_mesg(p_item_id IN NUMBER,
149 p_from_um IN VARCHAR2,
150 p_to_um IN VARCHAR2);
151 --BEGIN BUG#2436355 RajaSekhar
152 PROCEDURE get_all_validity_rules(p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154 p_recipe_id IN NUMBER := NULL,
155 p_item_id IN NUMBER := NULL,
156 p_revision IN VARCHAR2 := NULL,
157 p_least_cost_validity IN VARCHAR2 := 'F',
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 x_return_code OUT NOCOPY NUMBER,
162 X_recipe_validity_out OUT NOCOPY recipe_validity_tbl);
163 --END BUG#2436355
164
165 PROCEDURE get_validity_scale_factor(p_recipe_id IN NUMBER ,
166 p_item_id IN NUMBER ,
167 p_std_qty IN NUMBER ,
168 p_std_um IN VARCHAR2 ,
169 x_scale_factor OUT NOCOPY NUMBER,
170 x_return_status OUT NOCOPY VARCHAR2);
171
172 PROCEDURE get_validity_output_factor(p_recipe_id IN NUMBER ,
173 p_item_id IN NUMBER ,
174 p_std_qty IN NUMBER ,
175 p_std_um IN VARCHAR2 ,
176 x_scale_factor OUT NOCOPY NUMBER,
177 x_return_status OUT NOCOPY VARCHAR2);
178
179 PROCEDURE insert_val_temp_tbl (p_val_rec IN GMD_RECIPE_VALIDITY_RULES%ROWTYPE
180 ,p_unit_cost IN NUMBER
181 ,p_total_cost IN NUMBER);
182
183 PROCEDURE Get_Formula_Cost (
184 p_formula_id IN NUMBER,
185 p_requested_qty IN NUMBER,
186 p_requested_uom IN VARCHAR2,
187 p_product_id IN NUMBER,
188 p_organization_id IN NUMBER,
189 X_unit_cost OUT NOCOPY NUMBER,
190 X_total_cost OUT NOCOPY NUMBER,
191 X_return_status OUT NOCOPY VARCHAR2);
192
193 END GMD_VALIDITY_RULES;