5: /*----------------------------------------------------------------*/
6: /* procedure name: Get_TotalActCharges */
7: /* description : procedure used to get total actual charges */
8: /* */
9: /* p_api_version Standard IN param */
10: /* p_commit Standard IN param */
11: /* p_init_msg_list Standard IN param */
12: /* p_validation_level Standard IN param */
13: /* p_repair_line_id Repair Line ID to get act charges */
6: /* procedure name: Get_TotalActCharges */
7: /* description : procedure used to get total actual charges */
8: /* */
9: /* p_api_version Standard IN param */
10: /* p_commit Standard IN param */
11: /* p_init_msg_list Standard IN param */
12: /* p_validation_level Standard IN param */
13: /* p_repair_line_id Repair Line ID to get act charges */
14: /* x_charges Total MLE charges for repair line */
7: /* description : procedure used to get total actual charges */
8: /* */
9: /* p_api_version Standard IN param */
10: /* p_commit Standard IN param */
11: /* p_init_msg_list Standard IN param */
12: /* p_validation_level Standard IN param */
13: /* p_repair_line_id Repair Line ID to get act charges */
14: /* x_charges Total MLE charges for repair line */
15: /* x_return_status Standard OUT param */
8: /* */
9: /* p_api_version Standard IN param */
10: /* p_commit Standard IN param */
11: /* p_init_msg_list Standard IN param */
12: /* p_validation_level Standard IN param */
13: /* p_repair_line_id Repair Line ID to get act charges */
14: /* x_charges Total MLE charges for repair line */
15: /* x_return_status Standard OUT param */
16: /* x_msg_count Standard OUT param */
11: /* p_init_msg_list Standard IN param */
12: /* p_validation_level Standard IN param */
13: /* p_repair_line_id Repair Line ID to get act charges */
14: /* x_charges Total MLE charges for repair line */
15: /* x_return_status Standard OUT param */
16: /* x_msg_count Standard OUT param */
17: /* x_msg_data Standard OUT param */
18: /* */
19: /*----------------------------------------------------------------*/
12: /* p_validation_level Standard IN param */
13: /* p_repair_line_id Repair Line ID to get act charges */
14: /* x_charges Total MLE charges for repair line */
15: /* x_return_status Standard OUT param */
16: /* x_msg_count Standard OUT param */
17: /* x_msg_data Standard OUT param */
18: /* */
19: /*----------------------------------------------------------------*/
20: PROCEDURE Get_TotalActCharges
13: /* p_repair_line_id Repair Line ID to get act charges */
14: /* x_charges Total MLE charges for repair line */
15: /* x_return_status Standard OUT param */
16: /* x_msg_count Standard OUT param */
17: /* x_msg_data Standard OUT param */
18: /* */
19: /*----------------------------------------------------------------*/
20: PROCEDURE Get_TotalActCharges
21: (
33: /*----------------------------------------------------------------*/
34: /* procedure name: Get_TotalEstCharges */
35: /* description : procedure used to get total estimated charges */
36: /* */
37: /* p_api_version Standard IN param */
38: /* p_commit Standard IN param */
39: /* p_init_msg_list Standard IN param */
40: /* p_validation_level Standard IN param */
41: /* p_estimate_header_id Est Header ID to get est charges */
34: /* procedure name: Get_TotalEstCharges */
35: /* description : procedure used to get total estimated charges */
36: /* */
37: /* p_api_version Standard IN param */
38: /* p_commit Standard IN param */
39: /* p_init_msg_list Standard IN param */
40: /* p_validation_level Standard IN param */
41: /* p_estimate_header_id Est Header ID to get est charges */
42: /* x_charges Total MLE charges for repair line */
35: /* description : procedure used to get total estimated charges */
36: /* */
37: /* p_api_version Standard IN param */
38: /* p_commit Standard IN param */
39: /* p_init_msg_list Standard IN param */
40: /* p_validation_level Standard IN param */
41: /* p_estimate_header_id Est Header ID to get est charges */
42: /* x_charges Total MLE charges for repair line */
43: /* x_return_status Standard OUT param */
36: /* */
37: /* p_api_version Standard IN param */
38: /* p_commit Standard IN param */
39: /* p_init_msg_list Standard IN param */
40: /* p_validation_level Standard IN param */
41: /* p_estimate_header_id Est Header ID to get est charges */
42: /* x_charges Total MLE charges for repair line */
43: /* x_return_status Standard OUT param */
44: /* x_msg_count Standard OUT param */
39: /* p_init_msg_list Standard IN param */
40: /* p_validation_level Standard IN param */
41: /* p_estimate_header_id Est Header ID to get est charges */
42: /* x_charges Total MLE charges for repair line */
43: /* x_return_status Standard OUT param */
44: /* x_msg_count Standard OUT param */
45: /* x_msg_data Standard OUT param */
46: /* */
47: /*----------------------------------------------------------------*/
40: /* p_validation_level Standard IN param */
41: /* p_estimate_header_id Est Header ID to get est charges */
42: /* x_charges Total MLE charges for repair line */
43: /* x_return_status Standard OUT param */
44: /* x_msg_count Standard OUT param */
45: /* x_msg_data Standard OUT param */
46: /* */
47: /*----------------------------------------------------------------*/
48: PROCEDURE Get_TotalEstCharges
41: /* p_estimate_header_id Est Header ID to get est charges */
42: /* x_charges Total MLE charges for repair line */
43: /* x_return_status Standard OUT param */
44: /* x_msg_count Standard OUT param */
45: /* x_msg_data Standard OUT param */
46: /* */
47: /*----------------------------------------------------------------*/
48: PROCEDURE Get_TotalEstCharges
49: (
62: /* procedure name: Compare_EstChargesAndCosts */
63: /* description : procedure used to compare estimated charges to */
64: /* estimated costs */
65: /* */
66: /* p_api_version Standard IN param */
67: /* p_commit Standard IN param */
68: /* p_init_msg_list Standard IN param */
69: /* p_validation_level Standard IN param */
70: /* p_estimate_header_id Est Header ID to get est charges */
63: /* description : procedure used to compare estimated charges to */
64: /* estimated costs */
65: /* */
66: /* p_api_version Standard IN param */
67: /* p_commit Standard IN param */
68: /* p_init_msg_list Standard IN param */
69: /* p_validation_level Standard IN param */
70: /* p_estimate_header_id Est Header ID to get est charges */
71: /* p_charges Total MLE charges for estimate */
64: /* estimated costs */
65: /* */
66: /* p_api_version Standard IN param */
67: /* p_commit Standard IN param */
68: /* p_init_msg_list Standard IN param */
69: /* p_validation_level Standard IN param */
70: /* p_estimate_header_id Est Header ID to get est charges */
71: /* p_charges Total MLE charges for estimate */
72: /* x_costs MLE Costs for estimate */
65: /* */
66: /* p_api_version Standard IN param */
67: /* p_commit Standard IN param */
68: /* p_init_msg_list Standard IN param */
69: /* p_validation_level Standard IN param */
70: /* p_estimate_header_id Est Header ID to get est charges */
71: /* p_charges Total MLE charges for estimate */
72: /* x_costs MLE Costs for estimate */
73: /* x_profit MLE Profit */
71: /* p_charges Total MLE charges for estimate */
72: /* x_costs MLE Costs for estimate */
73: /* x_profit MLE Profit */
74: /* x_profit_margin MLE Profit Margin (%) */
75: /* x_return_status Standard OUT param */
76: /* x_msg_count Standard OUT param */
77: /* x_msg_data Standard OUT param */
78: /* */
79: /*----------------------------------------------------------------*/
72: /* x_costs MLE Costs for estimate */
73: /* x_profit MLE Profit */
74: /* x_profit_margin MLE Profit Margin (%) */
75: /* x_return_status Standard OUT param */
76: /* x_msg_count Standard OUT param */
77: /* x_msg_data Standard OUT param */
78: /* */
79: /*----------------------------------------------------------------*/
80: PROCEDURE Compare_EstChargesAndCosts
73: /* x_profit MLE Profit */
74: /* x_profit_margin MLE Profit Margin (%) */
75: /* x_return_status Standard OUT param */
76: /* x_msg_count Standard OUT param */
77: /* x_msg_data Standard OUT param */
78: /* */
79: /*----------------------------------------------------------------*/
80: PROCEDURE Compare_EstChargesAndCosts
81: (
97: /* procedure name: Compare_ActChargesAndCosts */
98: /* description : procedure used to compare actual charges to */
99: /* actual costs */
100: /* */
101: /* p_api_version Standard IN param */
102: /* p_commit Standard IN param */
103: /* p_init_msg_list Standard IN param */
104: /* p_validation_level Standard IN param */
105: /* p_repair_line_id Repair Line ID to get act charges */
98: /* description : procedure used to compare actual charges to */
99: /* actual costs */
100: /* */
101: /* p_api_version Standard IN param */
102: /* p_commit Standard IN param */
103: /* p_init_msg_list Standard IN param */
104: /* p_validation_level Standard IN param */
105: /* p_repair_line_id Repair Line ID to get act charges */
106: /* p_charges Total MLE charges for actuals */
99: /* actual costs */
100: /* */
101: /* p_api_version Standard IN param */
102: /* p_commit Standard IN param */
103: /* p_init_msg_list Standard IN param */
104: /* p_validation_level Standard IN param */
105: /* p_repair_line_id Repair Line ID to get act charges */
106: /* p_charges Total MLE charges for actuals */
107: /* x_costs MLE Costs for estimate */
100: /* */
101: /* p_api_version Standard IN param */
102: /* p_commit Standard IN param */
103: /* p_init_msg_list Standard IN param */
104: /* p_validation_level Standard IN param */
105: /* p_repair_line_id Repair Line ID to get act charges */
106: /* p_charges Total MLE charges for actuals */
107: /* x_costs MLE Costs for estimate */
108: /* x_profit MLE Profit */
106: /* p_charges Total MLE charges for actuals */
107: /* x_costs MLE Costs for estimate */
108: /* x_profit MLE Profit */
109: /* x_profit_margin MLE Profit Margin (%) */
110: /* x_return_status Standard OUT param */
111: /* x_msg_count Standard OUT param */
112: /* x_msg_data Standard OUT param */
113: /* */
114: /*----------------------------------------------------------------*/
107: /* x_costs MLE Costs for estimate */
108: /* x_profit MLE Profit */
109: /* x_profit_margin MLE Profit Margin (%) */
110: /* x_return_status Standard OUT param */
111: /* x_msg_count Standard OUT param */
112: /* x_msg_data Standard OUT param */
113: /* */
114: /*----------------------------------------------------------------*/
115: PROCEDURE Compare_ActChargesAndCosts
108: /* x_profit MLE Profit */
109: /* x_profit_margin MLE Profit Margin (%) */
110: /* x_return_status Standard OUT param */
111: /* x_msg_count Standard OUT param */
112: /* x_msg_data Standard OUT param */
113: /* */
114: /*----------------------------------------------------------------*/
115: PROCEDURE Compare_ActChargesAndCosts
116: (
132: /* procedure name: Compare_ActChargesAndCosts */
133: /* description : procedure used to compare actual charges to */
134: /* actual costs */
135: /* */
136: /* p_api_version Standard IN param */
137: /* p_commit Standard IN param */
138: /* p_init_msg_list Standard IN param */
139: /* p_validation_level Standard IN param */
140: /* p_repair_line_id Repair Line ID to get act charges */
133: /* description : procedure used to compare actual charges to */
134: /* actual costs */
135: /* */
136: /* p_api_version Standard IN param */
137: /* p_commit Standard IN param */
138: /* p_init_msg_list Standard IN param */
139: /* p_validation_level Standard IN param */
140: /* p_repair_line_id Repair Line ID to get act charges */
141: /* p_charges Total MLE charges for actuals */
134: /* actual costs */
135: /* */
136: /* p_api_version Standard IN param */
137: /* p_commit Standard IN param */
138: /* p_init_msg_list Standard IN param */
139: /* p_validation_level Standard IN param */
140: /* p_repair_line_id Repair Line ID to get act charges */
141: /* p_charges Total MLE charges for actuals */
142: /* x_costs MLE Costs for estimate */
135: /* */
136: /* p_api_version Standard IN param */
137: /* p_commit Standard IN param */
138: /* p_init_msg_list Standard IN param */
139: /* p_validation_level Standard IN param */
140: /* p_repair_line_id Repair Line ID to get act charges */
141: /* p_charges Total MLE charges for actuals */
142: /* x_costs MLE Costs for estimate */
143: /* x_profit MLE Profit */
141: /* p_charges Total MLE charges for actuals */
142: /* x_costs MLE Costs for estimate */
143: /* x_profit MLE Profit */
144: /* x_profit_margin MLE Profit Margin (%) */
145: /* x_return_status Standard OUT param */
146: /* x_msg_count Standard OUT param */
147: /* x_msg_data Standard OUT param */
148: /* */
149: /*----------------------------------------------------------------*/
142: /* x_costs MLE Costs for estimate */
143: /* x_profit MLE Profit */
144: /* x_profit_margin MLE Profit Margin (%) */
145: /* x_return_status Standard OUT param */
146: /* x_msg_count Standard OUT param */
147: /* x_msg_data Standard OUT param */
148: /* */
149: /*----------------------------------------------------------------*/
150: PROCEDURE Compare_EstAndActCharges
143: /* x_profit MLE Profit */
144: /* x_profit_margin MLE Profit Margin (%) */
145: /* x_return_status Standard OUT param */
146: /* x_msg_count Standard OUT param */
147: /* x_msg_data Standard OUT param */
148: /* */
149: /*----------------------------------------------------------------*/
150: PROCEDURE Compare_EstAndActCharges
151: (
169: /* description : procedure used get item cost, extended cost, */
170: /* profit, and profit margin (%) */
171: /* for an inventory item */
172: /* */
173: /* p_api_version Standard IN param */
174: /* p_commit Standard IN param */
175: /* p_init_msg_list Standard IN param */
176: /* p_validation_level Standard IN param */
177: /* p_inventory_item_id Inventory Item ID */
170: /* profit, and profit margin (%) */
171: /* for an inventory item */
172: /* */
173: /* p_api_version Standard IN param */
174: /* p_commit Standard IN param */
175: /* p_init_msg_list Standard IN param */
176: /* p_validation_level Standard IN param */
177: /* p_inventory_item_id Inventory Item ID */
178: /* p_quantity Quantity of Inventory Items */
171: /* for an inventory item */
172: /* */
173: /* p_api_version Standard IN param */
174: /* p_commit Standard IN param */
175: /* p_init_msg_list Standard IN param */
176: /* p_validation_level Standard IN param */
177: /* p_inventory_item_id Inventory Item ID */
178: /* p_quantity Quantity of Inventory Items */
179: /* p_organization_id Inventory Organization ID */
172: /* */
173: /* p_api_version Standard IN param */
174: /* p_commit Standard IN param */
175: /* p_init_msg_list Standard IN param */
176: /* p_validation_level Standard IN param */
177: /* p_inventory_item_id Inventory Item ID */
178: /* p_quantity Quantity of Inventory Items */
179: /* p_organization_id Inventory Organization ID */
180: /* p_charge_amt Total Charge Amt to compare to */
182: /* x_item_cost Item cost of Inv Item */
183: /* x_total_cost Extended cost of Inv Item */
184: /* x_profit x_total_cost - p_charge_amt */
185: /* x_profit_margin x_profit*100/x_item_cost */
186: /* x_return_status Standard OUT param */
187: /* x_msg_count Standard OUT param */
188: /* x_msg_data Standard OUT param */
189: /* */
190: /*----------------------------------------------------------------*/
183: /* x_total_cost Extended cost of Inv Item */
184: /* x_profit x_total_cost - p_charge_amt */
185: /* x_profit_margin x_profit*100/x_item_cost */
186: /* x_return_status Standard OUT param */
187: /* x_msg_count Standard OUT param */
188: /* x_msg_data Standard OUT param */
189: /* */
190: /*----------------------------------------------------------------*/
191: PROCEDURE Get_InvItemCostAnalysis
184: /* x_profit x_total_cost - p_charge_amt */
185: /* x_profit_margin x_profit*100/x_item_cost */
186: /* x_return_status Standard OUT param */
187: /* x_msg_count Standard OUT param */
188: /* x_msg_data Standard OUT param */
189: /* */
190: /*----------------------------------------------------------------*/
191: PROCEDURE Get_InvItemCostAnalysis
192: (
213: /* description : procedure used get item cost, extended cost, */
214: /* profit, and profit margin (%) */
215: /* for a bom resource */
216: /* */
217: /* p_api_version Standard IN param */
218: /* p_commit Standard IN param */
219: /* p_init_msg_list Standard IN param */
220: /* p_validation_level Standard IN param */
221: /* p_bom_resource_id BOM Resource ID */
214: /* profit, and profit margin (%) */
215: /* for a bom resource */
216: /* */
217: /* p_api_version Standard IN param */
218: /* p_commit Standard IN param */
219: /* p_init_msg_list Standard IN param */
220: /* p_validation_level Standard IN param */
221: /* p_bom_resource_id BOM Resource ID */
222: /* p_quantity Quantity of resource */
215: /* for a bom resource */
216: /* */
217: /* p_api_version Standard IN param */
218: /* p_commit Standard IN param */
219: /* p_init_msg_list Standard IN param */
220: /* p_validation_level Standard IN param */
221: /* p_bom_resource_id BOM Resource ID */
222: /* p_quantity Quantity of resource */
223: /* p_organization_id Inventory Organization ID */
216: /* */
217: /* p_api_version Standard IN param */
218: /* p_commit Standard IN param */
219: /* p_init_msg_list Standard IN param */
220: /* p_validation_level Standard IN param */
221: /* p_bom_resource_id BOM Resource ID */
222: /* p_quantity Quantity of resource */
223: /* p_organization_id Inventory Organization ID */
224: /* p_charge_amt Total Charge Amt to compare to */
226: /* x_item_cost Resource rate of BOM resource */
227: /* x_total_cost Extended cost of Resource */
228: /* x_profit x_total_cost - p_charge_amt */
229: /* x_profit_margin x_profit*100/x_item_cost */
230: /* x_return_status Standard OUT param */
231: /* x_msg_count Standard OUT param */
232: /* x_msg_data Standard OUT param */
233: /* */
234: /*----------------------------------------------------------------*/
227: /* x_total_cost Extended cost of Resource */
228: /* x_profit x_total_cost - p_charge_amt */
229: /* x_profit_margin x_profit*100/x_item_cost */
230: /* x_return_status Standard OUT param */
231: /* x_msg_count Standard OUT param */
232: /* x_msg_data Standard OUT param */
233: /* */
234: /*----------------------------------------------------------------*/
235: PROCEDURE Get_ResItemCostAnalysis
228: /* x_profit x_total_cost - p_charge_amt */
229: /* x_profit_margin x_profit*100/x_item_cost */
230: /* x_return_status Standard OUT param */
231: /* x_msg_count Standard OUT param */
232: /* x_msg_data Standard OUT param */
233: /* */
234: /*----------------------------------------------------------------*/
235: PROCEDURE Get_ResItemCostAnalysis
236: (