[Home] [Help]
PACKAGE: APPS.JAI_RCV_TRANSACTIONS_PKG
Source
1 PACKAGE jai_rcv_transactions_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_rcv_trx.pls 120.1.12010000.2 2010/04/15 11:01:45 boboli ship $ */
3
4 PROCEDURE insert_row(
5 p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
6 p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
7 p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
8 p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
9 p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
10 p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
11 p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
12 p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
13 p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
14 p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
15 p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
16 p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
17 p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
18 p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
19 p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
20 p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
21 p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
22 p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
23 p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
24 p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
25 p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
26 p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
27 p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
28 p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
29 p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
30 p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
31 p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE,
32 p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
33 p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
34 p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
35 p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
36 p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
37 --Added new parametersby Bo Li for bug9305067
38 --remove the old attribute parameters Begin
39 -----------------------------------------------------------------------------
40 p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
41 p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
42 p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
43 p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
44 p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
45 p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
46 -----------------------------------------------------------------------------
47 --Added new parametersby Bo Li for bug9305067
48 --remove the old attribute parameters End
49 p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
50 );
51
52 PROCEDURE update_row(
53 p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
54 p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
55 p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
56 p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
57 p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
58 p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
59 p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
60 p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
61 p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
62 p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
63 p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
64 p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
65 p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
66 p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
67 p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
68 p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
69 p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
70 p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
71 p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
72 p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
73 p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
74 p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
75 p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
76 p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
77 p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
78 --Added new parametersby Bo Li for bug9305067
79 --remove the old attribute parameters Begin
80 -----------------------------------------------------------------------------
81 p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
82 p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
83 p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
84 p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
85 p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL,
86 p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL,
87 -----------------------------------------------------------------------------
88 --Added new parametersby Bo Li for bug9305067
89 --remove the old attribute parameters End
90 p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
91 p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
92 );
93
94 PROCEDURE update_process_flags(
95 p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
96 p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,
97 p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
98 p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
99 p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
100 p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
101 p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
102 /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
103 p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
104 p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
105 );
106
107 PROCEDURE update_excise_invoice_no(
108 p_transaction_id IN NUMBER,
109 p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
110 p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
111 );
112
113 PROCEDURE update_attributes(
114 p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
115 p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
116 p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
117 p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
118 p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
119 p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
120 p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
121 p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
122 p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
123 p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
124 p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
125 p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
126 );
127
128 --==========================================================================
129 -- PROCEDURE NAME:
130 -- update_inv_stat_and_no Public
131 --
132 -- DESCRIPTION:
133 -- This procedure is written for replace the update_attributes procedure
134 --
135 -- ER NAME/BUG#
136 -- Enable DFF Batch2
137 -- Bug bug9305067
138 --
139 -- PARAMETERS:
140 -- In: p_transaction_id Identifier of transaction
141 -- p_trx_information Trx Information
142 -- p_excise_inv_gen_status Excise invoice generation status
143 -- p_vat_inv_gen_status Vat invoice generation status
144 -- p_excise_inv_gen_number Excise invoice generation number
145 -- p_vat_inv_gen_number Vat invoice generation number
146 --
147 --
148 -- DESIGN REFERENCES:
149 -- TD named "TDD_1213_JAI_Enhanced_DFF.doc"
150 --
151 -- CALL FROM
152 --
153 -- CHANGE HISTORY:
154 -- 15-Apr-2010 Created by Bo Li
155 --==========================================================================
156 PROCEDURE update_inv_stat_and_no (
157 p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
158 p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
159 p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
160 p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
161 p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
162 p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL
163 );
164
165 --==========================================================================
166 -- PROCEDURE NAME:
167 -- update_cenvat_costed_flag Public
168 --
169 -- DESCRIPTION:
170 -- This procedure is written for replace the update_attributes procedure
171 --
172 -- ER NAME/BUG#
173 -- Enable DFF Batch2
174 -- Bug bug9305067
175 --
176 -- PARAMETERS:
177 -- In: p_transaction_id Identifier of transaction
178 -- p_cenvat_costed_flag CENVAT costed Flag
179
180 --
181 --
182 -- DESIGN REFERENCES:
183 -- TD named "TDD_1213_JAI_Enhanced_DFF.doc"
184 --
185 -- CALL FROM
186 --
187 -- CHANGE HISTORY:
188 -- 15-Apr-2010 Created by Bo Li
189 --==========================================================================
190 PROCEDURE update_cenvat_costed_flag (
191 p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
192 p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL
193 );
194
195
196
197 END jai_rcv_transactions_pkg;