1: PACKAGE jai_rcv_transactions_pkg AS
2: /* $Header: jai_rcv_trx.pls 120.1 2005/07/20 12:59:19 avallabh ship $ */
3:
4: PROCEDURE insert_row(
5: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
1: PACKAGE jai_rcv_transactions_pkg AS
2: /* $Header: jai_rcv_trx.pls 120.1 2005/07/20 12:59:19 avallabh 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,
2: /* $Header: jai_rcv_trx.pls 120.1 2005/07/20 12:59:19 avallabh 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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%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: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
38: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%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: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
38: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
39: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%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: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
38: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
39: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
40: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%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: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
38: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
39: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
40: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
41: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%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: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
38: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
39: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
40: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
41: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
42: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%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: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
38: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
39: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
40: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
41: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
42: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
43: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
36: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
37: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
38: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
39: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
40: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
41: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
42: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
43: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
44: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
37: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
38: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
39: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
40: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
41: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
42: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
43: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
44: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
45: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
38: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
39: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
40: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
41: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
42: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
43: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
44: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
45: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
46: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
39: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
40: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
41: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
42: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
43: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
44: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
45: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
46: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
47: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,
40: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
41: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
42: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
43: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
44: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
45: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
46: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
47: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,
48: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
41: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
42: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
43: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
44: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
45: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
46: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
47: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,
48: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
49: );
42: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
43: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
44: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
45: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
46: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
47: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,
48: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
49: );
50:
43: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
44: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
45: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
46: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
47: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,
48: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
49: );
50:
51: PROCEDURE update_row(
44: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
45: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
46: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
47: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,
48: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
49: );
50:
51: PROCEDURE update_row(
52: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
48: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
49: );
50:
51: PROCEDURE update_row(
52: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
53: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
54: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
55: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
56: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
49: );
50:
51: PROCEDURE update_row(
52: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
53: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
54: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
55: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
56: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
57: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
50:
51: PROCEDURE update_row(
52: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
53: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
54: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
55: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
56: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
57: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
58: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
51: PROCEDURE update_row(
52: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
53: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
54: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
55: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
56: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
57: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
58: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
59: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
52: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
53: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
54: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
55: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
56: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
57: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
58: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
59: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
60: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
53: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
54: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
55: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
56: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
57: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
58: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
59: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
60: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
61: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
54: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
55: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
56: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
57: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
58: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
59: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
60: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
61: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
62: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
55: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
56: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
57: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
58: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
59: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
60: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
61: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
62: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
63: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
56: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
57: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
58: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
59: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
60: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
61: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
62: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
63: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
64: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
57: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
58: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
59: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
60: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
61: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
62: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
63: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
64: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
65: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
58: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
59: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
60: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
61: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
62: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
63: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
64: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
65: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
66: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
59: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
60: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
61: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
62: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
63: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
64: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
65: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
66: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
67: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
60: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
61: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
62: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
63: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
64: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
65: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
66: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
67: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
68: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
61: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
62: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
63: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
64: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
65: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
66: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
67: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
68: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
69: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
62: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
63: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
64: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
65: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
66: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
67: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
68: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
69: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
70: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
63: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
64: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
65: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
66: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
67: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
68: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
69: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
70: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
71: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
64: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
65: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
66: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
67: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
68: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
69: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
70: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
71: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
72: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
65: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
66: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
67: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
68: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
69: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
70: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
71: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
72: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
73: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
66: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
67: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
68: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
69: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
70: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
71: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
72: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
73: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
74: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
67: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
68: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
69: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
70: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
71: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
72: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
73: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
74: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
75: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
68: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
69: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
70: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
71: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
72: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
73: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
74: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
75: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
76: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
69: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
70: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
71: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
72: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
73: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
74: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
75: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
76: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
77: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
70: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
71: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
72: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
73: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
74: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
75: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
76: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
77: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
78: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
71: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
72: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
73: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
74: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
75: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
76: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
77: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
78: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
79: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
72: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
73: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
74: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
75: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
76: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
77: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
78: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
79: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
80: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
73: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
74: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
75: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
76: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
77: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
78: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
79: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
80: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
81: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
74: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
75: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
76: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
77: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
78: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
79: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
80: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
81: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
82: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
75: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
76: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
77: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
78: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
79: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
80: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
81: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
82: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
83: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
76: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
77: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
78: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
79: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
80: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
81: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
82: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
83: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
84: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
77: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
78: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
79: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
80: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
81: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
82: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
83: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
84: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
85: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
78: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
79: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
80: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
81: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
82: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
83: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
84: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
85: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
86: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
79: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
80: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
81: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
82: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
83: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
84: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
85: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
86: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
87: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
80: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
81: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
82: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
83: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
84: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
85: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
86: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
87: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
88: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
81: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
82: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
83: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
84: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
85: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
86: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
87: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
88: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
89: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
82: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
83: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
84: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
85: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
86: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
87: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
88: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
89: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
90: );
83: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
84: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
85: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
86: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
87: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
88: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
89: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
90: );
91:
84: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
85: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
86: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
87: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
88: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
89: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
90: );
91:
92: PROCEDURE update_process_flags(
85: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
86: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
87: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
88: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
89: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
90: );
91:
92: PROCEDURE update_process_flags(
93: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
89: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
90: );
91:
92: PROCEDURE update_process_flags(
93: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
94: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,
95: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
96: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
97: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
90: );
91:
92: PROCEDURE update_process_flags(
93: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
94: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,
95: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
96: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
97: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
98: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
91:
92: PROCEDURE update_process_flags(
93: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
94: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,
95: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
96: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
97: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
98: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
99: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
92: PROCEDURE update_process_flags(
93: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
94: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,
95: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
96: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
97: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
98: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
99: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
100: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
93: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
94: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,
95: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
96: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
97: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
98: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
99: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
100: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
101: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
94: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,
95: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
96: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
97: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
98: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
99: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
100: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
101: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
102: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
95: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
96: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
97: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
98: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
99: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
100: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
101: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
102: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
103: );
97: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
98: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
99: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
100: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
101: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
102: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
103: );
104:
105: PROCEDURE update_excise_invoice_no(
98: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
99: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
100: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
101: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
102: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
103: );
104:
105: PROCEDURE update_excise_invoice_no(
106: p_transaction_id IN NUMBER,
103: );
104:
105: PROCEDURE update_excise_invoice_no(
106: p_transaction_id IN NUMBER,
107: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
108: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
109: );
110:
111: PROCEDURE update_attributes(
104:
105: PROCEDURE update_excise_invoice_no(
106: p_transaction_id IN NUMBER,
107: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
108: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
109: );
110:
111: PROCEDURE update_attributes(
112: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
108: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
109: );
110:
111: PROCEDURE update_attributes(
112: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
113: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
114: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
115: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
116: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
109: );
110:
111: PROCEDURE update_attributes(
112: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
113: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
114: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
115: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
116: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
117: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
110:
111: PROCEDURE update_attributes(
112: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
113: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
114: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
115: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
116: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
117: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
118: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
111: PROCEDURE update_attributes(
112: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
113: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
114: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
115: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
116: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
117: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
118: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
119: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
112: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
113: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
114: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
115: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
116: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
117: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
118: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
119: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
120: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
113: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
114: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
115: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
116: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
117: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
118: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
119: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
120: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
121: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
114: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
115: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
116: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
117: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
118: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
119: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
120: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
121: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
122: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
115: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
116: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
117: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
118: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
119: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
120: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
121: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
122: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
123: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
116: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
117: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
118: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
119: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
120: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
121: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
122: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
123: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
124: );
117: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
118: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
119: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
120: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
121: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
122: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
123: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
124: );
125:
118: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
119: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
120: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
121: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
122: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
123: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
124: );
125:
126: END jai_rcv_transactions_pkg;
119: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
120: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
121: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
122: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
123: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
124: );
125:
126: END jai_rcv_transactions_pkg;
122: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
123: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
124: );
125:
126: END jai_rcv_transactions_pkg;