[Home] [Help]
PACKAGE: APPS.JAI_OM_RG_PKG
Source
1 PACKAGE jai_om_rg_pkg AS
2 /* $Header: jai_om_rg.pls 120.6.12010000.2 2008/10/13 07:26:22 vkaranam ship $ */
3
4 /* Bug 4562791. Added by Lakshmi Gopalsami */
5
6 gl_accounting_date Date;
7
8 /* Bug 4931887. Added by Lakshmi Gopalsami
9 Added the following cursor as part of perf. fixes
10 for sql id's
11 14830451
12 14830172
13 14829872
14 */
15 CURSOR get_curr_code (p_org_id IN NUMBER , p_loc_id IN NUMBER ) IS
16 SELECT fnd.currency_code
17 FROM fnd_currencies fnd,
18 gl_ledgers gl
19 WHERE gl.currency_code = fnd.currency_code
20 AND gl.ledger_id IN (SELECT org.set_of_books_id
21 FROM org_organization_definitions org ,
22 jai_cmn_rg_balances rg ,
23 jai_cmn_inventory_orgs invorg
24 WHERE org.organization_id = rg.organization_id
25 AND rg.org_unit_id = invorg.org_unit_id
26 AND nvl(invorg.trading,'N') <> 'Y'
27 AND rg.organization_id = p_org_id
28 AND rg.location_id = p_loc_id
29 )
30 ;
31
32 PROCEDURE ja_in_rg_I_entry
33 (
34 p_fin_year NUMBER ,
35 p_org_id NUMBER ,
36 p_location_id NUMBER ,
37 p_inventory_item_id NUMBER ,
38 p_transaction_id NUMBER ,
39 p_transaction_date DATE ,
40 p_transaction_type VARCHAR2 ,
41 p_header_id NUMBER ,
42 p_excise_quantity NUMBER ,
43 p_excise_amount NUMBER ,
44 p_uom_code VARCHAR2 ,
45 p_excise_invoice_no VARCHAR2 ,
46 p_excise_invoice_date DATE ,
47 p_payment_register VARCHAR2 ,
48 p_basic_ed NUMBER ,
49 p_additional_ed NUMBER ,
50 p_other_ed NUMBER ,
51 p_excise_duty_rate NUMBER ,
52 p_customer_id NUMBER ,
53 p_customer_site_id NUMBER ,
54 p_register_code VARCHAR2 ,
55 p_creation_date DATE ,
56 p_created_by NUMBER ,
57 p_last_update_date DATE ,
58 p_last_updated_by NUMBER ,
59 p_last_update_login NUMBER ,
60 p_assessable_value NUMBER ,
61 p_cess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE DEFAULT NULL ,
62 p_sh_cess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE DEFAULT NULL , /*Bug 5989740 bduvarag*/
63 p_source JAI_CMN_RG_I_TRXS.SOURCE%TYPE DEFAULT NULL /*Parameters p_cess_amt and p_source added by aiyer for the bug 4566054 */
64 );
65
66 PROCEDURE ja_in_rg23_part_I_entry
67 (
68 p_register_type VARCHAR2,
69 p_fin_year NUMBER,
70 p_org_id NUMBER,
71 p_location_id NUMBER,
72 p_inventory_item_id NUMBER,
73 p_transaction_id NUMBER,
74 p_transaction_date DATE,
75 p_transaction_type VARCHAR2,
76 p_excise_quantity NUMBER,
77 p_uom_code VARCHAR2,
78 p_excise_invoice_id VARCHAR2,
79 p_excise_invoice_date DATE,
80 p_basic_ed NUMBER,
81 p_additional_ed NUMBER,
82 p_other_ed NUMBER,
83 p_customer_id NUMBER,
84 p_customer_site_id NUMBER,
85 p_header_id VARCHAR2,
86 p_sales_invoice_date DATE,
87 p_register_code VARCHAR2,
88 p_creation_date DATE,
89 p_created_by NUMBER,
90 p_last_update_date DATE,
91 p_last_updated_by NUMBER,
92 p_last_update_login NUMBER
93 );
94
95 PROCEDURE ja_in_rg23_part_II_entry
96 (
97 p_register_code VARCHAR2,
98 p_register_type VARCHAR2,
99 p_fin_year NUMBER,
100 p_org_id NUMBER,
101 p_location_id NUMBER,
102 p_inventory_item_id NUMBER,
103 p_transaction_id NUMBER,
104 p_transaction_date DATE,
105 p_part_i_register_id NUMBER,
106 p_excise_invoice_no VARCHAR2,
107 p_excise_invoice_date DATE,
108 p_dr_basic_ed NUMBER,
109 p_dr_additional_ed NUMBER,
110 p_dr_other_ed NUMBER,
111 p_customer_id NUMBER,
112 p_customer_site_id NUMBER,
113 p_source_name VARCHAR2,
114 p_category_name VARCHAR2,
115 p_creation_date DATE,
116 p_created_by NUMBER,
117 p_last_update_date DATE,
118 p_last_updated_by NUMBER,
119 p_last_update_login NUMBER,
120 p_picking_line_id NUMBER DEFAULT NULL,
121 p_excise_exempt_type VARCHAR2 DEFAULT NULL,
122 p_remarks VARCHAR2 DEFAULT NULL ,
123 P_REF_10 VARCHAR2 DEFAULT NULL ,
124 -- added by sriram -- bug # 2769440
125 P_REF_23 VARCHAR2 DEFAULT NULL ,
126 -- added by sriram -- bug # 2769440
127 P_REF_24 VARCHAR2 DEFAULT NULL ,
128 -- added by sriram -- bug # 2769440
129 P_REF_25 VARCHAR2 DEFAULT NULL ,
130 -- added by sriram --bug # 2769440
131 P_REF_26 VARCHAR2 DEFAULT NULL -- added by sriram -- bug # 2769440
132 );
133
134 PROCEDURE ja_in_pla_entry
135 (
136 p_org_id NUMBER,
137 p_location_id NUMBER,
138 p_inventory_item_id NUMBER,
139 p_fin_year NUMBER,
140 p_transaction_id NUMBER,
141 p_header_id NUMBER,
142 p_ref_document_date DATE,
143 p_excise_invoice_no VARCHAR2,
144 p_excise_invoice_date DATE,
145 p_dr_basic_ed NUMBER,
146 p_dr_additional_ed NUMBER,
147 p_dr_other_ed NUMBER,
148 p_customer_id NUMBER,
149 p_customer_site_id NUMBER,
150 p_source_name VARCHAR2,
151 p_category_name VARCHAR2,
152 p_creation_date DATE,
153 p_created_by NUMBER,
154 p_last_update_date DATE,
155 p_last_updated_by NUMBER,
156 p_last_update_login NUMBER ,
157 P_REF_10 VARCHAR2 DEFAULT NULL ,
158 -- added by sriram - bug # 2769440
159 P_REF_23 VARCHAR2 DEFAULT NULL ,
160 -- added by sriram - bug # 2769440
161 P_REF_24 VARCHAR2 DEFAULT NULL ,
162 -- added by sriram - bug # 2769440
163 P_REF_25 VARCHAR2 DEFAULT NULL ,
164 -- added by sriram - bug # 2769440
165 P_REF_26 VARCHAR2 DEFAULT NULL -- added by sriram - bug # 2769440
166 );
167
168 PROCEDURE ja_in_register_txn_entry
169 (
170 p_org_id NUMBER,
171 p_location_id NUMBER,
172 p_excise_invoice_no VARCHAR2,
173 p_transaction_name VARCHAR2,
174 p_order_flag VARCHAR2,
175 p_header_id NUMBER,
176 p_transaction_amount NUMBER,
177 p_register_code VARCHAR2,
178 p_creation_date DATE,
179 p_created_by NUMBER,
180 p_last_update_date DATE,
181 p_last_updated_by NUMBER,
182 p_last_update_login NUMBER,
183 p_order_invoice_type_id IN Number DEFAULT NULL,
184 p_currency_rate IN NUMBER DEFAULT 1 /* added by CSahoo - bug#5390583 */
185 );
186
187 PROCEDURE Ja_In_Rg23d_Entry
188 (
189 p_register_id NUMBER,
190 p_org_id NUMBER,
191 p_location_id NUMBER,
192 p_fin_year NUMBER,
193 p_transaction_type VARCHAR2,
194 p_inventory_item_id NUMBER,
195 p_reference_line_id NUMBER,
196 p_primary_uom_code VARCHAR2,
197 p_transaction_uom_code VARCHAR2,
198 p_customer_id NUMBER,
199 p_bill_to_site_id NUMBER,
200 p_ship_to_site_id NUMBER,
201 p_quantity_issued NUMBER,
202 p_register_code VARCHAR2,
203 p_rate_per_unit NUMBER,
204 p_excise_duty_rate NUMBER,
205 p_duty_amount NUMBER,
206 p_transaction_id NUMBER,
207 p_source_name VARCHAR2,
208 p_category_name VARCHAR2,
209 p_receipt_id NUMBER,
210 p_oth_receipt_id NUMBER,
211 p_creation_date DATE,
212 p_created_by NUMBER,
213 p_last_update_date DATE,
214 p_last_update_login NUMBER,
215 p_last_updated_by NUMBER,
216 p_dr_basic_ed NUMBER,
217 p_dr_additional_ed NUMBER,
218 p_dr_other_ed NUMBER,
219 p_comm_invoice_no VARCHAR2,
220 p_comm_invoice_date DATE,
221 P_REF_10 VARCHAR2 DEFAULT NULL ,
222 -- added by sriram - bug # 2769440
223 P_REF_23 VARCHAR2 DEFAULT NULL ,
224 -- added by sriram - bug # 2769440
225 P_REF_24 VARCHAR2 DEFAULT NULL ,
226 -- added by sriram - bug # 2769440
227 P_REF_25 VARCHAR2 DEFAULT NULL ,
228 -- added by sriram - bug # 2769440
229 P_REF_26 VARCHAR2 DEFAULT NULL -- added by sriram - bug # 2769440
230 );
231
232 END jai_om_rg_pkg;