1 PACKAGE JA_CN_JE_EXP_PKG AS
2 --$Header: JACNJEES.pls 120.0.12000000.1 2007/08/13 14:09:44 qzhao noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation
5 --| Redwood Shores, CA, USA
6 --| All rights reserved.
7 --+=======================================================================
8 --| FILENAME
9 --| JACNJEES.pls
10 --|
11 --| DESCRIPTION
12 --|
13 --| This package is to provide share procedures for CNAO programs
14 --|
15 --| PROCEDURE LIST
16 --|
17 --| PROCEDURE run_export
18 --| PROCEDURE gen_clauses
19 --| FUNCTION get_subsidiary_desc
20 --|
21 --|
22 --| HISTORY
23 --| 07-May-2007 Shujuan Yan Created
24 --|
25 --+======================================================================*/
26
27 TYPE assoc_array_varchar1000_type IS TABLE OF VARCHAR2(1000) INDEX BY PLS_INTEGER;
28 prefix_a CONSTANT VARCHAR2(10) := 'A';
29 prefix_b CONSTANT VARCHAR2(10) := 'B';
30 prefix_c CONSTANT VARCHAR2(10) := 'C';
31
32 --==========================================================================
33 -- PROCEDURE NAME:
34 --
35 -- run_export Public
36 --
37 -- DESCRIPTION:
38 --
39 -- This procedure is used to export the journal entries.
40 --
41 --
42 -- PARAMETERS:
43 -- Out: errbuf Mandatory parameter for PL/SQL concurrent programs
44 -- Out: retcode Mandatory parameter for PL/SQL concurrent programs
45 -- In p_coa_id Chart of Accounts Id
46 -- In p_ledger_id Ledger Id
47 -- In: p_legal_entity Legal entity ID
48 -- In: p_start_period start period name
49 -- In: P_end_period end period name
50 --
51 -- DESIGN REFERENCES:
52 --
53 --
54 -- CHANGE HISTORY:
55 --
56 -- 01-Mar-2006 Joseph Wang Created
57 -- 15-Jun-2006 Add parameters p_start_period and P_end_period
58 -- remove the parameter p_period
59 --
60 --===========================================================================
61
62 PROCEDURE Run_Export(errbuf OUT NOCOPY VARCHAR2
63 ,retcode OUT NOCOPY VARCHAR2
64 ,p_coa_id IN NUMBER
65 ,p_ledger_id IN NUMBER
66 ,p_legal_entity_id IN NUMBER
67 ,p_start_period IN VARCHAR2
68 ,p_end_period IN VARCHAR2);
69 --==========================================================================
70 -- PROCEDURE NAME:
71 --
72 -- gen_clauses Public
73 --
74 -- DESCRIPTION:
75 --
76 -- This procedure is used to generate the column names with or withouot
77 -- prefix in order to complete the SQL statements which are used to query
78 -- journal entries.
79 --
80 -- PARAMETERS:
81 -- In Out: p_column_clauses Collection stores generated column clauses
82 -- In Out: p_prefix_column_clauses Collection stores generated prefix column clauses
83 -- In: p_has_cost_center 'Y' or not indicates whether it is cost center subsidiary
84 -- In: p_has_third_party 'Y' or not indicates whether it is third party subsidiary
85 -- In: p_has_personnel 'Y' or not indicates whether it is personnel subsidiary
86 -- In: p_has_project 'Y' or not indicates whether it is project subsidiary
87 -- Out: p_return_column_clause Return value of generated column clause
88 -- Out: p_return_prefix_column_clause Return value of generated prefix column clause
89 --
90 --
91 -- DESIGN REFERENCES:
92 --
93 --
94 -- CHANGE HISTORY:
95 --
96 -- 07-May-2007 Shujuan Yan Created
97 --
98 --===========================================================================
99
100 PROCEDURE Gen_Clauses(p_column_clauses IN OUT NOCOPY assoc_array_varchar1000_type
101 ,p_prefix_column_clauses IN OUT NOCOPY assoc_array_varchar1000_type
102 ,p_has_cost_center VARCHAR2
103 ,p_has_third_party VARCHAR2
104 ,p_has_personnel VARCHAR2
105 ,p_has_project VARCHAR2
106 ,p_return_column_clause OUT NOCOPY VARCHAR2
107 ,p_return_prefix_column_clause OUT NOCOPY VARCHAR2);
108
109 --==========================================================================
110 -- FUNCTION NAME:
111 --
112 -- get_subsidiary_desc Public
113 --
114 -- DESCRIPTION:
115 --
116 -- This function is used to generate the subsidiary description.
117 --
118 --
119 -- PARAMETERS:
120 -- In: p_cost_center Cost center segment
121 -- In: p_third_party_number Number of third party
122 -- In: p_personnel_number Personnel number
123 -- In: p_project_number Number of project
124 -- In: p_has_cost_center 'Y' or not indicates whether it is cost center subsidiary.
125 -- In: p_has_third_party 'Y' or not indicates whether it is third party subsidiary.
126 -- In: p_has_personnel 'Y' or not indicates whether it is personnel subsidiary.
127 -- In: p_has_project 'Y' or not indicates whether it is project subsidiary.
128 --
129 --
130 -- DESIGN REFERENCES:
131 --
132 --
133 -- CHANGE HISTORY:
134 --
135 -- 07-May-2007 Shujuan Yan Created
136 --
137 --===========================================================================
138 FUNCTION Get_Subsidiary_Desc(p_cost_center VARCHAR2
139 ,p_third_party_number VARCHAR2
140 ,p_personnel_number VARCHAR2
141 ,p_project_number VARCHAR2
142 ,p_has_cost_center VARCHAR2
143 ,p_has_third_party VARCHAR2
144 ,p_has_personnel VARCHAR2
145 ,p_has_project VARCHAR2) RETURN VARCHAR2;
146
147 END JA_CN_JE_EXP_PKG;