[Home] [Help]
PACKAGE: APPS.ZX_TRL_ALLOCATIONS_PKG
Source
1 PACKAGE ZX_TRL_ALLOCATIONS_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxriallocatnpkgs.pls 120.17 2010/08/11 14:13:27 ssohal ship $ */
3
4 TYPE trx_number_tbl_type IS TABLE OF zx_lines.trx_number%type INDEX BY BINARY_INTEGER;
5 TYPE trx_id_tbl_type IS TABLE OF zx_lines.trx_id%type INDEX BY BINARY_INTEGER;
6 TYPE trx_line_id_tbl_type IS TABLE OF zx_lines.trx_line_id%type INDEX BY BINARY_INTEGER;
7 TYPE trx_level_type_tbl_type IS TABLE OF zx_lines.trx_level_type%type INDEX BY BINARY_INTEGER;
8 TYPE trx_line_date_tbl_type IS TABLE OF zx_lines.trx_line_date%type INDEX BY BINARY_INTEGER;
9 TYPE trx_line_number_tbl_type IS TABLE OF zx_lines.trx_line_number%type INDEX BY BINARY_INTEGER;
10 TYPE line_amt_tbl_type IS TABLE OF zx_lines.line_amt%type INDEX BY BINARY_INTEGER;
11 TYPE alloc_exist_tbl_type IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
12 TYPE trx_line_description_tbl_type IS TABLE OF zx_transaction_lines.trx_line_description%type INDEX BY BINARY_INTEGER;
13
14 Type trx_allocate_tbl_type IS TABLE OF VARCHAR2(10) INDEX BY VARCHAR2(1000);
15
16 TYPE trx_record_tbl_type IS RECORD (p_trx_number trx_number_tbl_type,
17 p_trx_id trx_id_tbl_type,
18 p_trx_line_id trx_line_id_tbl_type,
19 p_trx_level_type trx_level_type_tbl_type,
20 p_trx_line_description trx_line_description_tbl_type,
21 p_trx_line_date trx_line_date_tbl_type,
22 p_trx_line_number trx_line_number_tbl_type,
23 p_line_amt line_amt_tbl_type,
24 p_alloc_exist_flag alloc_exist_tbl_type);
25
26 g_trx_record_tbl trx_record_tbl_type;
27 g_trx_allocate_tbl trx_allocate_tbl_type;
28
29 PROCEDURE Insert_Row
30 (X_Rowid IN OUT NOCOPY VARCHAR2,
31 p_summary_tax_line_id NUMBER,
32 p_internal_organization_id NUMBER,
33 p_application_id NUMBER,
34 p_entity_code VARCHAR2,
35 p_event_class_code VARCHAR2,
36 p_event_type_code VARCHAR2,
37 p_trx_line_number NUMBER,--
38 p_trx_id NUMBER,
39 p_trx_number VARCHAR2,--
40 p_trx_line_id NUMBER,--
41 p_trx_level_type VARCHAR2,
42 --p_tax_line_number NUMBER,--
43 p_line_amt NUMBER,--
44 p_trx_line_date DATE,--
45 --p_tax_regime_id NUMBER,
46 p_tax_regime_code VARCHAR2,
47 --p_tax_id NUMBER,
48 p_tax VARCHAR2,
49 p_tax_jurisdiction_code VARCHAR2,
50 --p_tax_status_id NUMBER,
51 p_tax_status_code VARCHAR2,
52 p_tax_rate_id NUMBER,
53 p_tax_rate_code VARCHAR2,
54 p_tax_rate NUMBER,
55 p_tax_amt NUMBER,
56 p_enabled_record VARCHAR2,
57 p_manually_entered_flag VARCHAR2,
58 p_content_owner_id NUMBER,
59 p_record_type_code VARCHAR2,
60 p_last_manual_entry VARCHAR2,
61 p_trx_line_amt NUMBER,
62 p_tax_amt_included_flag VARCHAR2,
63 p_self_assessed_flag VARCHAR2,
64 p_tax_only_line_flag VARCHAR2,
65 p_created_by NUMBER,
66 p_creation_date DATE,
67 p_last_updated_by NUMBER,
68 p_last_update_date DATE,
69 p_last_update_login NUMBER);
70
71 -- Modified the Procedure parameters for Bug#9664737 --
72 PROCEDURE Update_tax_amt
73 (p_summary_tax_line_id NUMBER,
74 p_application_id NUMBER,
75 p_entity_code VARCHAR2,
76 p_event_class_code VARCHAR2,
77 p_trx_id NUMBER,
78 p_tax_amt NUMBER DEFAULT NULL);
79
80 -- Modified the Procedure parameters for Bug#9664737 --
81 PROCEDURE Populate_Allocation
82 (p_statement VARCHAR2,
83 p_summary_tax_line_id NUMBER,
84 p_application_id NUMBER,
85 p_entity_code VARCHAR2,
86 p_event_class_code VARCHAR2,
87 p_tax_regime_code VARCHAR2,
88 p_tax VARCHAR2,
89 p_trx_record OUT NOCOPY trx_record_tbl_type);
90
91 PROCEDURE Insert_All_Allocation
92 (X_Rowid IN OUT NOCOPY VARCHAR2,
93 p_summary_tax_line_id NUMBER,
94 p_internal_organization_id NUMBER,
95 p_application_id NUMBER,
96 p_entity_code VARCHAR2,
97 p_event_class_code VARCHAR2,
98 p_tax_regime_code VARCHAR2,
99 p_tax VARCHAR2,
100 p_tax_jurisdiction_code VARCHAR2,
101 p_tax_status_code VARCHAR2,
102 p_tax_rate_id NUMBER,
103 p_tax_rate_code VARCHAR2,
104 p_tax_rate NUMBER,
105 p_tax_amt NUMBER,
106 p_enabled_record VARCHAR2,
107 p_summ_tax_only VARCHAR2,
108 p_statement VARCHAR2,
109 p_manually_entered_flag VARCHAR2,
110 p_content_owner_id NUMBER,
111 p_record_type_code VARCHAR2,
112 p_last_manual_entry VARCHAR2,
113 p_tax_amt_included_flag VARCHAR2,
114 p_self_assessed_flag VARCHAR2,
115 p_tax_only_line_flag VARCHAR2,
116 p_created_by NUMBER,
117 p_creation_date DATE,
118 p_last_updated_by NUMBER,
119 p_last_update_date DATE,
120 p_last_update_login NUMBER,
121 p_allocate_flag IN VARCHAR2 DEFAULT 'N'
122 );
123
124 PROCEDURE Insert_Tax_Line
125 (p_summary_tax_line_id NUMBER,
126 p_internal_organization_id NUMBER,
127 p_application_id NUMBER,
128 p_entity_code VARCHAR2,
129 p_event_class_code VARCHAR2,
130 p_trx_id NUMBER,
131 p_trx_number VARCHAR2,
132 p_tax_regime_code VARCHAR2,
133 p_tax VARCHAR2,
134 p_tax_jurisdiction_code VARCHAR2,
135 p_tax_status_code VARCHAR2,
136 p_tax_rate_id NUMBER,
137 p_tax_rate_code VARCHAR2,
138 p_tax_rate NUMBER,
139 p_tax_amt NUMBER,
140 p_line_amt NUMBER,
141 p_trx_line_date DATE,
142 p_summ_tax_only VARCHAR2,
143 p_manually_entered_flag VARCHAR2,
144 p_last_manual_entry VARCHAR2,
145 p_tax_amt_included_flag VARCHAR2,
146 p_self_assessed_flag VARCHAR2,
147 p_created_by NUMBER,
148 p_creation_date DATE,
149 p_last_updated_by NUMBER,
150 p_last_update_date DATE,
151 p_last_update_login NUMBER,
152 p_event_type_code VARCHAR,
153 p_legal_entity_id NUMBER,
154 p_ledger_id NUMBER,
155 p_trx_currency_code VARCHAR,
156 p_currency_conversion_date DATE,
157 p_currency_conversion_rate NUMBER,
158 p_currency_conversion_type VARCHAR2,
159 p_content_owner_id NUMBER,
160 p_trx_date DATE,
161 p_minimum_accountable_unit NUMBER,
162 p_precision NUMBER,
163 p_trx_line_gl_date DATE);
164
165 PROCEDURE Populate_alloc_tbl(p_key IN VARCHAR2);
166
167 -- Added the Procedure for Bug#9664737 --
168 PROCEDURE Delete_alloc_tbl;
169
170 END ZX_TRL_ALLOCATIONS_PKG;