1: PACKAGE BODY jai_rcv_transactions_pkg AS
2: /* $Header: jai_rcv_trx.plb 120.1.12010000.2 2010/04/15 11:03:01 boboli ship $ */
3: /*----------------------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY for FILENAME: jai_rcv_transactions_pkg.sql
5: S.No dd/mm/yyyy Author and Details
1: PACKAGE BODY jai_rcv_transactions_pkg AS
2: /* $Header: jai_rcv_trx.plb 120.1.12010000.2 2010/04/15 11:03:01 boboli ship $ */
3: /*----------------------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY for FILENAME: jai_rcv_transactions_pkg.sql
5: S.No dd/mm/yyyy Author and Details
6: ------------------------------------------------------------------------------------------------------------------------------
7: 1 16/07/2004 Vijay Shankar for Bug# 3496408, Version:115.0
8: Table handler Package for JAI_RCV_TRANSACTIONS table
4: CHANGE HISTORY for FILENAME: jai_rcv_transactions_pkg.sql
5: S.No dd/mm/yyyy Author and Details
6: ------------------------------------------------------------------------------------------------------------------------------
7: 1 16/07/2004 Vijay Shankar for Bug# 3496408, Version:115.0
8: Table handler Package for JAI_RCV_TRANSACTIONS table
9:
10: 2 03/01/2005 Vijay Shankar for Bug# 3940588, Version:115.1
11: Added tax_transaction_id for JAI_RCV_TRANSACTIONS table. as a result of the change, we added the corresponding
12: parameters in insert_row and update_row procedures
7: 1 16/07/2004 Vijay Shankar for Bug# 3496408, Version:115.0
8: Table handler Package for JAI_RCV_TRANSACTIONS table
9:
10: 2 03/01/2005 Vijay Shankar for Bug# 3940588, Version:115.1
11: Added tax_transaction_id for JAI_RCV_TRANSACTIONS table. as a result of the change, we added the corresponding
12: parameters in insert_row and update_row procedures
13:
14: 3 19/03/2005 Vijay Shankar for Bug#4250236(4245089). FileVersion: 115.2
15: added two more parameters in update_process_flags procedure as part of VAT Implementation to update
22: Ramananda for bug#4428980. Removal of SQL LITERALs is done
23:
24: 6. 17-Jul-2005 Sanjikum for Bug#4495135, File Version 117.1
25: 1) In the procedure update_row, added parameter - p_tax_apportion_factor.
26: And added the update for jai_rcv_transactions.tax_apportion_factor
27:
28: 7. 15-Apr-2010 Bug#9305067 Change the parameter of procedure insert_row and update_row
29: and replce the old attributes columns with new meaningful columns parameter
30: Add new procedure to update the new columns to replace the procedure update_attribtues
36: IN60106 + 3940588 + 4245089
37: ----------------------------------------------------------------------------------------------------------------------------*/
38:
39: PROCEDURE insert_row(
40: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
41: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
42: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
43: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
44: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
37: ----------------------------------------------------------------------------------------------------------------------------*/
38:
39: PROCEDURE insert_row(
40: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
41: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
42: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
43: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
44: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
45: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
38:
39: PROCEDURE insert_row(
40: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
41: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
42: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
43: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
44: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
45: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
46: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
39: PROCEDURE insert_row(
40: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
41: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
42: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
43: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
44: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
45: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
46: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
47: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
40: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
41: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
42: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
43: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
44: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
45: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
46: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
47: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
48: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
41: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
42: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
43: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
44: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
45: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
46: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
47: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
48: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
49: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
42: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
43: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
44: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
45: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
46: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
47: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
48: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
49: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
50: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
43: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
44: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
45: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
46: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
47: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
48: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
49: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
50: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
51: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
44: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
45: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
46: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
47: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
48: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
49: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
50: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
51: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
52: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
45: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
46: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
47: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
48: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
49: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
50: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
51: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
52: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
53: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
46: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
47: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
48: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
49: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
50: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
51: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
52: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
53: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
54: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
47: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
48: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
49: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
50: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
51: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
52: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
53: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
54: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
55: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
48: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
49: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
50: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
51: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
52: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
53: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
54: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
55: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
56: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
49: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
50: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
51: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
52: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
53: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
54: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
55: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
56: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
57: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
50: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
51: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
52: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
53: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
54: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
55: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
56: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
57: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
58: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
51: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
52: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
53: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
54: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
55: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
56: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
57: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
58: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
59: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
52: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
53: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
54: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
55: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
56: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
57: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
58: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
59: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
60: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
53: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
54: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
55: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
56: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
57: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
58: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
59: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
60: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
61: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
54: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
55: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
56: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
57: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
58: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
59: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
60: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
61: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
62: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
55: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
56: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
57: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
58: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
59: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
60: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
61: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
62: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
63: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
56: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
57: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
58: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
59: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
60: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
61: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
62: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
63: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
64: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
57: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
58: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
59: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
60: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
61: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
62: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
63: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
64: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
65: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
58: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
59: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
60: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
61: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
62: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
63: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
64: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
65: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
66: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
59: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
60: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
61: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
62: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
63: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
64: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
65: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
66: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
67: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
60: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
61: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
62: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
63: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
64: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
65: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
66: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
67: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
68: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
61: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
62: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
63: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
64: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
65: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
66: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
67: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
68: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
69: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
62: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
63: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
64: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
65: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
66: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
67: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
68: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
69: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
70: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
63: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
64: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
65: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
66: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
67: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
68: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
69: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
70: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
71: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
64: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
65: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
66: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
67: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
68: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
69: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
70: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
71: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
72: --Added new parametersby Bo Li for bug9305067
65: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
66: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
67: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
68: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
69: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
70: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
71: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
72: --Added new parametersby Bo Li for bug9305067
73: --remove the old attribute parameters Begin
66: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
67: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
68: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
69: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
70: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
71: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
72: --Added new parametersby Bo Li for bug9305067
73: --remove the old attribute parameters Begin
74: -----------------------------------------------------------------------------
67: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
68: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
69: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
70: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
71: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
72: --Added new parametersby Bo Li for bug9305067
73: --remove the old attribute parameters Begin
74: -----------------------------------------------------------------------------
75: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
71: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
72: --Added new parametersby Bo Li for bug9305067
73: --remove the old attribute parameters Begin
74: -----------------------------------------------------------------------------
75: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
76: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
77: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
78: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
79: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
72: --Added new parametersby Bo Li for bug9305067
73: --remove the old attribute parameters Begin
74: -----------------------------------------------------------------------------
75: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
76: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
77: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
78: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
79: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
80: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
73: --remove the old attribute parameters Begin
74: -----------------------------------------------------------------------------
75: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
76: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
77: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
78: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
79: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
80: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
81: -----------------------------------------------------------------------------
74: -----------------------------------------------------------------------------
75: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
76: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
77: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
78: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
79: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
80: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
81: -----------------------------------------------------------------------------
82: --Added new parametersby Bo Li for bug9305067
75: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
76: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
77: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
78: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
79: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
80: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
81: -----------------------------------------------------------------------------
82: --Added new parametersby Bo Li for bug9305067
83: --remove the old attribute parameters End
76: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
77: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
78: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
79: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
80: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
81: -----------------------------------------------------------------------------
82: --Added new parametersby Bo Li for bug9305067
83: --remove the old attribute parameters End
84: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
80: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
81: -----------------------------------------------------------------------------
82: --Added new parametersby Bo Li for bug9305067
83: --remove the old attribute parameters End
84: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
85: ) IS
86:
87: lv_creation_date DATE;
88: lv_created_by NUMBER(15);
97: lv_last_update_date := SYSDATE;
98: lv_last_updated_by := lv_created_by;
99: lv_last_update_login := FND_GLOBAL.login_id;
100:
101: INSERT INTO JAI_RCV_TRANSACTIONS(
102: shipment_header_id, shipment_line_id, transaction_id, transaction_type, quantity, uom_code,
103: transaction_date, parent_transaction_id, parent_transaction_type, receipt_num, organization_id,
104: location_id, inventory_item_id, item_class, item_cenvatable, item_excisable, item_trading_flag,
105: inv_item_flag, inv_asset_flag, loc_subinv_type, BASE_ASSET_INVENTORY, organization_type,
136:
137: END insert_row;
138:
139: PROCEDURE update_row(
140: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
141: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
142: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
143: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
144: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
137: END insert_row;
138:
139: PROCEDURE update_row(
140: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
141: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
142: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
143: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
144: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
145: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
138:
139: PROCEDURE update_row(
140: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
141: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
142: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
143: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
144: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
145: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
146: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
139: PROCEDURE update_row(
140: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
141: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
142: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
143: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
144: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
145: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
146: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
147: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
140: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
141: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
142: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
143: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
144: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
145: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
146: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
147: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
148: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
141: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
142: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
143: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
144: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
145: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
146: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
147: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
148: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
149: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
142: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
143: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
144: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
145: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
146: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
147: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
148: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
149: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
150: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
143: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
144: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
145: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
146: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
147: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
148: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
149: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
150: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
151: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
144: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
145: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
146: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
147: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
148: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
149: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
150: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
151: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
152: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
145: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
146: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
147: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
148: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
149: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
150: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
151: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
152: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
153: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
146: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
147: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
148: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
149: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
150: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
151: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
152: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
153: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
154: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
147: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
148: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
149: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
150: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
151: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
152: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
153: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
154: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
155: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
148: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
149: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
150: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
151: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
152: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
153: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
154: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
155: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
156: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
149: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
150: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
151: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
152: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
153: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
154: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
155: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
156: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
157: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
150: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
151: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
152: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
153: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
154: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
155: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
156: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
157: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
158: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
151: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
152: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
153: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
154: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
155: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
156: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
157: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
158: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
159: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
152: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
153: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
154: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
155: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
156: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
157: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
158: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
159: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
160: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
153: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
154: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
155: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
156: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
157: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
158: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
159: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
160: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
161: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
154: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
155: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
156: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
157: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
158: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
159: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
160: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
161: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
162: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
155: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
156: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
157: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
158: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
159: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
160: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
161: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
162: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
163: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
156: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
157: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
158: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
159: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
160: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
161: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
162: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
163: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
164: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
157: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
158: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
159: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
160: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
161: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
162: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
163: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
164: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
165: --Added new parametersby Bo Li for bug9305067
158: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
159: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
160: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
161: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
162: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
163: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
164: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
165: --Added new parametersby Bo Li for bug9305067
166: --remove the old attribute parameters Begin
159: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
160: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
161: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
162: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
163: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
164: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
165: --Added new parametersby Bo Li for bug9305067
166: --remove the old attribute parameters Begin
167: -----------------------------------------------------------------------------
160: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
161: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
162: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
163: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
164: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
165: --Added new parametersby Bo Li for bug9305067
166: --remove the old attribute parameters Begin
167: -----------------------------------------------------------------------------
168: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
164: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
165: --Added new parametersby Bo Li for bug9305067
166: --remove the old attribute parameters Begin
167: -----------------------------------------------------------------------------
168: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
169: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
170: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
171: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
172: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
165: --Added new parametersby Bo Li for bug9305067
166: --remove the old attribute parameters Begin
167: -----------------------------------------------------------------------------
168: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
169: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
170: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
171: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
172: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
173: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
166: --remove the old attribute parameters Begin
167: -----------------------------------------------------------------------------
168: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
169: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
170: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
171: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
172: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
173: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
174: -----------------------------------------------------------------------------
167: -----------------------------------------------------------------------------
168: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
169: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
170: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
171: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
172: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
173: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
174: -----------------------------------------------------------------------------
175: --Added new parametersby Bo Li for bug9305067
168: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
169: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
170: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
171: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
172: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
173: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
174: -----------------------------------------------------------------------------
175: --Added new parametersby Bo Li for bug9305067
176: --remove the old attribute parameters End
169: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
170: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
171: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
172: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
173: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
174: -----------------------------------------------------------------------------
175: --Added new parametersby Bo Li for bug9305067
176: --remove the old attribute parameters End
177: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
173: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
174: -----------------------------------------------------------------------------
175: --Added new parametersby Bo Li for bug9305067
176: --remove the old attribute parameters End
177: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
178: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
179: ) IS
180:
181: lv_last_update_date DATE;
174: -----------------------------------------------------------------------------
175: --Added new parametersby Bo Li for bug9305067
176: --remove the old attribute parameters End
177: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
178: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
179: ) IS
180:
181: lv_last_update_date DATE;
182: lv_last_updated_by NUMBER(15);
187: lv_last_update_date := SYSDATE;
188: lv_last_updated_by := FND_GLOBAL.user_id;
189: lv_last_update_login := FND_GLOBAL.login_id;
190:
191: UPDATE JAI_RCV_TRANSACTIONS SET
192: PARENT_TRANSACTION_TYPE = nvl(P_PARENT_TRANSACTION_TYPE, PARENT_TRANSACTION_TYPE),
193: RECEIPT_NUM = nvl(P_RECEIPT_NUM, RECEIPT_NUM),
194: ORGANIZATION_ID = nvl(P_ORGANIZATION_ID, ORGANIZATION_ID),
195: LOCATION_ID = nvl(P_LOCATION_ID, LOCATION_ID),
235:
236: END update_row;
237:
238: PROCEDURE update_process_flags(
239: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
240: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,
241: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
242: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
243: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
236: END update_row;
237:
238: PROCEDURE update_process_flags(
239: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
240: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,
241: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
242: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
243: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
244: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
237:
238: PROCEDURE update_process_flags(
239: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
240: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,
241: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
242: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
243: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
244: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
245: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
238: PROCEDURE update_process_flags(
239: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
240: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,
241: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
242: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
243: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
244: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
245: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
246: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
239: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
240: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,
241: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
242: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
243: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
244: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
245: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
246: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
247: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
240: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,
241: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
242: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
243: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
244: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
245: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
246: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
247: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
248: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
241: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
242: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
243: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
244: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
245: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
246: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
247: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
248: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
249: ) IS
243: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
244: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
245: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
246: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
247: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
248: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
249: ) IS
250:
251: BEGIN
244: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
245: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
246: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
247: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
248: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
249: ) IS
250:
251: BEGIN
252: UPDATE JAI_RCV_TRANSACTIONS
248: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
249: ) IS
250:
251: BEGIN
252: UPDATE JAI_RCV_TRANSACTIONS
253: SET
254: PROCESS_STATUS = nvl(p_process_flag, PROCESS_STATUS),
255: process_message = nvl(p_process_message, process_message),
256: CENVAT_RG_STATUS = nvl(p_cenvat_rg_flag, CENVAT_RG_STATUS),
268: END update_process_flags;
269:
270: PROCEDURE update_excise_invoice_no(
271: p_transaction_id IN NUMBER,
272: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
273: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
274: ) IS
275:
276: BEGIN
269:
270: PROCEDURE update_excise_invoice_no(
271: p_transaction_id IN NUMBER,
272: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
273: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
274: ) IS
275:
276: BEGIN
277: UPDATE JAI_RCV_TRANSACTIONS
273: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
274: ) IS
275:
276: BEGIN
277: UPDATE JAI_RCV_TRANSACTIONS
278: SET excise_invoice_no = p_excise_invoice_no,
279: excise_invoice_date = p_excise_invoice_date,
280: last_updated_by = fnd_global.user_id,
281: last_update_login = fnd_global.login_id,
284:
285: END update_excise_invoice_no;
286:
287: PROCEDURE update_attributes(
288: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
289: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
290: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
291: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
292: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
285: END update_excise_invoice_no;
286:
287: PROCEDURE update_attributes(
288: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
289: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
290: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
291: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
292: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
293: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
286:
287: PROCEDURE update_attributes(
288: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
289: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
290: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
291: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
292: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
293: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
294: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
287: PROCEDURE update_attributes(
288: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
289: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
290: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
291: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
292: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
293: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
294: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
295: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
288: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
289: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
290: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
291: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
292: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
293: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
294: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
295: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
296: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
289: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
290: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
291: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
292: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
293: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
294: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
295: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
296: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
297: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
290: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
291: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
292: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
293: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
294: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
295: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
296: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
297: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
298: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
291: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
292: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
293: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
294: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
295: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
296: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
297: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
298: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
299: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
292: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
293: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
294: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
295: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
296: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
297: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
298: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
299: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
300: ) IS
293: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
294: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
295: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
296: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
297: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
298: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
299: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
300: ) IS
301:
294: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
295: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
296: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
297: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
298: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
299: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
300: ) IS
301:
302: BEGIN
295: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
296: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
297: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
298: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
299: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
300: ) IS
301:
302: BEGIN
303: UPDATE JAI_RCV_TRANSACTIONS SET
299: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
300: ) IS
301:
302: BEGIN
303: UPDATE JAI_RCV_TRANSACTIONS SET
304: ATTRIBUTE_CATEGORY = nvl(P_ATTRIBUTE_CATEGORY, ATTRIBUTE_CATEGORY),
305: ATTRIBUTE1 = nvl(P_ATTRIBUTE1, ATTRIBUTE1),
306: ATTRIBUTE2 = nvl(P_ATTRIBUTE2, ATTRIBUTE2),
307: ATTRIBUTE3 = nvl(P_ATTRIBUTE3, ATTRIBUTE3),
347: -- CHANGE HISTORY:
348: -- 15-Apr-2010 Created by Bo Li
349: --==========================================================================
350: PROCEDURE update_inv_stat_and_no (
351: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
352: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
353: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
354: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
355: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
348: -- 15-Apr-2010 Created by Bo Li
349: --==========================================================================
350: PROCEDURE update_inv_stat_and_no (
351: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
352: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
353: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
354: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
355: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
356: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL
349: --==========================================================================
350: PROCEDURE update_inv_stat_and_no (
351: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
352: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
353: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
354: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
355: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
356: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL
357: ) IS
350: PROCEDURE update_inv_stat_and_no (
351: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
352: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
353: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
354: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
355: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
356: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL
357: ) IS
358:
351: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
352: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
353: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
354: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
355: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
356: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL
357: ) IS
358:
359: BEGIN
352: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
353: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
354: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
355: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
356: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL
357: ) IS
358:
359: BEGIN
360: UPDATE JAI_RCV_TRANSACTIONS
356: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL
357: ) IS
358:
359: BEGIN
360: UPDATE JAI_RCV_TRANSACTIONS
361: SET
362: TRX_INFORMATION = nvl(P_TRX_INFORMATION, TRX_INFORMATION),
363: EXCISE_INV_GEN_STATUS = nvl(P_EXCISE_INV_GEN_STATUS, EXCISE_INV_GEN_STATUS),
364: VAT_INV_GEN_STATUS = nvl(P_VAT_INV_GEN_STATUS, VAT_INV_GEN_STATUS),
396: -- CHANGE HISTORY:
397: -- 15-Apr-2010 Created by Bo Li
398: --==========================================================================
399: PROCEDURE update_cenvat_costed_flag (
400: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
401: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL
402: ) IS
403:
404: BEGIN
397: -- 15-Apr-2010 Created by Bo Li
398: --==========================================================================
399: PROCEDURE update_cenvat_costed_flag (
400: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
401: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL
402: ) IS
403:
404: BEGIN
405: UPDATE JAI_RCV_TRANSACTIONS SET
401: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL
402: ) IS
403:
404: BEGIN
405: UPDATE JAI_RCV_TRANSACTIONS SET
406: CENVAT_COSTED_FLAG = nvl(P_CENVAT_COSTED_FLAG, CENVAT_COSTED_FLAG),
407: LAST_UPDATE_DATE = sysdate,
408: LAST_UPDATED_BY = fnd_global.user_id,
409: LAST_UPDATE_LOGIN = fnd_global.login_id
411:
412: END update_cenvat_costed_flag;
413:
414:
415: END jai_rcv_transactions_pkg;