eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_TRANSACTIONS_PKG dependencies on JAI_RCV_TRANSACTIONS

Line 1: PACKAGE jai_rcv_transactions_pkg AUTHID CURRENT_USER AS

1: PACKAGE jai_rcv_transactions_pkg AUTHID CURRENT_USER AS
2: /* $Header: jai_rcv_trx.pls 120.1.12010000.2 2010/04/15 11:01:45 boboli ship $ */
3:
4: PROCEDURE insert_row(
5: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,

Line 5: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,

1: PACKAGE jai_rcv_transactions_pkg AUTHID CURRENT_USER AS
2: /* $Header: jai_rcv_trx.pls 120.1.12010000.2 2010/04/15 11:01:45 boboli ship $ */
3:
4: PROCEDURE insert_row(
5: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
6: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
7: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
8: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
9: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,

Line 6: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,

2: /* $Header: jai_rcv_trx.pls 120.1.12010000.2 2010/04/15 11:01:45 boboli ship $ */
3:
4: PROCEDURE insert_row(
5: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
6: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
7: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
8: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
9: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
10: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,

Line 7: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%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,

Line 8: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%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,

Line 9: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%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,

Line 10: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%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,

Line 11: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_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,

Line 12: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,

8: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
9: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
10: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
11: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
12: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
13: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
14: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
15: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
16: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,

Line 13: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%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,

Line 14: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%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,

Line 15: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%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,

Line 16: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%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,

Line 17: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,

13: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
14: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
15: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
16: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
17: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
18: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
19: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
20: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
21: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,

Line 18: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%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,

Line 19: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%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,

Line 20: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%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,

Line 21: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%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,

Line 22: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%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,

Line 23: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%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,

Line 24: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%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,

Line 25: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%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,

Line 26: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%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,

Line 27: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%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,

Line 28: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%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,

Line 29: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%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,

Line 30: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%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,

Line 31: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%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,

Line 32: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%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,

Line 33: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,

29: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
30: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
31: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE,
32: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
33: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
34: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
35: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
36: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
37: --Added new parametersby Bo Li for bug9305067

Line 34: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,

30: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
31: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE,
32: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
33: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
34: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
35: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
36: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
37: --Added new parametersby Bo Li for bug9305067
38: --remove the old attribute parameters Begin

Line 35: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,

31: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE,
32: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
33: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
34: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
35: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
36: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
37: --Added new parametersby Bo Li for bug9305067
38: --remove the old attribute parameters Begin
39: -----------------------------------------------------------------------------

Line 36: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,

32: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
33: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
34: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
35: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
36: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
37: --Added new parametersby Bo Li for bug9305067
38: --remove the old attribute parameters Begin
39: -----------------------------------------------------------------------------
40: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,

Line 40: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,

36: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
37: --Added new parametersby Bo Li for bug9305067
38: --remove the old attribute parameters Begin
39: -----------------------------------------------------------------------------
40: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
41: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
42: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
43: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
44: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,

Line 41: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,

37: --Added new parametersby Bo Li for bug9305067
38: --remove the old attribute parameters Begin
39: -----------------------------------------------------------------------------
40: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
41: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
42: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
43: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
44: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
45: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,

Line 42: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,

38: --remove the old attribute parameters Begin
39: -----------------------------------------------------------------------------
40: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
41: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
42: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
43: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
44: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
45: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
46: -----------------------------------------------------------------------------

Line 43: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,

39: -----------------------------------------------------------------------------
40: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
41: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
42: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
43: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
44: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
45: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
46: -----------------------------------------------------------------------------
47: --Added new parametersby Bo Li for bug9305067

Line 44: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,

40: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
41: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
42: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
43: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
44: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
45: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
46: -----------------------------------------------------------------------------
47: --Added new parametersby Bo Li for bug9305067
48: --remove the old attribute parameters End

Line 45: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,

41: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
42: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
43: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
44: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
45: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
46: -----------------------------------------------------------------------------
47: --Added new parametersby Bo Li for bug9305067
48: --remove the old attribute parameters End
49: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588

Line 49: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588

45: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
46: -----------------------------------------------------------------------------
47: --Added new parametersby Bo Li for bug9305067
48: --remove the old attribute parameters End
49: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
50: );
51:
52: PROCEDURE update_row(
53: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,

Line 53: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,

49: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
50: );
51:
52: PROCEDURE update_row(
53: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
54: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
55: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
56: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
57: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,

Line 54: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,

50: );
51:
52: PROCEDURE update_row(
53: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
54: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
55: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
56: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
57: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
58: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,

Line 55: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,

51:
52: PROCEDURE update_row(
53: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
54: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
55: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
56: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
57: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
58: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
59: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,

Line 56: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,

52: PROCEDURE update_row(
53: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
54: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
55: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
56: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
57: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
58: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
59: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
60: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,

Line 57: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,

53: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
54: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
55: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
56: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
57: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
58: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
59: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
60: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
61: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,

Line 58: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,

54: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
55: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
56: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
57: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
58: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
59: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
60: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
61: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
62: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,

Line 59: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,

55: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
56: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
57: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
58: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
59: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
60: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
61: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
62: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
63: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,

Line 60: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,

56: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
57: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
58: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
59: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
60: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
61: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
62: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
63: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
64: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,

Line 61: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,

57: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
58: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
59: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
60: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
61: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
62: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
63: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
64: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
65: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,

Line 62: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,

58: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
59: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
60: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
61: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
62: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
63: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
64: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
65: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
66: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,

Line 63: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,

59: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
60: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
61: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
62: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
63: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
64: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
65: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
66: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
67: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,

Line 64: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,

60: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
61: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
62: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
63: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
64: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
65: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
66: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
67: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
68: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,

Line 65: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,

61: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
62: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
63: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
64: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
65: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
66: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
67: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
68: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
69: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,

Line 66: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,

62: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
63: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
64: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
65: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
66: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
67: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
68: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
69: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
70: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,

Line 67: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,

63: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
64: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
65: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
66: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
67: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
68: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
69: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
70: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
71: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,

Line 68: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,

64: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
65: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
66: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
67: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
68: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
69: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
70: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
71: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
72: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,

Line 69: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,

65: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
66: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
67: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
68: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
69: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
70: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
71: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
72: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
73: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,

Line 70: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,

66: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
67: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
68: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
69: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
70: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
71: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
72: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
73: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
74: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,

Line 71: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,

67: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
68: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
69: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
70: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
71: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
72: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
73: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
74: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
75: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,

Line 72: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,

68: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
69: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
70: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
71: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
72: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
73: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
74: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
75: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
76: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,

Line 73: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,

69: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
70: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
71: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
72: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
73: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
74: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
75: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
76: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
77: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,

Line 74: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,

70: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
71: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
72: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
73: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
74: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
75: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
76: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
77: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
78: --Added new parametersby Bo Li for bug9305067

Line 75: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,

71: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
72: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
73: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
74: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
75: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
76: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
77: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
78: --Added new parametersby Bo Li for bug9305067
79: --remove the old attribute parameters Begin

Line 76: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,

72: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
73: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
74: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
75: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
76: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
77: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
78: --Added new parametersby Bo Li for bug9305067
79: --remove the old attribute parameters Begin
80: -----------------------------------------------------------------------------

Line 77: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,

73: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
74: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
75: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
76: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
77: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
78: --Added new parametersby Bo Li for bug9305067
79: --remove the old attribute parameters Begin
80: -----------------------------------------------------------------------------
81: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,

Line 81: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,

77: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
78: --Added new parametersby Bo Li for bug9305067
79: --remove the old attribute parameters Begin
80: -----------------------------------------------------------------------------
81: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
82: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
83: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
84: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
85: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL,

Line 82: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,

78: --Added new parametersby Bo Li for bug9305067
79: --remove the old attribute parameters Begin
80: -----------------------------------------------------------------------------
81: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
82: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
83: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
84: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
85: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL,
86: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL,

Line 83: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,

79: --remove the old attribute parameters Begin
80: -----------------------------------------------------------------------------
81: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
82: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
83: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
84: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
85: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL,
86: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL,
87: -----------------------------------------------------------------------------

Line 84: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,

80: -----------------------------------------------------------------------------
81: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
82: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
83: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
84: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
85: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL,
86: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL,
87: -----------------------------------------------------------------------------
88: --Added new parametersby Bo Li for bug9305067

Line 85: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL,

81: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
82: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
83: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
84: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
85: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL,
86: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL,
87: -----------------------------------------------------------------------------
88: --Added new parametersby Bo Li for bug9305067
89: --remove the old attribute parameters End

Line 86: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL,

82: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
83: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
84: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
85: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL,
86: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL,
87: -----------------------------------------------------------------------------
88: --Added new parametersby Bo Li for bug9305067
89: --remove the old attribute parameters End
90: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588

Line 90: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588

86: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL,
87: -----------------------------------------------------------------------------
88: --Added new parametersby Bo Li for bug9305067
89: --remove the old attribute parameters End
90: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
91: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
92: );
93:
94: PROCEDURE update_process_flags(

Line 91: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135

87: -----------------------------------------------------------------------------
88: --Added new parametersby Bo Li for bug9305067
89: --remove the old attribute parameters End
90: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
91: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
92: );
93:
94: PROCEDURE update_process_flags(
95: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,

Line 95: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,

91: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
92: );
93:
94: PROCEDURE update_process_flags(
95: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
96: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,
97: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
98: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
99: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,

Line 96: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,

92: );
93:
94: PROCEDURE update_process_flags(
95: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
96: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,
97: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
98: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
99: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
100: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,

Line 97: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,

93:
94: PROCEDURE update_process_flags(
95: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
96: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,
97: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
98: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
99: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
100: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
101: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,

Line 98: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,

94: PROCEDURE update_process_flags(
95: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
96: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,
97: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
98: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
99: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
100: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
101: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
102: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */

Line 99: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,

95: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
96: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,
97: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
98: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
99: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
100: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
101: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
102: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
103: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,

Line 100: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,

96: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,
97: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
98: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
99: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
100: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
101: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
102: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
103: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
104: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE

Line 101: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,

97: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
98: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
99: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
100: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
101: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
102: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
103: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
104: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
105: );

Line 103: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,

99: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
100: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
101: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
102: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
103: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
104: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
105: );
106:
107: PROCEDURE update_excise_invoice_no(

Line 104: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE

100: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
101: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
102: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
103: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
104: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
105: );
106:
107: PROCEDURE update_excise_invoice_no(
108: p_transaction_id IN NUMBER,

Line 109: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,

105: );
106:
107: PROCEDURE update_excise_invoice_no(
108: p_transaction_id IN NUMBER,
109: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
110: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
111: );
112:
113: PROCEDURE update_attributes(

Line 110: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE

106:
107: PROCEDURE update_excise_invoice_no(
108: p_transaction_id IN NUMBER,
109: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
110: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
111: );
112:
113: PROCEDURE update_attributes(
114: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,

Line 114: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,

110: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
111: );
112:
113: PROCEDURE update_attributes(
114: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
115: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
116: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
117: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
118: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,

Line 115: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

111: );
112:
113: PROCEDURE update_attributes(
114: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
115: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
116: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
117: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
118: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
119: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,

Line 116: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,

112:
113: PROCEDURE update_attributes(
114: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
115: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
116: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
117: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
118: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
119: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
120: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,

Line 117: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,

113: PROCEDURE update_attributes(
114: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
115: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
116: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
117: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
118: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
119: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
120: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
121: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,

Line 118: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,

114: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
115: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
116: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
117: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
118: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
119: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
120: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
121: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
122: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,

Line 119: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,

115: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
116: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
117: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
118: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
119: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
120: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
121: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
122: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
123: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,

Line 120: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,

116: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
117: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
118: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
119: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
120: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
121: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
122: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
123: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
124: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,

Line 121: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,

117: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
118: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
119: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
120: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
121: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
122: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
123: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
124: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
125: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL

Line 122: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,

118: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
119: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
120: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
121: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
122: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
123: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
124: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
125: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
126: );

Line 123: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,

119: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
120: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
121: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
122: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
123: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
124: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
125: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
126: );
127:

Line 124: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,

120: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
121: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
122: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
123: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
124: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
125: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
126: );
127:
128: --==========================================================================

Line 125: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL

121: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
122: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
123: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
124: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
125: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
126: );
127:
128: --==========================================================================
129: -- PROCEDURE NAME:

Line 157: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,

153: -- CHANGE HISTORY:
154: -- 15-Apr-2010 Created by Bo Li
155: --==========================================================================
156: PROCEDURE update_inv_stat_and_no (
157: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
158: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
159: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
160: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
161: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,

Line 158: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,

154: -- 15-Apr-2010 Created by Bo Li
155: --==========================================================================
156: PROCEDURE update_inv_stat_and_no (
157: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
158: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
159: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
160: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
161: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
162: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL

Line 159: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,

155: --==========================================================================
156: PROCEDURE update_inv_stat_and_no (
157: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
158: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
159: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
160: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
161: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
162: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL
163: );

Line 160: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,

156: PROCEDURE update_inv_stat_and_no (
157: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
158: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
159: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
160: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
161: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
162: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL
163: );
164:

Line 161: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,

157: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
158: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
159: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
160: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
161: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
162: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL
163: );
164:
165: --==========================================================================

Line 162: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL

158: p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
159: p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
160: p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
161: p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
162: p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL
163: );
164:
165: --==========================================================================
166: -- PROCEDURE NAME:

Line 191: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,

187: -- CHANGE HISTORY:
188: -- 15-Apr-2010 Created by Bo Li
189: --==========================================================================
190: PROCEDURE update_cenvat_costed_flag (
191: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
192: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL
193: );
194:
195:

Line 192: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL

188: -- 15-Apr-2010 Created by Bo Li
189: --==========================================================================
190: PROCEDURE update_cenvat_costed_flag (
191: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
192: p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL
193: );
194:
195:
196:

Line 197: END jai_rcv_transactions_pkg;

193: );
194:
195:
196:
197: END jai_rcv_transactions_pkg;