The following lines contain the word 'select', 'insert', 'update' or 'delete':
| when user presses Update/Next (only if Online Validation is disabled).
|
| If you want to enable custom rebuilds in Expenses Entry Allocations page,
| when Online Validation is disabled, modify this function to:
|
| return 1 - if you want to enable custom builds
| return 0 - if you do not want to enable custom builds
|
| If Online Validation is enabled, custom rebuilds can be performed
| in BuildAccount (when p_build_mode = C_VALIDATE).
|
| If Online Validation is disabled, custom rebuilds can be performed
| in BuildAccount, as follows:
| (1) in Expenses Entry Allocations page (when p_build_mode = C_CUSTOM_BUILD_ONLY)
| (2) in Expenses Workflow AP Server Side Validation (when p_build_mode = C_VALIDATE)
|
| MODIFICATION HISTORY
| Date Author Description of Changes
| 25-Aug-2005 R Langi Created
|
*=======================================================================*/
FUNCTION GetIsCustomBuildOnly RETURN NUMBER
IS
BEGIN
-- if you want to enable custom builds
--return 1;
| (1) When user presses Update/Next on Expense Allocations page:
| - rebuilds/validates user modified distributions
|
| PARAMETERS
| p_report_header_id - contains report header id
| p_report_line_id - contains report line id
| p_employee_id - contains the employee id
| p_cost_center - NULL in this case
| p_exp_type_parameter_id - NULL in this case
| p_segments - contains the expense report line segments
| p_ccid - NULL in this case
| p_build_mode - AP_WEB_ACCTG_PKG.C_VALIDATE
| p_new_segments - returns the new expense report line segments
| p_new_ccid - returns the new expense report line code combination id
| p_return_error_message - returns any error message if an error occurred
|
|
| When Expense Entry Allocations is enabled without Online Validation:
| (1) When user presses Update/Next on Expense Allocations page:
| - rebuilds user modified distributions
|
| PARAMETERS
| p_report_header_id - contains report header id
| p_report_line_id - contains report line id
| p_employee_id - contains the employee id
| p_cost_center - NULL in this case
| p_exp_type_parameter_id - NULL in this case
| p_segments - contains the expense report line segments
| p_ccid - NULL in this case
| p_build_mode - AP_WEB_ACCTG_PKG.C_CUSTOM_BUILD_ONLY
| p_new_segments - returns the new expense report line segments
| p_new_ccid - returns the new expense report line code combination id
| p_return_error_message - returns any error message if an error occurred
|
| (2) Expenses Workflow AP Server Side Validation
| - validates user modified distributions
|
| PARAMETERS
| p_report_header_id - contains report header id
| p_report_line_id - contains report line id
| p_employee_id - contains the employee id
| p_cost_center - contains the expense report cost center
| p_exp_type_parameter_id - contains the expense type parameter id
| p_segments - contains the expense report line segments
| p_ccid - NULL in this case
| p_build_mode - AP_WEB_ACCTG_PKG.C_VALIDATE
| p_new_segments - returns the new expense report line segments
| p_new_ccid - returns the new expense report line code combination id
| p_return_error_message - returns any error message if an error occurred
|
|
| When Expense Entry Allocations is disabled:
| (1) Expenses Workflow AP Server Side Validation
|
| PARAMETERS
| p_report_header_id - contains report header id
| p_report_line_id - contains report line id
| p_employee_id - contains the employee id
| p_cost_center - contains the expense report cost center
| p_exp_type_parameter_id - contains the expense type parameter id
| p_segments - NULL in this case
| p_ccid - NULL in this case
| p_build_mode - AP_WEB_ACCTG_PKG.C_DEFAULT_VALIDATE
| p_new_segments - returns the new expense report line segments
| p_new_ccid - returns the new expense report line code combination id
| p_return_error_message - returns any error message if an error occurred
|
|
| When Expense Type is changed by Auditor:
| (1) Expenses Audit
|
| PARAMETERS
| p_report_header_id - contains report header id
| p_report_line_id - contains report line id
| p_employee_id - contains the employee id
| p_cost_center - contains the expense report cost center
| p_exp_type_parameter_id - contains the expense type parameter id
| p_segments - NULL in this case
| p_ccid - contains the expense report line code combination id
| p_build_mode - AP_WEB_ACCTG_PKG.C_BUILD_VALIDATE
| p_new_segments - returns the new expense report line segments
| p_new_ccid - returns the new expense report line code combination id
| p_return_error_message - returns any error message if an error occurred
|
|
| CALLS PROCEDURES/FUNCTIONS (local to this package body)
|
| RETURNS
| True if BuildAccount was customized
| False if BuildAccount was NOT customized
|
|
| MODIFICATION HISTORY
| Date Author Description of Changes
| 12-Aug-2005 R Langi Created
|
*=======================================================================*/
FUNCTION BuildAccount(
p_report_header_id IN NUMBER,
p_report_line_id IN NUMBER,
p_employee_id IN NUMBER,
p_cost_center IN VARCHAR2,
p_exp_type_parameter_id IN NUMBER,
p_segments IN AP_OIE_KFF_SEGMENTS_T,
p_ccid IN NUMBER,
p_build_mode IN VARCHAR2,
p_new_segments OUT NOCOPY AP_OIE_KFF_SEGMENTS_T,
p_new_ccid OUT NOCOPY NUMBER,
p_return_error_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
IS
BEGIN
/*
--
-- Insert logic to populate segments here
--
--
-- Insert logic to validate segments here
--
--
-- Insert logic to generate CCID here
--
return TRUE;