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 BODY jai_rcv_transactions_pkg AS

1: PACKAGE BODY jai_rcv_transactions_pkg AS
2: /* $Header: jai_rcv_trx.plb 120.1 2005/07/20 12:59:18 avallabh ship $ */
3: /*----------------------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY for FILENAME: jai_rcv_transactions_pkg.sql
5: S.No dd/mm/yyyy Author and Details

Line 4: CHANGE HISTORY for FILENAME: jai_rcv_transactions_pkg.sql

1: PACKAGE BODY jai_rcv_transactions_pkg AS
2: /* $Header: jai_rcv_trx.plb 120.1 2005/07/20 12:59:18 avallabh ship $ */
3: /*----------------------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY for FILENAME: jai_rcv_transactions_pkg.sql
5: S.No dd/mm/yyyy Author and Details
6: ------------------------------------------------------------------------------------------------------------------------------
7: 1 16/07/2004 Vijay Shankar for Bug# 3496408, Version:115.0
8: Table handler Package for JAI_RCV_TRANSACTIONS table

Line 8: Table handler Package for JAI_RCV_TRANSACTIONS table

4: CHANGE HISTORY for FILENAME: jai_rcv_transactions_pkg.sql
5: S.No dd/mm/yyyy Author and Details
6: ------------------------------------------------------------------------------------------------------------------------------
7: 1 16/07/2004 Vijay Shankar for Bug# 3496408, Version:115.0
8: Table handler Package for JAI_RCV_TRANSACTIONS table
9:
10: 2 03/01/2005 Vijay Shankar for Bug# 3940588, Version:115.1
11: Added tax_transaction_id for JAI_RCV_TRANSACTIONS table. as a result of the change, we added the corresponding
12: parameters in insert_row and update_row procedures

Line 11: Added tax_transaction_id for JAI_RCV_TRANSACTIONS table. as a result of the change, we added the corresponding

7: 1 16/07/2004 Vijay Shankar for Bug# 3496408, Version:115.0
8: Table handler Package for JAI_RCV_TRANSACTIONS table
9:
10: 2 03/01/2005 Vijay Shankar for Bug# 3940588, Version:115.1
11: Added tax_transaction_id for JAI_RCV_TRANSACTIONS table. as a result of the change, we added the corresponding
12: parameters in insert_row and update_row procedures
13:
14: 3 19/03/2005 Vijay Shankar for Bug#4250236(4245089). FileVersion: 115.2
15: added two more parameters in update_process_flags procedure as part of VAT Implementation to update

Line 26: And added the update for jai_rcv_transactions.tax_apportion_factor

22: Ramananda for bug#4428980. Removal of SQL LITERALs is done
23:
24: 6. 17-Jul-2005 Sanjikum for Bug#4495135, File Version 117.1
25: 1) In the procedure update_row, added parameter - p_tax_apportion_factor.
26: And added the update for jai_rcv_transactions.tax_apportion_factor
27:
28:
29: Dependancy:
30: -----------

Line 36: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,

32: IN60106 + 3940588 + 4245089
33: ----------------------------------------------------------------------------------------------------------------------------*/
34:
35: PROCEDURE insert_row(
36: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
37: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
38: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
39: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
40: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,

Line 37: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,

33: ----------------------------------------------------------------------------------------------------------------------------*/
34:
35: PROCEDURE insert_row(
36: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
37: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
38: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
39: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
40: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
41: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,

Line 38: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,

34:
35: PROCEDURE insert_row(
36: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
37: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
38: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
39: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
40: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
41: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
42: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,

Line 39: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,

35: PROCEDURE insert_row(
36: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
37: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
38: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
39: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
40: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
41: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
42: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
43: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,

Line 40: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,

36: p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
37: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
38: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
39: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
40: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
41: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
42: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
43: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
44: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,

Line 41: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,

37: p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
38: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
39: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
40: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
41: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
42: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
43: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
44: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
45: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,

Line 42: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,

38: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
39: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
40: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
41: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
42: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
43: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
44: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
45: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
46: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,

Line 43: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,

39: p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
40: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
41: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
42: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
43: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
44: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
45: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
46: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
47: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,

Line 44: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,

40: p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
41: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
42: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
43: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
44: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
45: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
46: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
47: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
48: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,

Line 45: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,

41: p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
42: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
43: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
44: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
45: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
46: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
47: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
48: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
49: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,

Line 46: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,

42: p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
43: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
44: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
45: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
46: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
47: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
48: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
49: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
50: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,

Line 47: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,

43: p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
44: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
45: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
46: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
47: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
48: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
49: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
50: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
51: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,

Line 48: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,

44: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
45: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
46: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
47: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
48: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
49: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
50: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
51: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
52: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,

Line 49: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,

45: p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
46: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
47: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
48: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
49: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
50: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
51: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
52: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
53: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,

Line 50: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,

46: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
47: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
48: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
49: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
50: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
51: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
52: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
53: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
54: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,

Line 51: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,

47: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
48: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
49: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
50: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
51: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
52: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
53: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
54: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
55: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,

Line 52: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,

48: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
49: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
50: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
51: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
52: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
53: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
54: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
55: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
56: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,

Line 53: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,

49: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
50: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
51: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
52: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
53: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
54: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
55: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
56: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
57: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,

Line 54: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,

50: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
51: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
52: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
53: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
54: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
55: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
56: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
57: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
58: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,

Line 55: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,

51: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
52: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
53: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
54: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
55: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
56: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
57: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
58: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
59: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,

Line 56: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,

52: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
53: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
54: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
55: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
56: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
57: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
58: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
59: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
60: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,

Line 57: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,

53: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
54: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
55: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
56: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
57: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
58: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
59: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
60: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
61: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,

Line 58: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,

54: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
55: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
56: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
57: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
58: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
59: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
60: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
61: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
62: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,

Line 59: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,

55: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
56: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
57: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
58: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
59: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
60: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
61: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
62: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
63: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,

Line 60: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,

56: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
57: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
58: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
59: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
60: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
61: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
62: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
63: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
64: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,

Line 61: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,

57: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
58: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
59: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
60: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
61: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
62: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
63: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
64: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
65: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,

Line 62: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,

58: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
59: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
60: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
61: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
62: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
63: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
64: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
65: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
66: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,

Line 63: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,

59: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
60: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
61: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
62: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
63: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
64: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
65: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
66: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
67: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,

Line 64: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,

60: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
61: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
62: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
63: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
64: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
65: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
66: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
67: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
68: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,

Line 65: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,

61: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
62: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
63: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
64: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
65: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
66: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
67: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
68: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
69: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,

Line 66: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,

62: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
63: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
64: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
65: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
66: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
67: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
68: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
69: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
70: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,

Line 67: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,

63: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
64: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
65: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
66: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
67: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
68: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
69: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
70: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
71: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,

Line 68: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,

64: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
65: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
66: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
67: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
68: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
69: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
70: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
71: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
72: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,

Line 69: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,

65: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
66: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
67: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
68: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
69: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
70: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
71: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
72: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
73: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,

Line 70: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,

66: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
67: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
68: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
69: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
70: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
71: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
72: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
73: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
74: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,

Line 71: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,

67: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
68: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
69: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
70: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
71: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
72: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
73: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
74: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
75: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,

Line 72: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,

68: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
69: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
70: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
71: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
72: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
73: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
74: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
75: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
76: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,

Line 73: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,

69: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
70: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
71: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
72: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
73: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
74: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
75: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
76: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
77: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,

Line 74: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,

70: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
71: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
72: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
73: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
74: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
75: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
76: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
77: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
78: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,

Line 75: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,

71: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
72: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
73: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
74: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
75: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
76: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
77: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
78: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,
79: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588

Line 76: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,

72: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
73: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
74: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
75: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
76: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
77: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
78: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,
79: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
80: ) IS

Line 77: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,

73: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
74: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
75: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
76: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
77: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
78: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,
79: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
80: ) IS
81:

Line 78: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,

74: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
75: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
76: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
77: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
78: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,
79: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
80: ) IS
81:
82: lv_creation_date DATE;

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

75: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
76: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
77: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
78: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,
79: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
80: ) IS
81:
82: lv_creation_date DATE;
83: lv_created_by NUMBER(15);

