74:
75: -- For Order Level Totals
76: IF p_line_id IS NULL OR p_line_id = FND_API.G_MISS_NUM THEN
77:
78: OE_OE_TOTALS_SUMMARY.GLOBAL_TOTALS(p_header_id);
79: IF p_total_type = 'ALL' THEN
80:
81: RETURN(OE_OE_TOTALS_SUMMARY.ORDER_SUBTOTALS( p_header_id ) +
82: OE_OE_TOTALS_SUMMARY.Charges ( p_header_id ) +
77:
78: OE_OE_TOTALS_SUMMARY.GLOBAL_TOTALS(p_header_id);
79: IF p_total_type = 'ALL' THEN
80:
81: RETURN(OE_OE_TOTALS_SUMMARY.ORDER_SUBTOTALS( p_header_id ) +
82: OE_OE_TOTALS_SUMMARY.Charges ( p_header_id ) +
83: OE_OE_TOTALS_SUMMARY.Taxes ( p_header_id ));
84:
85: ELSIF p_total_type = 'LINES' THEN
78: OE_OE_TOTALS_SUMMARY.GLOBAL_TOTALS(p_header_id);
79: IF p_total_type = 'ALL' THEN
80:
81: RETURN(OE_OE_TOTALS_SUMMARY.ORDER_SUBTOTALS( p_header_id ) +
82: OE_OE_TOTALS_SUMMARY.Charges ( p_header_id ) +
83: OE_OE_TOTALS_SUMMARY.Taxes ( p_header_id ));
84:
85: ELSIF p_total_type = 'LINES' THEN
86:
79: IF p_total_type = 'ALL' THEN
80:
81: RETURN(OE_OE_TOTALS_SUMMARY.ORDER_SUBTOTALS( p_header_id ) +
82: OE_OE_TOTALS_SUMMARY.Charges ( p_header_id ) +
83: OE_OE_TOTALS_SUMMARY.Taxes ( p_header_id ));
84:
85: ELSIF p_total_type = 'LINES' THEN
86:
87: RETURN(OE_OE_TOTALS_SUMMARY.ORDER_SUBTOTALS( p_header_id ));
83: OE_OE_TOTALS_SUMMARY.Taxes ( p_header_id ));
84:
85: ELSIF p_total_type = 'LINES' THEN
86:
87: RETURN(OE_OE_TOTALS_SUMMARY.ORDER_SUBTOTALS( p_header_id ));
88:
89: ELSIF p_total_type = 'TAXES' THEN
90:
91: RETURN(OE_OE_TOTALS_SUMMARY.Taxes ( p_header_id ));
87: RETURN(OE_OE_TOTALS_SUMMARY.ORDER_SUBTOTALS( p_header_id ));
88:
89: ELSIF p_total_type = 'TAXES' THEN
90:
91: RETURN(OE_OE_TOTALS_SUMMARY.Taxes ( p_header_id ));
92:
93: ELSIF p_total_type = 'CHARGES' THEN
94:
95: RETURN(OE_OE_TOTALS_SUMMARY.Charges ( p_header_id ));
91: RETURN(OE_OE_TOTALS_SUMMARY.Taxes ( p_header_id ));
92:
93: ELSIF p_total_type = 'CHARGES' THEN
94:
95: RETURN(OE_OE_TOTALS_SUMMARY.Charges ( p_header_id ));
96: ELSE
97:
98: RETURN 0;
99: END IF;
203:
204: -- For Order Level Totals
205: IF p_line_id IS NULL OR p_line_id = FND_API.G_MISS_NUM THEN
206:
207: OE_OE_TOTALS_SUMMARY.GLOBAL_REC_TOTALS(p_header_id,p_charge_periodicity_code);
208: IF p_total_type = 'ALL' THEN
209:
210: RETURN(OE_OE_TOTALS_SUMMARY.REC_ORDER_SUBTOTALS( p_header_id ) +
211: OE_OE_TOTALS_SUMMARY.REC_Charges ( p_header_id,p_charge_periodicity_code ) +
206:
207: OE_OE_TOTALS_SUMMARY.GLOBAL_REC_TOTALS(p_header_id,p_charge_periodicity_code);
208: IF p_total_type = 'ALL' THEN
209:
210: RETURN(OE_OE_TOTALS_SUMMARY.REC_ORDER_SUBTOTALS( p_header_id ) +
211: OE_OE_TOTALS_SUMMARY.REC_Charges ( p_header_id,p_charge_periodicity_code ) +
212: OE_OE_TOTALS_SUMMARY.REC_Taxes ( p_header_id ));
213:
214: ELSIF p_total_type = 'LINES' THEN
207: OE_OE_TOTALS_SUMMARY.GLOBAL_REC_TOTALS(p_header_id,p_charge_periodicity_code);
208: IF p_total_type = 'ALL' THEN
209:
210: RETURN(OE_OE_TOTALS_SUMMARY.REC_ORDER_SUBTOTALS( p_header_id ) +
211: OE_OE_TOTALS_SUMMARY.REC_Charges ( p_header_id,p_charge_periodicity_code ) +
212: OE_OE_TOTALS_SUMMARY.REC_Taxes ( p_header_id ));
213:
214: ELSIF p_total_type = 'LINES' THEN
215:
208: IF p_total_type = 'ALL' THEN
209:
210: RETURN(OE_OE_TOTALS_SUMMARY.REC_ORDER_SUBTOTALS( p_header_id ) +
211: OE_OE_TOTALS_SUMMARY.REC_Charges ( p_header_id,p_charge_periodicity_code ) +
212: OE_OE_TOTALS_SUMMARY.REC_Taxes ( p_header_id ));
213:
214: ELSIF p_total_type = 'LINES' THEN
215:
216: RETURN(OE_OE_TOTALS_SUMMARY.REC_ORDER_SUBTOTALS( p_header_id ));
212: OE_OE_TOTALS_SUMMARY.REC_Taxes ( p_header_id ));
213:
214: ELSIF p_total_type = 'LINES' THEN
215:
216: RETURN(OE_OE_TOTALS_SUMMARY.REC_ORDER_SUBTOTALS( p_header_id ));
217:
218: ELSIF p_total_type = 'TAXES' THEN
219:
220: RETURN(OE_OE_TOTALS_SUMMARY.REC_Taxes ( p_header_id ));
216: RETURN(OE_OE_TOTALS_SUMMARY.REC_ORDER_SUBTOTALS( p_header_id ));
217:
218: ELSIF p_total_type = 'TAXES' THEN
219:
220: RETURN(OE_OE_TOTALS_SUMMARY.REC_Taxes ( p_header_id ));
221:
222: ELSIF p_total_type = 'CHARGES' THEN
223:
224: RETURN(OE_OE_TOTALS_SUMMARY.REC_Charges ( p_header_id,p_charge_periodicity_code ));
220: RETURN(OE_OE_TOTALS_SUMMARY.REC_Taxes ( p_header_id ));
221:
222: ELSIF p_total_type = 'CHARGES' THEN
223:
224: RETURN(OE_OE_TOTALS_SUMMARY.REC_Charges ( p_header_id,p_charge_periodicity_code ));
225: ELSE
226:
227: RETURN 0;
228: END IF;
288:
289: PROCEDURE GET_RECURRING_TOTALS
290: (
291: p_header_id IN NUMBER,
292: x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type)
293: IS
294: BEGIN
295: OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS(
296: p_header_id=>p_header_id,
291: p_header_id IN NUMBER,
292: x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type)
293: IS
294: BEGIN
295: OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS(
296: p_header_id=>p_header_id,
297: x_rec_charges_tbl=>x_rec_charges_tbl
298: );
299: EXCEPTION