The following lines contain the word 'select', 'insert', 'update' or 'delete':
grouping method value of 'DELETE'. The client extension for calculating interest
using custom logic could identify these groups (by the value 'DELETE' in the grouping
method) and return a capital interest amount of zero, effectively eliminating the
associated expenditures from being used in the interest basis.
If multiple values are to be used to create a custom grouping method, it is recommended
that each column should be separated by a special character, e.g. a tilde (~). This
will simplify the processing of parsing these columns values out if desired.
*/
lv_return := 'ALL';
SELECT TO_CHAR(pcdl.dr_code_combination_id)
INTO lv_string
FROM pa_cost_distribution_lines_all pcdl
WHERE pcdl.line_num = p_line_num
AND pcdl.expenditure_item_id = p_expenditure_item_id;
The client extension CALCULATE_CAP_INTEREST can use this grouping method value DELETE to
identify these expenditures and return an interest amount of zero.
IF THEN
lv_return := 'DELETE';
'DELETE' in order to identify such expenditures. Setting the returned amount to zero effectively
excludes the associated expenditures from creating interest transactions.
IF p_grouping_method = 'DELETE' THEN
x_cap_int_amt := 0;