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