32: /* procedure name: Convert_CurrencyAmount */
33: /* description : Converts an amount from one currency to */
34: /* another currency */
35: /* */
36: /* p_api_version Standard IN param */
37: /* p_commit Standard IN param */
38: /* p_init_msg_list Standard IN param */
39: /* p_validation_level Standard IN param */
40: /* p_from_currency Currency code to convert from */
33: /* description : Converts an amount from one currency to */
34: /* another currency */
35: /* */
36: /* p_api_version Standard IN param */
37: /* p_commit Standard IN param */
38: /* p_init_msg_list Standard IN param */
39: /* p_validation_level Standard IN param */
40: /* p_from_currency Currency code to convert from */
41: /* p_to_currency Currency code to convert to */
34: /* another currency */
35: /* */
36: /* p_api_version Standard IN param */
37: /* p_commit Standard IN param */
38: /* p_init_msg_list Standard IN param */
39: /* p_validation_level Standard IN param */
40: /* p_from_currency Currency code to convert from */
41: /* p_to_currency Currency code to convert to */
42: /* p_eff_date Conversion Date */
35: /* */
36: /* p_api_version Standard IN param */
37: /* p_commit Standard IN param */
38: /* p_init_msg_list Standard IN param */
39: /* p_validation_level Standard IN param */
40: /* p_from_currency Currency code to convert from */
41: /* p_to_currency Currency code to convert to */
42: /* p_eff_date Conversion Date */
43: /* p_amount Amount to convert */
42: /* p_eff_date Conversion Date */
43: /* p_amount Amount to convert */
44: /* p_conv_type Conversion type */
45: /* x_conv_amount Converted amount */
46: /* x_return_status Standard OUT param */
47: /* x_msg_count Standard OUT param */
48: /* x_msg_data Standard OUT param */
49: /* */
50: /*----------------------------------------------------------------*/
43: /* p_amount Amount to convert */
44: /* p_conv_type Conversion type */
45: /* x_conv_amount Converted amount */
46: /* x_return_status Standard OUT param */
47: /* x_msg_count Standard OUT param */
48: /* x_msg_data Standard OUT param */
49: /* */
50: /*----------------------------------------------------------------*/
51: PROCEDURE Convert_CurrencyAmount (
44: /* p_conv_type Conversion type */
45: /* x_conv_amount Converted amount */
46: /* x_return_status Standard OUT param */
47: /* x_msg_count Standard OUT param */
48: /* x_msg_data Standard OUT param */
49: /* */
50: /*----------------------------------------------------------------*/
51: PROCEDURE Convert_CurrencyAmount (
52: p_api_version IN NUMBER,
68: /* procedure name: Get_TotalActCosts */
69: /* description : Given a repair line id, gets the total MLE */
70: /* actual costs. */
71: /* */
72: /* p_api_version Standard IN param */
73: /* p_commit Standard IN param */
74: /* p_init_msg_list Standard IN param */
75: /* p_validation_level Standard IN param */
76: /* p_repair_line_id Repair Line ID to get actual costs*/
69: /* description : Given a repair line id, gets the total MLE */
70: /* actual costs. */
71: /* */
72: /* p_api_version Standard IN param */
73: /* p_commit Standard IN param */
74: /* p_init_msg_list Standard IN param */
75: /* p_validation_level Standard IN param */
76: /* p_repair_line_id Repair Line ID to get actual costs*/
77: /* p_currency_code Currency to convert costs to */
70: /* actual costs. */
71: /* */
72: /* p_api_version Standard IN param */
73: /* p_commit Standard IN param */
74: /* p_init_msg_list Standard IN param */
75: /* p_validation_level Standard IN param */
76: /* p_repair_line_id Repair Line ID to get actual costs*/
77: /* p_currency_code Currency to convert costs to */
78: /* x_costs Total MLE costs for repair line */
71: /* */
72: /* p_api_version Standard IN param */
73: /* p_commit Standard IN param */
74: /* p_init_msg_list Standard IN param */
75: /* p_validation_level Standard IN param */
76: /* p_repair_line_id Repair Line ID to get actual costs*/
77: /* p_currency_code Currency to convert costs to */
78: /* x_costs Total MLE costs for repair line */
79: /* x_return_status Standard OUT param */
75: /* p_validation_level Standard IN param */
76: /* p_repair_line_id Repair Line ID to get actual costs*/
77: /* p_currency_code Currency to convert costs to */
78: /* x_costs Total MLE costs for repair line */
79: /* x_return_status Standard OUT param */
80: /* x_msg_count Standard OUT param */
81: /* x_msg_data Standard OUT param */
82: /* */
83: /*----------------------------------------------------------------*/
76: /* p_repair_line_id Repair Line ID to get actual costs*/
77: /* p_currency_code Currency to convert costs to */
78: /* x_costs Total MLE costs for repair line */
79: /* x_return_status Standard OUT param */
80: /* x_msg_count Standard OUT param */
81: /* x_msg_data Standard OUT param */
82: /* */
83: /*----------------------------------------------------------------*/
84: PROCEDURE Get_TotalActCosts
77: /* p_currency_code Currency to convert costs to */
78: /* x_costs Total MLE costs for repair line */
79: /* x_return_status Standard OUT param */
80: /* x_msg_count Standard OUT param */
81: /* x_msg_data Standard OUT param */
82: /* */
83: /*----------------------------------------------------------------*/
84: PROCEDURE Get_TotalActCosts
85: (
100: /* procedure name: Get_TotalEstCosts */
101: /* description : Given an estimate header, gets the total MLE */
102: /* estimated costs. */
103: /* */
104: /* p_api_version Standard IN param */
105: /* p_commit Standard IN param */
106: /* p_init_msg_list Standard IN param */
107: /* p_validation_level Standard IN param */
108: /* p_estimate_header_id Est header ID to get est costs for*/
101: /* description : Given an estimate header, gets the total MLE */
102: /* estimated costs. */
103: /* */
104: /* p_api_version Standard IN param */
105: /* p_commit Standard IN param */
106: /* p_init_msg_list Standard IN param */
107: /* p_validation_level Standard IN param */
108: /* p_estimate_header_id Est header ID to get est costs for*/
109: /* p_currency_code Currency to convert costs to */
102: /* estimated costs. */
103: /* */
104: /* p_api_version Standard IN param */
105: /* p_commit Standard IN param */
106: /* p_init_msg_list Standard IN param */
107: /* p_validation_level Standard IN param */
108: /* p_estimate_header_id Est header ID to get est costs for*/
109: /* p_currency_code Currency to convert costs to */
110: /* x_costs Total MLE costs for repair line */
103: /* */
104: /* p_api_version Standard IN param */
105: /* p_commit Standard IN param */
106: /* p_init_msg_list Standard IN param */
107: /* p_validation_level Standard IN param */
108: /* p_estimate_header_id Est header ID to get est costs for*/
109: /* p_currency_code Currency to convert costs to */
110: /* x_costs Total MLE costs for repair line */
111: /* x_return_status Standard OUT param */
107: /* p_validation_level Standard IN param */
108: /* p_estimate_header_id Est header ID to get est costs for*/
109: /* p_currency_code Currency to convert costs to */
110: /* x_costs Total MLE costs for repair line */
111: /* x_return_status Standard OUT param */
112: /* x_msg_count Standard OUT param */
113: /* x_msg_data Standard OUT param */
114: /* */
115: /*----------------------------------------------------------------*/
108: /* p_estimate_header_id Est header ID to get est costs for*/
109: /* p_currency_code Currency to convert costs to */
110: /* x_costs Total MLE costs for repair line */
111: /* x_return_status Standard OUT param */
112: /* x_msg_count Standard OUT param */
113: /* x_msg_data Standard OUT param */
114: /* */
115: /*----------------------------------------------------------------*/
116: PROCEDURE Get_TotalEstCosts (
109: /* p_currency_code Currency to convert costs to */
110: /* x_costs Total MLE costs for repair line */
111: /* x_return_status Standard OUT param */
112: /* x_msg_count Standard OUT param */
113: /* x_msg_data Standard OUT param */
114: /* */
115: /*----------------------------------------------------------------*/
116: PROCEDURE Get_TotalEstCosts (
117: p_api_version IN NUMBER,
133: /* Percent is determined by dividing difference */
134: /* by the basis. If currencies are different, */
135: /* Difference will be in currency of compare amts */
136: /* */
137: /* p_api_version Standard IN param */
138: /* p_commit Standard IN param */
139: /* p_init_msg_list Standard IN param */
140: /* p_validation_level Standard IN param */
141: /* p_mle_totals_basis Totals to use as basis */
134: /* by the basis. If currencies are different, */
135: /* Difference will be in currency of compare amts */
136: /* */
137: /* p_api_version Standard IN param */
138: /* p_commit Standard IN param */
139: /* p_init_msg_list Standard IN param */
140: /* p_validation_level Standard IN param */
141: /* p_mle_totals_basis Totals to use as basis */
142: /* p_mle_totals_compare Totals to compare to basis */
135: /* Difference will be in currency of compare amts */
136: /* */
137: /* p_api_version Standard IN param */
138: /* p_commit Standard IN param */
139: /* p_init_msg_list Standard IN param */
140: /* p_validation_level Standard IN param */
141: /* p_mle_totals_basis Totals to use as basis */
142: /* p_mle_totals_compare Totals to compare to basis */
143: /* x_diff Basis - Compare */
136: /* */
137: /* p_api_version Standard IN param */
138: /* p_commit Standard IN param */
139: /* p_init_msg_list Standard IN param */
140: /* p_validation_level Standard IN param */
141: /* p_mle_totals_basis Totals to use as basis */
142: /* p_mle_totals_compare Totals to compare to basis */
143: /* x_diff Basis - Compare */
144: /* x_pct_diff (Basis - Compare)*100/Basis */
141: /* p_mle_totals_basis Totals to use as basis */
142: /* p_mle_totals_compare Totals to compare to basis */
143: /* x_diff Basis - Compare */
144: /* x_pct_diff (Basis - Compare)*100/Basis */
145: /* x_return_status Standard OUT param */
146: /* x_msg_count Standard OUT param */
147: /* x_msg_data Standard OUT param */
148: /* */
149: /*----------------------------------------------------------------*/
142: /* p_mle_totals_compare Totals to compare to basis */
143: /* x_diff Basis - Compare */
144: /* x_pct_diff (Basis - Compare)*100/Basis */
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_MLETotals (
143: /* x_diff Basis - Compare */
144: /* x_pct_diff (Basis - Compare)*100/Basis */
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_MLETotals (
151: p_api_version IN NUMBER,