1 PACKAGE AP_WEB_ACCTG_PKG AS
2 /* $Header: apwaccts.pls 120.8.12010000.2 2008/08/06 07:41:36 rveliche ship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 /*=======================================================================+
9 | BuildAccount values for p_build_mode
10 |
11 | C_DEFAULT
12 | - for defaulting new distribution segments in Expenses Entry Allocations page
13 | - for rebuilding distribution segments in Expenses Entry Allocations page
14 | when expense type or expense report header cost center has changed
15 | C_CUSTOM_BUILD_ONLY
16 | - for rebuilding distribution segments in Expenses Entry Allocations page
17 | when user presses Update/Next (Online Validation disabled)
18 | C_DEFAULT_VALIDATE
19 | - for defaulting/validating employee segments in Workflow AP Server Side Validation
20 | - for defaulting/validating distribution segments in Workflow AP Server Side Validation
21 | (LLA is disabled)
22 | C_BUILD_VALIDATE
23 | - for building/validating distribution segments in Audit
24 | when expense type has changed
25 | C_VALIDATE
26 | - for validating distribution segments (with a potential for rebuild):
27 | a. when user presses Update/Next in Expenses Entry Allocations page
28 | (Online Validation enabled)
29 | b. Workflow AP Server Side Validation (LLA is enabled without Online Validation)
30 |
31 +=======================================================================*/
32 C_DEFAULT CONSTANT VARCHAR2(30) := 'DEFAULT';
33 C_CUSTOM_BUILD_ONLY CONSTANT VARCHAR2(30) := 'CUSTOM_BUILD_ONLY';
34 C_DEFAULT_VALIDATE CONSTANT VARCHAR2(30) := 'DEFAULT_VALIDATE';
35 C_BUILD_VALIDATE CONSTANT VARCHAR2(30) := 'BUILD_VALIDATE';
36 C_VALIDATE CONSTANT VARCHAR2(30) := 'VALIDATE';
37
38
39 TYPE t_cost_center_segnum_table IS TABLE OF NUMBER
40 INDEX BY BINARY_INTEGER;
41
42 PROCEDURE GetEmployeeCostCenter(
43 p_employee_id IN NUMBER,
44 p_emp_ccid IN NUMBER,
45 p_cost_center OUT NOCOPY VARCHAR2);
46
47 FUNCTION GetCostCenter(
48 p_ccid IN NUMBER,
49 p_chart_of_accounts_id IN NUMBER DEFAULT NULL)
50 RETURN VARCHAR2;
51
52 PROCEDURE GetCostCenterApprovalRule(
53 p_alphanumeric_allowed_flag OUT NOCOPY VARCHAR2,
54 p_uppercase_only_flag OUT NOCOPY VARCHAR2,
55 p_numeric_mode_enabled_flag OUT NOCOPY VARCHAR2,
56 p_maximum_size OUT NOCOPY NUMBER);
57
58 PROCEDURE ValidateCostCenter(
59 p_cost_center IN VARCHAR2,
60 p_employee_id IN NUMBER,
61 p_emp_set_of_books_id IN NUMBER,
62 p_default_emp_ccid IN VARCHAR2,
63 p_chart_of_accounts_id IN NUMBER,
64 p_cost_center_valid OUT NOCOPY BOOLEAN);
65
66 PROCEDURE GetExpenseTypeCostCenter(
67 p_exp_type_parameter_id IN NUMBER,
68 p_cost_center OUT NOCOPY VARCHAR2);
69
70 PROCEDURE GetCostCenterSegmentName(
71 p_cost_center_segment_name OUT NOCOPY VARCHAR2);
72
73 PROCEDURE GetDistributionSegments(
74 p_chart_of_accounts_id IN GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE,
75 p_report_distribution_id IN NUMBER,
76 p_segments OUT NOCOPY AP_OIE_KFF_SEGMENTS_T);
77
78 PROCEDURE GetConcatenatedSegments(
79 p_chart_of_accounts_id IN NUMBER,
80 p_segments IN AP_OIE_KFF_SEGMENTS_T,
81 p_concatenated_segments OUT NOCOPY VARCHAR2);
82
83 PROCEDURE BuildAccount(
84 p_report_header_id IN NUMBER,
85 p_report_line_id IN NUMBER,
86 p_employee_id IN NUMBER,
87 p_cost_center IN VARCHAR2,
88 p_line_cost_center IN VARCHAR2,
89 p_exp_type_parameter_id IN NUMBER,
90 p_segments IN AP_OIE_KFF_SEGMENTS_T,
91 p_ccid IN NUMBER,
92 p_build_mode IN VARCHAR2,
93 p_new_segments OUT NOCOPY AP_OIE_KFF_SEGMENTS_T,
94 p_new_ccid OUT NOCOPY NUMBER,
95 p_return_error_message OUT NOCOPY VARCHAR2);
96
97 PROCEDURE BuildDistProjectAccount(
98 p_report_header_id IN NUMBER,
99 p_report_line_id IN NUMBER,
100 p_report_distribution_id IN NUMBER,
101 p_exp_type_parameter_id IN NUMBER,
102 p_new_segments OUT NOCOPY AP_OIE_KFF_SEGMENTS_T,
103 p_new_ccid OUT NOCOPY NUMBER,
104 p_return_error_message OUT NOCOPY VARCHAR2,
105 p_return_status OUT NOCOPY VARCHAR2);
106
107 -- Bug: 6936055, GMS Integration, Award Validation
108 PROCEDURE ValidateProjectAccounting(
109 p_report_line_id IN NUMBER,
110 p_web_parameter_id IN NUMBER,
111 p_project_id IN NUMBER,
112 p_task_id IN NUMBER,
113 p_award_id IN NUMBER,
114 p_award_number IN VARCHAR2,
115 p_expenditure_org_id IN NUMBER,
116 p_amount IN NUMBER,
117 p_return_error_message OUT NOCOPY VARCHAR2,
118 p_msg_count OUT NOCOPY NUMBER,
119 p_msg_data OUT NOCOPY VARCHAR2);
120
121 END AP_WEB_ACCTG_PKG;