1 PACKAGE JAI_MTL_TRXS_PKG AS
2 /*$Header: jai_mtl_trxs_pkg.pls 120.4.12020000.2 2013/04/13 06:54:40 mmurtuza ship $ */
3
4 /*----------------------------------------------------------------------------------------------------------------------
5 CHANGE HISTORY: FILENAME: jai_mtl_trxs_pkg.pls
6 S.No Date Author and Details
7 ------------------------------------------------------------------------------------------------------------------------
8 1. 01-08-2007 rchandan for bug#6030615 , Version 120.0
9 Issue : Inter org Forward porting
10 This is a new file in R12 now.
11 2. 12-May-2008 Changes by nprashar . Forward porting of 11i bug # 6086452 for R12 bug 6710747.
12
13 3. 10-Sep-2010 Jia for GST Bug#10091373.
14
15 ------------------------------------------------------------------------------------------------------------------------
16 */
17
18 PROCEDURE cenvat_process( p_transaction_temp_id IN NUMBER,
19 p_transaction_type in varchar2,
20 p_excise_inv_no in varchar2,/*Changes by nprashar for bug # 6710747*/
21 p_process_status OUT NOCOPY VARCHAR2,
22 p_process_message OUT NOCOPY VARCHAR2);
23
24 PROCEDURE recv_vat_process(p_organization_id IN NUMBER,
25 p_location_id IN NUMBER,
26 p_set_of_books_id in number,
27 p_currency in varchar2,
28 p_transaction_header_id IN NUMBER,
29 p_transaction_temp_id IN NUMBER,
30 p_vat_invoice_no IN VARCHAR2,
31 p_process_status OUT NOCOPY VARCHAR2,
32 p_process_message OUT NOCOPY VARCHAR2);
33
34 type claimrec is record(receipt_num JAI_RCV_TRANSACTIONS.receipt_num%type,
35 receipt_qty JAI_RCV_TRANSACTIONS.quantity%type,
36 claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%type,
37 qty_to_claim JAI_RCV_CENVAT_CLAIMS.quantity_for_2nd_claim%type,
38 cenvat_amt_to_apply JAI_RCV_CENVAT_CLAIMS.cenvat_amt_for_2nd_claim%type,
39 shipment_line_id JAI_RCV_CENVAT_CLAIMS.shipment_line_id%type,
40 cenvat_claimed_amt JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_amt%type,
41 other_cenvat_claimed_amt JAI_RCV_CENVAT_CLAIMS.other_cenvat_claimed_amt%type,
42 other_cenvat_amt_to_apply JAI_RCV_CENVAT_CLAIMS.other_cenvat_amt_for_2nd_claim%type ,
43 cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type,
44 other_cenvat_Amt JAI_RCV_CENVAT_CLAIMS.other_cenvat_Amt%type,
45 transaction_id JAI_RCV_CENVAT_CLAIMS.transaction_id%type,
46 excise_invoice_no JAI_RCV_TRANSACTIONS.excise_invoice_no%type,
47 excise_invoice_date JAI_RCV_TRANSACTIONS.excise_invoice_date%type);
48
49 type claimcur is ref cursor return claimrec;
50
51 PROCEDURE cenvat_recpt_det(block_data in OUT NOCOPY claimcur,
52 p_organization_id in number);
53 PROCEDURE do_cenvat_Acctg(
54 p_set_of_books_id IN NUMBER,
55 p_transaction_temp_id IN NUMBER,
56 p_je_source_name IN VARCHAR2,
57 p_je_category_name IN VARCHAR2,
58 p_currency_code IN VARCHAR2,
59 p_register_type IN VARCHAR2,
60 p_process_status OUT NOCOPY VARCHAR2,
61 p_process_message OUT NOCOPY VARCHAR2
62 );
63
64
65 procedure cenvat_auto_claim
66 (p_transaction_Temp_id IN NUMBER,
67 p_shipment_line_id IN NUMBER,
68 p_applied_quantity IN NUMBER
69 );
70
71
72 procedure do_costing
73 (
74 transaction_id IN NUMBER,
75 process_flag OUT NOCOPY varchar2,
76 process_msg OUT NOCOPY varchar2
77 );
78
79
80 PROCEDURE avg_cost_entry(
81 p_txn_header_id IN OUT NOCOPY NUMBER,
82 p_item_id IN NUMBER,
83 p_organization_id IN NUMBER,
84 p_uom_code IN VARCHAR2,
85 p_transaction_date IN DATE,
86 p_transaction_type_id IN NUMBER,
87 p_transaction_source_type_id IN NUMBER,
88 p_transaction_id IN NUMBER,
89 p_cost_group_id IN NUMBER,
90 p_receiving_account_id IN NUMBER,
91 p_absorption_account_id IN NUMBER,
92 p_value_change IN NUMBER,
93 p_transaction_action_id IN NUMBER ,
94 p_from_organization_id IN NUMBER ,
95 p_from_subinventory IN VARCHAR2,
96 p_to_subinventory IN VARCHAR2,
97 p_txn_quantity IN NUMBER
98 );
99
100
101 PROCEDURE std_cost_entry(
102 p_transaction_id IN NUMBER,
103 p_reference_account IN NUMBER,
104 p_inventory_item_id IN NUMBER,
105 p_organization_id IN NUMBER,
106 p_transaction_source_id IN NUMBER,
107 p_transaction_source_type_id IN NUMBER,
108 p_primary_quantity IN NUMBER,
109 p_transaction_date IN DATE,
110 p_cost_amount IN NUMBER,
111 p_process_flag OUT NOCOPY VARCHAR2,
112 p_process_msg OUT NOCOPY VARCHAR2
113 );
114
115 PROCEDURE process_vat_claim_acctg(
116 p_repository_id IN NUMBER,
117 p_process_status OUT NOCOPY VARCHAR2,
118 p_process_message OUT NOCOPY VARCHAR2);
119
120 PROCEDURE CGVAT_REPOSIT_ENTRY(p_organization_id IN NUMBER,
121 p_location_id IN NUMBER,
122 p_Set_of_books_id IN number,
123 p_currency in varchar2,
124 p_transaction_header_id IN NUMBER,
125 p_transaction_temp_id IN NUMBER,
126 p_transaction_id IN NUMBER,
127 p_vat_invoice_no IN VARCHAR2,
128 p_tax_type in varchar2,
129 p_amount in number,
130 p_claim_schedule_id in number,
131 p_process_status OUT NOCOPY VARCHAR2,
132 p_process_message OUT NOCOPY VARCHAR2) ;
133
134 PROCEDURE claim_balance_cgvat(
135 p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
136 p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
137 p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
138 p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
139 p_tax_type IN jai_cmn_taxes_all.tax_type%TYPE DEFAULT NULL,
140 p_tax_id IN jai_cmn_taxes_all.tax_id%TYPE DEFAULT NULL,
141 p_receipt_num IN VARCHAR2,
142 P_applied_qty IN NUMBER,
143 p_organization_id IN NUMBER,
144 p_inventory_item_id IN NUMBER,
145 p_location_id IN NUMBER,
146 p_Set_of_books_id IN NUMBER,
147 p_currency IN VARCHAR2,
148 p_transaction_header_id IN NUMBER,
149 p_transaction_temp_id IN NUMBER,
150 p_vat_invoice_no IN VARCHAR2,
151 p_process_status OUT NOCOPY VARCHAR2,
152 p_process_message OUT NOCOPY VARCHAR2);
153
154
155 PROCEDURE default_taxes(
156 p_to_organization_id number ,
157 p_to_location_code VARCHAR2 ,
158 p_transfer_subinventory varchar2 ,
159 p_toorg_location_id number ,
160 p_organization_id number ,
161 p_subinventory_code varchar2 ,
162 p_transaction_type_id number ,
163 p_header_id NUMBER ,
164 p_line_id NUMBER ,
165 p_inventory_item_id NUMBER ,
166 p_uom_code VARCHAR2 ,
167 p_line_quantity NUMBER ,
168 p_item_cost NUMBER ,
169 p_currency VARCHAR2 ,
170 p_currency_conv_factor NUMBER ,
171 p_date_order DATE ,
172 p_Iproc_profile_val number ,
173 p_assessable_value OUT NOCOPY NUMBER ,
174 p_vat_assessable_value OUT NOCOPY NUMBER ,
175 p_tax_amount IN OUT NOCOPY NUMBER
176 -- , pn_gst_assessable_value OUT NOCOPY NUMBER -- Added by Jia for GST Bug#10091373 on 2010/09/10 /*Commented by mmurtuza for bug 16568665 */
177 );
178
179 PROCEDURE sync_with_base_trx(
180 p_transaction_header_id IN NUMBER,
181 p_transaction_temp_id IN NUMBER,
182 p_event IN VARCHAR2
183 );
184
185 END;