Line 96: INSERT INTO JAI_RCV_TRANSACTIONS(

92: lv_last_update_date := SYSDATE;
93: lv_last_updated_by := lv_created_by;
94: lv_last_update_login := FND_GLOBAL.login_id;
95:
96: INSERT INTO JAI_RCV_TRANSACTIONS(
97: shipment_header_id, shipment_line_id, transaction_id, transaction_type, quantity, uom_code,
98: transaction_date, parent_transaction_id, parent_transaction_type, receipt_num, organization_id,
99: location_id, inventory_item_id, item_class, item_cenvatable, item_excisable, item_trading_flag,
100: inv_item_flag, inv_asset_flag, loc_subinv_type, BASE_ASSET_INVENTORY, organization_type,

Line 123: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,

119:
120: END insert_row;
121:
122: PROCEDURE update_row(
123: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
124: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
125: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
126: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
127: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,

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

120: END insert_row;
121:
122: PROCEDURE update_row(
123: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
124: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
125: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
126: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
127: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
128: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,

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

121:
122: PROCEDURE update_row(
123: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
124: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
125: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
126: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
127: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
128: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
129: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,

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

122: PROCEDURE update_row(
123: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
124: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
125: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
126: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
127: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
128: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
129: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
130: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,

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

123: p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
124: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
125: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
126: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
127: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
128: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
129: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
130: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
131: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,

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

124: p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
125: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
126: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
127: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
128: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
129: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
130: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
131: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
132: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,

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

125: p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
126: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
127: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
128: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
129: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
130: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
131: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
132: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
133: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,

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

126: p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
127: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
128: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
129: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
130: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
131: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
132: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
133: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
134: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,

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

127: p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
128: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
129: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
130: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
131: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
132: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
133: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
134: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
135: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,

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

128: p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
129: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
130: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
131: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
132: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
133: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
134: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
135: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
136: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,

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

129: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
130: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
131: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
132: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
133: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
134: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
135: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
136: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
137: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,

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

130: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
131: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
132: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
133: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
134: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
135: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
136: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
137: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
138: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,

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

131: p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
132: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
133: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
134: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
135: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
136: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
137: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
138: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
139: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,

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

132: p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
133: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
134: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
135: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
136: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
137: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
138: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
139: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
140: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,

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

133: p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
134: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
135: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
136: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
137: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
138: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
139: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
140: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
141: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,

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

134: p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
135: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
136: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
137: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
138: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
139: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
140: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
141: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
142: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,

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

135: p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
136: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
137: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
138: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
139: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
140: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
141: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
142: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
143: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,

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

136: p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
137: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
138: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
139: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
140: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
141: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
142: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
143: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
144: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,

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

137: p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
138: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
139: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
140: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
141: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
142: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
143: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
144: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
145: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,

Line 142: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,

138: p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
139: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
140: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
141: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
142: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
143: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
144: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
145: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
146: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,

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

139: p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
140: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
141: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
142: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
143: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
144: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
145: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
146: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
147: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,

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

140: p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
141: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
142: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
143: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
144: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
145: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
146: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
147: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
148: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

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

141: p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
142: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
143: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
144: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
145: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
146: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
147: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
148: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
149: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,

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

142: p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
143: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
144: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
145: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
146: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
147: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
148: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
149: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
150: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,

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

143: p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
144: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
145: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
146: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
147: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
148: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
149: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
150: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
151: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,

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

144: p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
145: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
146: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
147: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
148: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
149: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
150: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
151: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
152: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,

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

145: p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
146: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
147: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
148: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
149: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
150: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
151: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
152: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
153: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,

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

146: p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
147: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
148: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
149: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
150: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
151: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
152: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
153: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
154: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,

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

147: p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
148: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
149: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
150: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
151: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
152: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
153: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
154: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
155: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,

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

148: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
149: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
150: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
151: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
152: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
153: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
154: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
155: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
156: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,

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

149: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
150: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
151: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
152: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
153: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
154: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
155: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
156: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
157: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,

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

150: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
151: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
152: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
153: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
154: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
155: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
156: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
157: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
158: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,

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

151: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
152: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
153: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
154: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
155: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
156: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
157: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
158: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
159: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588

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

152: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
153: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
154: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
155: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
156: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
157: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
158: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
159: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
160: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135

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

153: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
154: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
155: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
156: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
157: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
158: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
159: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
160: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
161: ) IS

Line 158: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,

154: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
155: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
156: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
157: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
158: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
159: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
160: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
161: ) IS
162:

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

155: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
156: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
157: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
158: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
159: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
160: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
161: ) IS
162:
163: lv_last_update_date DATE;

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

156: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
157: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
158: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
159: p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
160: p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
161: ) IS
162:
163: lv_last_update_date DATE;
164: lv_last_updated_by NUMBER(15);

Line 173: UPDATE JAI_RCV_TRANSACTIONS SET

169: lv_last_update_date := SYSDATE;
170: lv_last_updated_by := FND_GLOBAL.user_id;
171: lv_last_update_login := FND_GLOBAL.login_id;
172:
173: UPDATE JAI_RCV_TRANSACTIONS SET
174: PARENT_TRANSACTION_TYPE = nvl(P_PARENT_TRANSACTION_TYPE, PARENT_TRANSACTION_TYPE),
175: RECEIPT_NUM = nvl(P_RECEIPT_NUM, RECEIPT_NUM),
176: ORGANIZATION_ID = nvl(P_ORGANIZATION_ID, ORGANIZATION_ID),
177: LOCATION_ID = nvl(P_LOCATION_ID, LOCATION_ID),

Line 219: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,

215:
216: END update_row;
217:
218: PROCEDURE update_process_flags(
219: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
220: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,
221: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
222: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
223: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,

Line 220: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,

216: END update_row;
217:
218: PROCEDURE update_process_flags(
219: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
220: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,
221: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
222: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
223: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
224: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,

Line 221: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,

217:
218: PROCEDURE update_process_flags(
219: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
220: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,
221: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
222: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
223: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
224: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
225: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,

Line 222: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,

218: PROCEDURE update_process_flags(
219: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
220: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,
221: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
222: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
223: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
224: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
225: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
226: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */

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

219: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
220: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,
221: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
222: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
223: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
224: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
225: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
226: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
227: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,

Line 224: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,

220: p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,
221: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
222: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
223: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
224: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
225: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
226: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
227: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
228: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE

Line 225: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,

221: p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
222: p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
223: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
224: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
225: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
226: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
227: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
228: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
229: ) IS

Line 227: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,

223: p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
224: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
225: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
226: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
227: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
228: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
229: ) IS
230:
231: BEGIN

Line 228: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE

224: p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
225: p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
226: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
227: p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
228: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
229: ) IS
230:
231: BEGIN
232: UPDATE JAI_RCV_TRANSACTIONS

Line 232: UPDATE JAI_RCV_TRANSACTIONS

228: p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
229: ) IS
230:
231: BEGIN
232: UPDATE JAI_RCV_TRANSACTIONS
233: SET
234: PROCESS_STATUS = nvl(p_process_flag, PROCESS_STATUS),
235: process_message = nvl(p_process_message, process_message),
236: CENVAT_RG_STATUS = nvl(p_cenvat_rg_flag, CENVAT_RG_STATUS),

Line 252: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,

248: END update_process_flags;
249:
250: PROCEDURE update_excise_invoice_no(
251: p_transaction_id IN NUMBER,
252: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
253: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
254: ) IS
255:
256: BEGIN

Line 253: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE

249:
250: PROCEDURE update_excise_invoice_no(
251: p_transaction_id IN NUMBER,
252: p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
253: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
254: ) IS
255:
256: BEGIN
257: UPDATE JAI_RCV_TRANSACTIONS

Line 257: UPDATE JAI_RCV_TRANSACTIONS

253: p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
254: ) IS
255:
256: BEGIN
257: UPDATE JAI_RCV_TRANSACTIONS
258: SET excise_invoice_no = p_excise_invoice_no,
259: excise_invoice_date = p_excise_invoice_date,
260: last_updated_by = fnd_global.user_id,
261: last_update_login = fnd_global.login_id,

Line 268: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,

264:
265: END update_excise_invoice_no;
266:
267: PROCEDURE update_attributes(
268: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
269: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
270: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
271: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
272: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,

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

265: END update_excise_invoice_no;
266:
267: PROCEDURE update_attributes(
268: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
269: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
270: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
271: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
272: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
273: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,

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

266:
267: PROCEDURE update_attributes(
268: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
269: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
270: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
271: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
272: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
273: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
274: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,

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

267: PROCEDURE update_attributes(
268: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
269: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
270: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
271: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
272: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
273: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
274: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
275: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,

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

268: p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
269: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
270: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
271: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
272: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
273: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
274: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
275: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
276: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,

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

269: p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
270: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
271: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
272: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
273: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
274: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
275: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
276: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
277: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,

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

270: p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
271: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
272: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
273: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
274: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
275: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
276: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
277: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
278: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,

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

271: p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
272: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
273: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
274: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
275: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
276: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
277: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
278: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
279: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL

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

272: p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
273: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
274: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
275: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
276: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
277: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
278: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
279: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
280: ) IS

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

273: p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
274: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
275: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
276: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
277: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
278: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
279: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
280: ) IS
281:

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

274: p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
275: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
276: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
277: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
278: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
279: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
280: ) IS
281:
282: BEGIN

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

275: p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
276: p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
277: p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
278: p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
279: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
280: ) IS
281:
282: BEGIN
283: UPDATE JAI_RCV_TRANSACTIONS SET

Line 283: UPDATE JAI_RCV_TRANSACTIONS SET

279: p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
280: ) IS
281:
282: BEGIN
283: UPDATE JAI_RCV_TRANSACTIONS SET
284: ATTRIBUTE_CATEGORY = nvl(P_ATTRIBUTE_CATEGORY, ATTRIBUTE_CATEGORY),
285: ATTRIBUTE1 = nvl(P_ATTRIBUTE1, ATTRIBUTE1),
286: ATTRIBUTE2 = nvl(P_ATTRIBUTE2, ATTRIBUTE2),
287: ATTRIBUTE3 = nvl(P_ATTRIBUTE3, ATTRIBUTE3),

Line 302: END jai_rcv_transactions_pkg;

298: WHERE transaction_id = p_transaction_id;
299:
300: END update_attributes;
301:
302: END jai_rcv_transactions_pkg;