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