[Home] [Help]
1: PACKAGE BODY jai_cmn_rg_23d_trxs_pkg AS
2: /* $Header: jai_cmn_rg_23d.plb 120.3 2007/08/07 09:45:14 vkaranam ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename:
17:
18: */
19:
20: PROCEDURE insert_row(
21: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23D_TRXS.register_id%TYPE,
22: P_ORGANIZATION_ID IN JAI_CMN_RG_23D_TRXS.organization_id%TYPE,
23: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE,
24: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE,
25: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE,
18: */
19:
20: PROCEDURE insert_row(
21: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23D_TRXS.register_id%TYPE,
22: P_ORGANIZATION_ID IN JAI_CMN_RG_23D_TRXS.organization_id%TYPE,
23: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE,
24: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE,
25: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE,
26: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE,
19:
20: PROCEDURE insert_row(
21: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23D_TRXS.register_id%TYPE,
22: P_ORGANIZATION_ID IN JAI_CMN_RG_23D_TRXS.organization_id%TYPE,
23: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE,
24: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE,
25: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE,
26: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE,
27: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE,
20: PROCEDURE insert_row(
21: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23D_TRXS.register_id%TYPE,
22: P_ORGANIZATION_ID IN JAI_CMN_RG_23D_TRXS.organization_id%TYPE,
23: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE,
24: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE,
25: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE,
26: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE,
27: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE,
28: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE,
21: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23D_TRXS.register_id%TYPE,
22: P_ORGANIZATION_ID IN JAI_CMN_RG_23D_TRXS.organization_id%TYPE,
23: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE,
24: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE,
25: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE,
26: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE,
27: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE,
28: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE,
29: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE,
22: P_ORGANIZATION_ID IN JAI_CMN_RG_23D_TRXS.organization_id%TYPE,
23: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE,
24: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE,
25: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE,
26: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE,
27: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE,
28: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE,
29: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE,
30: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE,
23: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE,
24: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE,
25: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE,
26: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE,
27: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE,
28: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE,
29: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE,
30: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE,
31: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE,
24: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE,
25: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE,
26: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE,
27: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE,
28: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE,
29: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE,
30: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE,
31: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE,
32: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE,
25: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE,
26: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE,
27: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE,
28: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE,
29: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE,
30: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE,
31: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE,
32: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE,
33: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE,
26: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE,
27: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE,
28: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE,
29: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE,
30: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE,
31: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE,
32: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE,
33: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE,
34: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE,
27: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE,
28: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE,
29: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE,
30: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE,
31: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE,
32: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE,
33: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE,
34: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE,
35: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE,
28: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE,
29: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE,
30: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE,
31: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE,
32: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE,
33: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE,
34: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE,
35: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE,
36: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE,
29: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE,
30: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE,
31: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE,
32: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE,
33: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE,
34: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE,
35: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE,
36: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE,
37: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE,
30: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE,
31: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE,
32: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE,
33: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE,
34: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE,
35: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE,
36: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE,
37: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE,
38: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE,
31: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE,
32: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE,
33: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE,
34: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE,
35: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE,
36: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE,
37: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE,
38: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE,
39: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE,
32: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE,
33: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE,
34: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE,
35: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE,
36: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE,
37: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE,
38: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE,
39: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE,
40: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE,
33: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE,
34: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE,
35: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE,
36: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE,
37: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE,
38: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE,
39: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE,
40: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE,
41: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE,
34: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE,
35: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE,
36: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE,
37: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE,
38: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE,
39: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE,
40: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE,
41: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE,
42: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE,
35: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE,
36: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE,
37: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE,
38: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE,
39: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE,
40: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE,
41: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE,
42: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE,
43: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE,
36: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE,
37: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE,
38: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE,
39: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE,
40: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE,
41: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE,
42: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE,
43: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE,
44: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE,
37: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE,
38: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE,
39: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE,
40: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE,
41: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE,
42: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE,
43: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE,
44: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE,
45: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE,
38: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE,
39: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE,
40: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE,
41: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE,
42: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE,
43: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE,
44: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE,
45: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE,
46: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE,
39: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE,
40: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE,
41: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE,
42: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE,
43: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE,
44: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE,
45: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE,
46: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE,
47: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE,
40: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE,
41: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE,
42: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE,
43: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE,
44: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE,
45: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE,
46: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE,
47: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE,
48: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE,
41: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE,
42: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE,
43: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE,
44: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE,
45: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE,
46: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE,
47: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE,
48: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE,
49: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE,
42: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE,
43: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE,
44: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE,
45: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE,
46: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE,
47: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE,
48: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE,
49: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE,
50: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE,
43: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE,
44: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE,
45: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE,
46: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE,
47: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE,
48: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE,
49: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE,
50: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE,
51: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE,
44: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE,
45: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE,
46: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE,
47: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE,
48: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE,
49: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE,
50: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE,
51: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE,
52: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE,
45: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE,
46: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE,
47: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE,
48: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE,
49: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE,
50: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE,
51: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE,
52: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE,
53: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE,
46: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE,
47: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE,
48: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE,
49: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE,
50: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE,
51: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE,
52: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE,
53: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE,
54: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE,
47: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE,
48: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE,
49: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE,
50: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE,
51: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE,
52: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE,
53: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE,
54: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE,
55: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE,
48: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE,
49: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE,
50: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE,
51: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE,
52: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE,
53: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE,
54: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE,
55: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE,
56: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
49: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE,
50: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE,
51: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE,
52: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE,
53: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE,
54: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE,
55: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE,
56: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
57: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE,
50: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE,
51: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE,
52: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE,
53: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE,
54: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE,
55: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE,
56: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
57: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE,
58: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE,
51: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE,
52: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE,
53: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE,
54: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE,
55: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE,
56: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
57: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE,
58: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE,
59: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE,
52: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE,
53: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE,
54: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE,
55: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE,
56: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
57: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE,
58: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE,
59: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE,
60: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE,
53: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE,
54: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE,
55: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE,
56: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
57: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE,
58: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE,
59: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE,
60: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE,
61: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE,
54: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE,
55: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE,
56: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
57: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE,
58: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE,
59: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE,
60: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE,
61: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE,
62: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE,
55: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE,
56: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
57: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE,
58: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE,
59: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE,
60: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE,
61: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE,
62: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE,
63: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE,
56: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
57: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE,
58: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE,
59: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE,
60: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE,
61: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE,
62: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE,
63: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE,
64: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE,
57: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE,
58: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE,
59: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE,
60: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE,
61: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE,
62: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE,
63: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE,
64: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE,
65: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE,
58: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE,
59: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE,
60: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE,
61: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE,
62: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE,
63: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE,
64: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE,
65: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE,
66: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE,
59: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE,
60: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE,
61: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE,
62: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE,
63: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE,
64: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE,
65: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE,
66: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE,
67: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE,
60: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE,
61: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE,
62: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE,
63: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE,
64: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE,
65: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE,
66: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE,
67: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE,
68: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE,
61: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE,
62: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE,
63: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE,
64: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE,
65: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE,
66: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE,
67: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE,
68: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE,
69: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE,
62: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE,
63: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE,
64: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE,
65: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE,
66: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE,
67: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE,
68: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE,
69: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE,
70: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE,
63: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE,
64: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE,
65: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE,
66: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE,
67: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE,
68: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE,
69: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE,
70: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE,
71: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE,
64: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE,
65: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE,
66: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE,
67: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE,
68: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE,
69: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE,
70: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE,
71: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE,
72: P_TOT_AMT_PAID_TO_MANUFACTURER IN JAI_CMN_RG_23D_TRXS.tot_amt_paid_to_manufacturer%TYPE,
65: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE,
66: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE,
67: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE,
68: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE,
69: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE,
70: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE,
71: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE,
72: P_TOT_AMT_PAID_TO_MANUFACTURER IN JAI_CMN_RG_23D_TRXS.tot_amt_paid_to_manufacturer%TYPE,
73: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
66: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE,
67: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE,
68: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE,
69: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE,
70: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE,
71: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE,
72: P_TOT_AMT_PAID_TO_MANUFACTURER IN JAI_CMN_RG_23D_TRXS.tot_amt_paid_to_manufacturer%TYPE,
73: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
74: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23D_TRXS.other_tax_credit%TYPE,
67: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE,
68: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE,
69: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE,
70: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE,
71: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE,
72: P_TOT_AMT_PAID_TO_MANUFACTURER IN JAI_CMN_RG_23D_TRXS.tot_amt_paid_to_manufacturer%TYPE,
73: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
74: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23D_TRXS.other_tax_credit%TYPE,
75: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23D_TRXS.other_tax_debit%TYPE,
68: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE,
69: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE,
70: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE,
71: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE,
72: P_TOT_AMT_PAID_TO_MANUFACTURER IN JAI_CMN_RG_23D_TRXS.tot_amt_paid_to_manufacturer%TYPE,
73: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
74: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23D_TRXS.other_tax_credit%TYPE,
75: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23D_TRXS.other_tax_debit%TYPE,
76: P_TRANSACTION_SOURCE IN VARCHAR2,
70: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE,
71: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE,
72: P_TOT_AMT_PAID_TO_MANUFACTURER IN JAI_CMN_RG_23D_TRXS.tot_amt_paid_to_manufacturer%TYPE,
73: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
74: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23D_TRXS.other_tax_credit%TYPE,
75: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23D_TRXS.other_tax_debit%TYPE,
76: P_TRANSACTION_SOURCE IN VARCHAR2,
77: P_CALLED_FROM IN VARCHAR2,
78: P_SIMULATE_FLAG IN VARCHAR2,
71: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE,
72: P_TOT_AMT_PAID_TO_MANUFACTURER IN JAI_CMN_RG_23D_TRXS.tot_amt_paid_to_manufacturer%TYPE,
73: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
74: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23D_TRXS.other_tax_credit%TYPE,
75: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23D_TRXS.other_tax_debit%TYPE,
76: P_TRANSACTION_SOURCE IN VARCHAR2,
77: P_CALLED_FROM IN VARCHAR2,
78: P_SIMULATE_FLAG IN VARCHAR2,
79: P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
87: ln_last_update_login NUMBER(15);
88:
89: ln_last_register_id NUMBER;
90: ln_slno NUMBER(10) := 0;
91: ln_fin_year JAI_CMN_RG_23D_TRXS.fin_year%TYPE;
92: ln_transaction_id NUMBER(10);
93: lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
94:
95: ln_quantity NUMBER;
110:
111: BEGIN
112:
113: /*----------------------------------------------------------------------------------------------------------------------------
114: CHANGE HISTORY for FILENAME: jai_cmn_rg_23d_trxs_pkg.sql
115: S.No dd/mm/yyyy Author and Details
116: ------------------------------------------------------------------------------------------------------------------------------
117: 1 16/07/2004 Vijay Shankar for Bug# 3496408, Version:115.0
118: Table handler Package for JAI_CMN_RG_23D_TRXS table
114: CHANGE HISTORY for FILENAME: jai_cmn_rg_23d_trxs_pkg.sql
115: S.No dd/mm/yyyy Author and Details
116: ------------------------------------------------------------------------------------------------------------------------------
117: 1 16/07/2004 Vijay Shankar for Bug# 3496408, Version:115.0
118: Table handler Package for JAI_CMN_RG_23D_TRXS table
119:
120: 2 03/01/2005 Vijay Shankar for Bug# 3940588, Version:115.1
121: Modified Insert and Update procedures to include p_other_tax_credit and p_other_tax_debit parameters for
122: Education Cess Enhancement
174: ln_opening_balance_qty := nvl(r_last_record.closing_balance_qty, 0);
175: ln_closing_balance_qty := ln_opening_balance_qty + ln_quantity;
176:
177: lv_statement_id := '8';
178: INSERT INTO JAI_CMN_RG_23D_TRXS(
179: REGISTER_ID,
180: ORGANIZATION_ID,
181: LOCATION_ID,
182: SLNO,
242: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
243: other_tax_credit,
244: other_tax_debit
245: ) VALUES (
246: JAI_CMN_RG_23D_TRXS_S.nextval,
247: P_ORGANIZATION_ID,
248: P_LOCATION_ID,
249: ln_slno, --
250: ln_fin_year, --
328: END insert_row;
329:
330: PROCEDURE update_row(
331:
332: P_REGISTER_ID IN JAI_CMN_RG_23D_TRXS.register_id%TYPE DEFAULT NULL,
333: P_ORGANIZATION_ID IN JAI_CMN_RG_23D_TRXS.organization_id%TYPE DEFAULT NULL,
334: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE DEFAULT NULL,
335: P_SLNO IN JAI_CMN_RG_23D_TRXS.slno%TYPE DEFAULT NULL,
336: P_FIN_YEAR IN JAI_CMN_RG_23D_TRXS.fin_year%TYPE DEFAULT NULL,
329:
330: PROCEDURE update_row(
331:
332: P_REGISTER_ID IN JAI_CMN_RG_23D_TRXS.register_id%TYPE DEFAULT NULL,
333: P_ORGANIZATION_ID IN JAI_CMN_RG_23D_TRXS.organization_id%TYPE DEFAULT NULL,
334: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE DEFAULT NULL,
335: P_SLNO IN JAI_CMN_RG_23D_TRXS.slno%TYPE DEFAULT NULL,
336: P_FIN_YEAR IN JAI_CMN_RG_23D_TRXS.fin_year%TYPE DEFAULT NULL,
337: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE DEFAULT NULL,
330: PROCEDURE update_row(
331:
332: P_REGISTER_ID IN JAI_CMN_RG_23D_TRXS.register_id%TYPE DEFAULT NULL,
333: P_ORGANIZATION_ID IN JAI_CMN_RG_23D_TRXS.organization_id%TYPE DEFAULT NULL,
334: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE DEFAULT NULL,
335: P_SLNO IN JAI_CMN_RG_23D_TRXS.slno%TYPE DEFAULT NULL,
336: P_FIN_YEAR IN JAI_CMN_RG_23D_TRXS.fin_year%TYPE DEFAULT NULL,
337: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE DEFAULT NULL,
338: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
331:
332: P_REGISTER_ID IN JAI_CMN_RG_23D_TRXS.register_id%TYPE DEFAULT NULL,
333: P_ORGANIZATION_ID IN JAI_CMN_RG_23D_TRXS.organization_id%TYPE DEFAULT NULL,
334: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE DEFAULT NULL,
335: P_SLNO IN JAI_CMN_RG_23D_TRXS.slno%TYPE DEFAULT NULL,
336: P_FIN_YEAR IN JAI_CMN_RG_23D_TRXS.fin_year%TYPE DEFAULT NULL,
337: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE DEFAULT NULL,
338: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
339: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE DEFAULT NULL,
332: P_REGISTER_ID IN JAI_CMN_RG_23D_TRXS.register_id%TYPE DEFAULT NULL,
333: P_ORGANIZATION_ID IN JAI_CMN_RG_23D_TRXS.organization_id%TYPE DEFAULT NULL,
334: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE DEFAULT NULL,
335: P_SLNO IN JAI_CMN_RG_23D_TRXS.slno%TYPE DEFAULT NULL,
336: P_FIN_YEAR IN JAI_CMN_RG_23D_TRXS.fin_year%TYPE DEFAULT NULL,
337: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE DEFAULT NULL,
338: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
339: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE DEFAULT NULL,
340: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE DEFAULT NULL,
333: P_ORGANIZATION_ID IN JAI_CMN_RG_23D_TRXS.organization_id%TYPE DEFAULT NULL,
334: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE DEFAULT NULL,
335: P_SLNO IN JAI_CMN_RG_23D_TRXS.slno%TYPE DEFAULT NULL,
336: P_FIN_YEAR IN JAI_CMN_RG_23D_TRXS.fin_year%TYPE DEFAULT NULL,
337: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE DEFAULT NULL,
338: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
339: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE DEFAULT NULL,
340: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE DEFAULT NULL,
341: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE DEFAULT NULL,
334: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE DEFAULT NULL,
335: P_SLNO IN JAI_CMN_RG_23D_TRXS.slno%TYPE DEFAULT NULL,
336: P_FIN_YEAR IN JAI_CMN_RG_23D_TRXS.fin_year%TYPE DEFAULT NULL,
337: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE DEFAULT NULL,
338: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
339: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE DEFAULT NULL,
340: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE DEFAULT NULL,
341: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE DEFAULT NULL,
342: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE DEFAULT NULL,
335: P_SLNO IN JAI_CMN_RG_23D_TRXS.slno%TYPE DEFAULT NULL,
336: P_FIN_YEAR IN JAI_CMN_RG_23D_TRXS.fin_year%TYPE DEFAULT NULL,
337: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE DEFAULT NULL,
338: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
339: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE DEFAULT NULL,
340: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE DEFAULT NULL,
341: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE DEFAULT NULL,
342: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE DEFAULT NULL,
343: P_PRIMARY_UOM_CODE IN JAI_CMN_RG_23D_TRXS.primary_uom_code%TYPE DEFAULT NULL,
336: P_FIN_YEAR IN JAI_CMN_RG_23D_TRXS.fin_year%TYPE DEFAULT NULL,
337: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE DEFAULT NULL,
338: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
339: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE DEFAULT NULL,
340: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE DEFAULT NULL,
341: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE DEFAULT NULL,
342: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE DEFAULT NULL,
343: P_PRIMARY_UOM_CODE IN JAI_CMN_RG_23D_TRXS.primary_uom_code%TYPE DEFAULT NULL,
344: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE DEFAULT NULL,
337: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE DEFAULT NULL,
338: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
339: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE DEFAULT NULL,
340: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE DEFAULT NULL,
341: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE DEFAULT NULL,
342: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE DEFAULT NULL,
343: P_PRIMARY_UOM_CODE IN JAI_CMN_RG_23D_TRXS.primary_uom_code%TYPE DEFAULT NULL,
344: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE DEFAULT NULL,
345: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE DEFAULT NULL,
338: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
339: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE DEFAULT NULL,
340: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE DEFAULT NULL,
341: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE DEFAULT NULL,
342: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE DEFAULT NULL,
343: P_PRIMARY_UOM_CODE IN JAI_CMN_RG_23D_TRXS.primary_uom_code%TYPE DEFAULT NULL,
344: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE DEFAULT NULL,
345: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE DEFAULT NULL,
346: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE DEFAULT NULL,
339: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE DEFAULT NULL,
340: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE DEFAULT NULL,
341: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE DEFAULT NULL,
342: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE DEFAULT NULL,
343: P_PRIMARY_UOM_CODE IN JAI_CMN_RG_23D_TRXS.primary_uom_code%TYPE DEFAULT NULL,
344: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE DEFAULT NULL,
345: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE DEFAULT NULL,
346: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE DEFAULT NULL,
347: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE DEFAULT NULL,
340: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE DEFAULT NULL,
341: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE DEFAULT NULL,
342: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE DEFAULT NULL,
343: P_PRIMARY_UOM_CODE IN JAI_CMN_RG_23D_TRXS.primary_uom_code%TYPE DEFAULT NULL,
344: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE DEFAULT NULL,
345: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE DEFAULT NULL,
346: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE DEFAULT NULL,
347: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE DEFAULT NULL,
348: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE DEFAULT NULL,
341: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE DEFAULT NULL,
342: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE DEFAULT NULL,
343: P_PRIMARY_UOM_CODE IN JAI_CMN_RG_23D_TRXS.primary_uom_code%TYPE DEFAULT NULL,
344: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE DEFAULT NULL,
345: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE DEFAULT NULL,
346: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE DEFAULT NULL,
347: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE DEFAULT NULL,
348: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE DEFAULT NULL,
349: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE DEFAULT NULL,
342: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE DEFAULT NULL,
343: P_PRIMARY_UOM_CODE IN JAI_CMN_RG_23D_TRXS.primary_uom_code%TYPE DEFAULT NULL,
344: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE DEFAULT NULL,
345: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE DEFAULT NULL,
346: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE DEFAULT NULL,
347: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE DEFAULT NULL,
348: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE DEFAULT NULL,
349: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE DEFAULT NULL,
350: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE DEFAULT NULL,
343: P_PRIMARY_UOM_CODE IN JAI_CMN_RG_23D_TRXS.primary_uom_code%TYPE DEFAULT NULL,
344: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE DEFAULT NULL,
345: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE DEFAULT NULL,
346: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE DEFAULT NULL,
347: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE DEFAULT NULL,
348: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE DEFAULT NULL,
349: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE DEFAULT NULL,
350: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE DEFAULT NULL,
351: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE DEFAULT NULL,
344: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE DEFAULT NULL,
345: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE DEFAULT NULL,
346: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE DEFAULT NULL,
347: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE DEFAULT NULL,
348: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE DEFAULT NULL,
349: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE DEFAULT NULL,
350: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE DEFAULT NULL,
351: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE DEFAULT NULL,
352: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE DEFAULT NULL,
345: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE DEFAULT NULL,
346: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE DEFAULT NULL,
347: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE DEFAULT NULL,
348: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE DEFAULT NULL,
349: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE DEFAULT NULL,
350: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE DEFAULT NULL,
351: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE DEFAULT NULL,
352: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE DEFAULT NULL,
353: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE DEFAULT NULL,
346: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE DEFAULT NULL,
347: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE DEFAULT NULL,
348: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE DEFAULT NULL,
349: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE DEFAULT NULL,
350: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE DEFAULT NULL,
351: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE DEFAULT NULL,
352: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE DEFAULT NULL,
353: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE DEFAULT NULL,
354: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
347: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE DEFAULT NULL,
348: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE DEFAULT NULL,
349: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE DEFAULT NULL,
350: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE DEFAULT NULL,
351: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE DEFAULT NULL,
352: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE DEFAULT NULL,
353: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE DEFAULT NULL,
354: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
355: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
348: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE DEFAULT NULL,
349: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE DEFAULT NULL,
350: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE DEFAULT NULL,
351: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE DEFAULT NULL,
352: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE DEFAULT NULL,
353: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE DEFAULT NULL,
354: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
355: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
356: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
349: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE DEFAULT NULL,
350: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE DEFAULT NULL,
351: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE DEFAULT NULL,
352: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE DEFAULT NULL,
353: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE DEFAULT NULL,
354: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
355: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
356: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
357: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE DEFAULT NULL,
350: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE DEFAULT NULL,
351: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE DEFAULT NULL,
352: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE DEFAULT NULL,
353: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE DEFAULT NULL,
354: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
355: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
356: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
357: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE DEFAULT NULL,
358: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE DEFAULT NULL,
351: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE DEFAULT NULL,
352: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE DEFAULT NULL,
353: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE DEFAULT NULL,
354: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
355: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
356: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
357: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE DEFAULT NULL,
358: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE DEFAULT NULL,
359: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE DEFAULT NULL,
352: P_COMM_INVOICE_DATE IN JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE DEFAULT NULL,
353: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE DEFAULT NULL,
354: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
355: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
356: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
357: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE DEFAULT NULL,
358: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE DEFAULT NULL,
359: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE DEFAULT NULL,
360: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE DEFAULT NULL,
353: P_RECEIPT_BOE_NUM IN JAI_CMN_RG_23D_TRXS.receipt_boe_num%TYPE DEFAULT NULL,
354: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
355: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
356: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
357: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE DEFAULT NULL,
358: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE DEFAULT NULL,
359: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE DEFAULT NULL,
360: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE DEFAULT NULL,
361: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE DEFAULT NULL,
354: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
355: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
356: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
357: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE DEFAULT NULL,
358: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE DEFAULT NULL,
359: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE DEFAULT NULL,
360: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE DEFAULT NULL,
361: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE DEFAULT NULL,
362: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE DEFAULT NULL,
355: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
356: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
357: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE DEFAULT NULL,
358: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE DEFAULT NULL,
359: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE DEFAULT NULL,
360: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE DEFAULT NULL,
361: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE DEFAULT NULL,
362: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE DEFAULT NULL,
363: P_TRANSACTION_ID IN JAI_CMN_RG_23D_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
356: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23D_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
357: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE DEFAULT NULL,
358: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE DEFAULT NULL,
359: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE DEFAULT NULL,
360: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE DEFAULT NULL,
361: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE DEFAULT NULL,
362: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE DEFAULT NULL,
363: P_TRANSACTION_ID IN JAI_CMN_RG_23D_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
364: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE DEFAULT NULL,
357: P_REMARKS IN JAI_CMN_RG_23D_TRXS.remarks%TYPE DEFAULT NULL,
358: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE DEFAULT NULL,
359: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE DEFAULT NULL,
360: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE DEFAULT NULL,
361: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE DEFAULT NULL,
362: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE DEFAULT NULL,
363: P_TRANSACTION_ID IN JAI_CMN_RG_23D_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
364: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE DEFAULT NULL,
365: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE DEFAULT NULL,
358: P_QTY_TO_ADJUST IN JAI_CMN_RG_23D_TRXS.qty_to_adjust%TYPE DEFAULT NULL,
359: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE DEFAULT NULL,
360: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE DEFAULT NULL,
361: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE DEFAULT NULL,
362: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE DEFAULT NULL,
363: P_TRANSACTION_ID IN JAI_CMN_RG_23D_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
364: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE DEFAULT NULL,
365: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE DEFAULT NULL,
366: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE DEFAULT NULL,
359: P_RATE_PER_UNIT IN JAI_CMN_RG_23D_TRXS.rate_per_unit%TYPE DEFAULT NULL,
360: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE DEFAULT NULL,
361: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE DEFAULT NULL,
362: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE DEFAULT NULL,
363: P_TRANSACTION_ID IN JAI_CMN_RG_23D_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
364: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE DEFAULT NULL,
365: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE DEFAULT NULL,
366: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE DEFAULT NULL,
367: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
360: P_EXCISE_DUTY_RATE IN JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE DEFAULT NULL,
361: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE DEFAULT NULL,
362: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE DEFAULT NULL,
363: P_TRANSACTION_ID IN JAI_CMN_RG_23D_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
364: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE DEFAULT NULL,
365: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE DEFAULT NULL,
366: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE DEFAULT NULL,
367: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
368: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE DEFAULT NULL,
361: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23D_TRXS.charge_account_id%TYPE DEFAULT NULL,
362: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE DEFAULT NULL,
363: P_TRANSACTION_ID IN JAI_CMN_RG_23D_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
364: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE DEFAULT NULL,
365: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE DEFAULT NULL,
366: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE DEFAULT NULL,
367: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
368: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE DEFAULT NULL,
369: P_OPENING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.opening_balance_qty%TYPE DEFAULT NULL,
362: P_DUTY_AMOUNT IN JAI_CMN_RG_23D_TRXS.duty_amount%TYPE DEFAULT NULL,
363: P_TRANSACTION_ID IN JAI_CMN_RG_23D_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
364: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE DEFAULT NULL,
365: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE DEFAULT NULL,
366: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE DEFAULT NULL,
367: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
368: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE DEFAULT NULL,
369: P_OPENING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.opening_balance_qty%TYPE DEFAULT NULL,
370: P_CLOSING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.closing_balance_qty%TYPE DEFAULT NULL,
363: P_TRANSACTION_ID IN JAI_CMN_RG_23D_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
364: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE DEFAULT NULL,
365: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE DEFAULT NULL,
366: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE DEFAULT NULL,
367: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
368: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE DEFAULT NULL,
369: P_OPENING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.opening_balance_qty%TYPE DEFAULT NULL,
370: P_CLOSING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.closing_balance_qty%TYPE DEFAULT NULL,
371: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE DEFAULT NULL,
364: P_RECEIPT_DATE IN JAI_CMN_RG_23D_TRXS.receipt_date%TYPE DEFAULT NULL,
365: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE DEFAULT NULL,
366: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE DEFAULT NULL,
367: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
368: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE DEFAULT NULL,
369: P_OPENING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.opening_balance_qty%TYPE DEFAULT NULL,
370: P_CLOSING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.closing_balance_qty%TYPE DEFAULT NULL,
371: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE DEFAULT NULL,
372: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE DEFAULT NULL,
365: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23D_TRXS.goods_issue_id%TYPE DEFAULT NULL,
366: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE DEFAULT NULL,
367: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
368: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE DEFAULT NULL,
369: P_OPENING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.opening_balance_qty%TYPE DEFAULT NULL,
370: P_CLOSING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.closing_balance_qty%TYPE DEFAULT NULL,
371: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE DEFAULT NULL,
372: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE DEFAULT NULL,
373: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
366: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23D_TRXS.goods_issue_date%TYPE DEFAULT NULL,
367: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
368: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE DEFAULT NULL,
369: P_OPENING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.opening_balance_qty%TYPE DEFAULT NULL,
370: P_CLOSING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.closing_balance_qty%TYPE DEFAULT NULL,
371: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE DEFAULT NULL,
372: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE DEFAULT NULL,
373: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
374: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE DEFAULT NULL,
367: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23D_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
368: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE DEFAULT NULL,
369: P_OPENING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.opening_balance_qty%TYPE DEFAULT NULL,
370: P_CLOSING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.closing_balance_qty%TYPE DEFAULT NULL,
371: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE DEFAULT NULL,
372: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE DEFAULT NULL,
373: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
374: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE DEFAULT NULL,
375: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE DEFAULT NULL,
368: P_TRANSACTION_DATE IN JAI_CMN_RG_23D_TRXS.transaction_date%TYPE DEFAULT NULL,
369: P_OPENING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.opening_balance_qty%TYPE DEFAULT NULL,
370: P_CLOSING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.closing_balance_qty%TYPE DEFAULT NULL,
371: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE DEFAULT NULL,
372: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE DEFAULT NULL,
373: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
374: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE DEFAULT NULL,
375: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE DEFAULT NULL,
376: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE DEFAULT NULL,
369: P_OPENING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.opening_balance_qty%TYPE DEFAULT NULL,
370: P_CLOSING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.closing_balance_qty%TYPE DEFAULT NULL,
371: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE DEFAULT NULL,
372: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE DEFAULT NULL,
373: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
374: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE DEFAULT NULL,
375: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE DEFAULT NULL,
376: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE DEFAULT NULL,
377: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE DEFAULT NULL,
370: P_CLOSING_BALANCE_QTY IN JAI_CMN_RG_23D_TRXS.closing_balance_qty%TYPE DEFAULT NULL,
371: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE DEFAULT NULL,
372: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE DEFAULT NULL,
373: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
374: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE DEFAULT NULL,
375: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE DEFAULT NULL,
376: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE DEFAULT NULL,
377: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE DEFAULT NULL,
378: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE DEFAULT NULL,
371: P_BASIC_ED IN JAI_CMN_RG_23D_TRXS.basic_ed%TYPE DEFAULT NULL,
372: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE DEFAULT NULL,
373: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
374: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE DEFAULT NULL,
375: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE DEFAULT NULL,
376: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE DEFAULT NULL,
377: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE DEFAULT NULL,
378: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE DEFAULT NULL,
379: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE DEFAULT NULL,
372: P_ADDITIONAL_ED IN JAI_CMN_RG_23D_TRXS.additional_ed%TYPE DEFAULT NULL,
373: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
374: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE DEFAULT NULL,
375: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE DEFAULT NULL,
376: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE DEFAULT NULL,
377: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE DEFAULT NULL,
378: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE DEFAULT NULL,
379: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE DEFAULT NULL,
380: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE DEFAULT NULL,
373: P_ADDITIONAL_CVD IN JAI_CMN_RG_23D_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
374: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE DEFAULT NULL,
375: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE DEFAULT NULL,
376: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE DEFAULT NULL,
377: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE DEFAULT NULL,
378: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE DEFAULT NULL,
379: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE DEFAULT NULL,
380: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE DEFAULT NULL,
381: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE DEFAULT NULL,
374: P_OTHER_ED IN JAI_CMN_RG_23D_TRXS.other_ed%TYPE DEFAULT NULL,
375: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE DEFAULT NULL,
376: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE DEFAULT NULL,
377: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE DEFAULT NULL,
378: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE DEFAULT NULL,
379: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE DEFAULT NULL,
380: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE DEFAULT NULL,
381: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE DEFAULT NULL,
382: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE DEFAULT NULL,
375: P_CVD IN JAI_CMN_RG_23D_TRXS.cvd%TYPE DEFAULT NULL,
376: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE DEFAULT NULL,
377: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE DEFAULT NULL,
378: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE DEFAULT NULL,
379: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE DEFAULT NULL,
380: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE DEFAULT NULL,
381: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE DEFAULT NULL,
382: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE DEFAULT NULL,
383: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE DEFAULT NULL,
376: P_VENDOR_ID IN JAI_CMN_RG_23D_TRXS.vendor_id%TYPE DEFAULT NULL,
377: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE DEFAULT NULL,
378: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE DEFAULT NULL,
379: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE DEFAULT NULL,
380: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE DEFAULT NULL,
381: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE DEFAULT NULL,
382: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE DEFAULT NULL,
383: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE DEFAULT NULL,
384: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE DEFAULT NULL,
377: P_VENDOR_SITE_ID IN JAI_CMN_RG_23D_TRXS.vendor_site_id%TYPE DEFAULT NULL,
378: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE DEFAULT NULL,
379: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE DEFAULT NULL,
380: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE DEFAULT NULL,
381: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE DEFAULT NULL,
382: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE DEFAULT NULL,
383: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE DEFAULT NULL,
384: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE DEFAULT NULL,
385: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE DEFAULT NULL,
378: P_RECEIPT_NUM IN JAI_CMN_RG_23D_TRXS.receipt_num%TYPE DEFAULT NULL,
379: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE DEFAULT NULL,
380: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE DEFAULT NULL,
381: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE DEFAULT NULL,
382: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE DEFAULT NULL,
383: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE DEFAULT NULL,
384: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE DEFAULT NULL,
385: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE DEFAULT NULL,
386: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE DEFAULT NULL,
379: P_ATTRIBUTE1 IN JAI_CMN_RG_23D_TRXS.attribute1%TYPE DEFAULT NULL,
380: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE DEFAULT NULL,
381: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE DEFAULT NULL,
382: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE DEFAULT NULL,
383: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE DEFAULT NULL,
384: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE DEFAULT NULL,
385: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE DEFAULT NULL,
386: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE DEFAULT NULL,
387: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE DEFAULT NULL,
380: P_ATTRIBUTE2 IN JAI_CMN_RG_23D_TRXS.attribute2%TYPE DEFAULT NULL,
381: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE DEFAULT NULL,
382: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE DEFAULT NULL,
383: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE DEFAULT NULL,
384: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE DEFAULT NULL,
385: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE DEFAULT NULL,
386: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE DEFAULT NULL,
387: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE DEFAULT NULL,
388: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE DEFAULT NULL,
381: P_ATTRIBUTE3 IN JAI_CMN_RG_23D_TRXS.attribute3%TYPE DEFAULT NULL,
382: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE DEFAULT NULL,
383: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE DEFAULT NULL,
384: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE DEFAULT NULL,
385: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE DEFAULT NULL,
386: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE DEFAULT NULL,
387: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE DEFAULT NULL,
388: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE DEFAULT NULL,
389: P_TOT_AMT_PAID_TO_MANUFACTURER IN JAI_CMN_RG_23D_TRXS.tot_amt_paid_to_manufacturer%TYPE DEFAULT NULL,
382: P_ATTRIBUTE4 IN JAI_CMN_RG_23D_TRXS.attribute4%TYPE DEFAULT NULL,
383: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE DEFAULT NULL,
384: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE DEFAULT NULL,
385: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE DEFAULT NULL,
386: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE DEFAULT NULL,
387: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE DEFAULT NULL,
388: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE DEFAULT NULL,
389: P_TOT_AMT_PAID_TO_MANUFACTURER IN JAI_CMN_RG_23D_TRXS.tot_amt_paid_to_manufacturer%TYPE DEFAULT NULL,
390: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
383: P_ATTRIBUTE5 IN JAI_CMN_RG_23D_TRXS.attribute5%TYPE DEFAULT NULL,
384: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE DEFAULT NULL,
385: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE DEFAULT NULL,
386: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE DEFAULT NULL,
387: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE DEFAULT NULL,
388: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE DEFAULT NULL,
389: P_TOT_AMT_PAID_TO_MANUFACTURER IN JAI_CMN_RG_23D_TRXS.tot_amt_paid_to_manufacturer%TYPE DEFAULT NULL,
390: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
391: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23D_TRXS.other_tax_credit%TYPE DEFAULT NULL,
384: P_CONSIGNEE IN JAI_CMN_RG_23D_TRXS.consignee%TYPE DEFAULT NULL,
385: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE DEFAULT NULL,
386: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE DEFAULT NULL,
387: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE DEFAULT NULL,
388: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE DEFAULT NULL,
389: P_TOT_AMT_PAID_TO_MANUFACTURER IN JAI_CMN_RG_23D_TRXS.tot_amt_paid_to_manufacturer%TYPE DEFAULT NULL,
390: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
391: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23D_TRXS.other_tax_credit%TYPE DEFAULT NULL,
392: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23D_TRXS.other_tax_debit%TYPE DEFAULT NULL,
385: P_MANUFACTURER_NAME IN JAI_CMN_RG_23D_TRXS.manufacturer_name%TYPE DEFAULT NULL,
386: P_MANUFACTURER_ADDRESS IN JAI_CMN_RG_23D_TRXS.manufacturer_address%TYPE DEFAULT NULL,
387: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE DEFAULT NULL,
388: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE DEFAULT NULL,
389: P_TOT_AMT_PAID_TO_MANUFACTURER IN JAI_CMN_RG_23D_TRXS.tot_amt_paid_to_manufacturer%TYPE DEFAULT NULL,
390: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
391: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23D_TRXS.other_tax_credit%TYPE DEFAULT NULL,
392: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23D_TRXS.other_tax_debit%TYPE DEFAULT NULL,
393: P_SIMULATE_FLAG IN VARCHAR2,
387: P_MANUFACTURER_RATE_AMT_PER_UN IN JAI_CMN_RG_23D_TRXS.manufacturer_rate_amt_per_unit%TYPE DEFAULT NULL,
388: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE DEFAULT NULL,
389: P_TOT_AMT_PAID_TO_MANUFACTURER IN JAI_CMN_RG_23D_TRXS.tot_amt_paid_to_manufacturer%TYPE DEFAULT NULL,
390: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
391: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23D_TRXS.other_tax_credit%TYPE DEFAULT NULL,
392: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23D_TRXS.other_tax_debit%TYPE DEFAULT NULL,
393: P_SIMULATE_FLAG IN VARCHAR2,
394: P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
395: P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2
388: P_QTY_RECEIVED_FROM_MANUFACTUR IN JAI_CMN_RG_23D_TRXS.qty_received_from_manufacturer%TYPE DEFAULT NULL,
389: P_TOT_AMT_PAID_TO_MANUFACTURER IN JAI_CMN_RG_23D_TRXS.tot_amt_paid_to_manufacturer%TYPE DEFAULT NULL,
390: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
391: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23D_TRXS.other_tax_credit%TYPE DEFAULT NULL,
392: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23D_TRXS.other_tax_debit%TYPE DEFAULT NULL,
393: P_SIMULATE_FLAG IN VARCHAR2,
394: P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
395: P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2
396: ) IS
393: P_SIMULATE_FLAG IN VARCHAR2,
394: P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
395: P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2
396: ) IS
397: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_23d_trxs_pkg.update_row'; /* Added by Ramananda for bug#4407165 */
398: BEGIN
399:
400: UPDATE JAI_CMN_RG_23D_TRXS SET
401: REGISTER_ID = nvl(P_REGISTER_ID, REGISTER_ID),
396: ) IS
397: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_23d_trxs_pkg.update_row'; /* Added by Ramananda for bug#4407165 */
398: BEGIN
399:
400: UPDATE JAI_CMN_RG_23D_TRXS SET
401: REGISTER_ID = nvl(P_REGISTER_ID, REGISTER_ID),
402: ORGANIZATION_ID = nvl(P_ORGANIZATION_ID, ORGANIZATION_ID),
403: LOCATION_ID = nvl(P_LOCATION_ID, LOCATION_ID),
404: SLNO = nvl(P_SLNO, SLNO),
481: BEGIN
482: -- QTY_TO_ADJUST is a column which will be only INSERTED with a value for RECEIVE transaction and will be reduced
483: -- whenever a -ve Quantity Transaction or RTV Happens for Shipment Line
484: -- p_quantity can be +ve incase of regular RTV and +ve CORRECTion of RTV. -ve During Deliver to Non Trading
485: UPDATE JAI_CMN_RG_23D_TRXS
486: SET qty_to_adjust = nvl(qty_to_adjust, 0) - p_quantity,
487: last_update_date= SYSDATE
488: WHERE register_id = p_register_id;
489:
495: ) IS
496:
497: BEGIN
498:
499: UPDATE JAI_CMN_RG_23D_TRXS
500: SET charge_account_id = p_charge_account_id,
501: last_update_date= SYSDATE
502: WHERE register_id = p_register_id;
503:
514:
515: ln_record_exist_cnt NUMBER(4);
516: CURSOR c_record_exist IS
517: SELECT count(1)
518: FROM JAI_CMN_RG_23D_TRXS
519: WHERE organization_id = p_organization_id
520: AND location_id = p_location_id
521: AND inventory_item_id = p_inventory_item_id
522: AND receipt_ref = p_receipt_id
598: p_last_updated_by IN NUMBER)
599: IS
600:
601: /* Added by Ramananda for bug#4407165 */
602: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_23d_trxs_pkg.make_entry';
603:
604: v_reg_id Number;
605: v_fin_year Number;
606: v_slno Number;
607: v_closing_bal_qty Number :=0;
608: v_opening_bal_qty Number :=0;
609:
610: Cursor get_regid_cur IS
611: SELECT JAI_CMN_RG_23D_TRXS_S.nextval
612: FROM dual;
613:
614: CURSOR fin_year_CUR is
615: SELECT max(fin_year) fin_year
618: AND fin_active_flag = 'Y';
619:
620: CURSOR SLNO_BAL_CUR(v_fin_year NUMBER) is
621: SELECT slno,NVL(closing_balance_qty, 0)
622: FROM JAI_CMN_RG_23D_TRXS
623: WHERE organization_id = p_org_id
624: AND location_id = p_location_id
625: AND fin_year = v_fin_year
626: and inventory_item_id = p_item_id --ashish 12/nov/2002;
624: AND location_id = p_location_id
625: AND fin_year = v_fin_year
626: and inventory_item_id = p_item_id --ashish 12/nov/2002;
627: AND slno = (SELECT max(slno)
628: FROM JAI_CMN_RG_23D_TRXS
629: WHERE organization_id = p_org_id
630: AND location_id = p_location_id
631: AND fin_year = v_fin_year
632: and inventory_item_id = p_item_id); --ashish 12/nov/2002;
677:
678: v_closing_bal_qty := v_opening_bal_qty + NVL(p_oth_receipt_qty, v_issue_qty);
679: v_slno := v_slno + 1;
680:
681: INSERT INTO JAI_CMN_RG_23D_TRXS
682: (register_id,
683: organization_id,
684: location_id,
685: slno,
758: v_closing_qty IN OUT NOCOPY NUMBER,
759: p_inventory_item_id Number) IS
760:
761: /* Added by Ramananda for bug#4407165 */
762: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_23d_trxs_pkg.calculate_qty_balances';
763:
764: v_previous_serial_no number;
765: v_serial_no number;
766: v_rg_balance number;
782: -- start added by K V UDAY KUMAR on 10-MAY-2001, to pick slno from previous year in
783: -- case of change in fin_year transactions
784:
785: Cursor prior_slno_cur(v_inventory_item_id Number) IS
786: select NVL(MAX(slno),0), NVL(MAX(slno),0) + 1 from JAI_CMN_RG_23D_TRXS
787: WHERE organization_id = p_org_id
788: and inventory_item_id = v_inventory_item_id
789: and fin_year = p_fin_year - 1;
790: -- end
790: -- end
791:
792: Cursor serial_no_cur(v_inventory_item_id Number) IS
793: SELECT NVL(MAX(slno),0) , NVL(MAX(slno),0) + 1
794: FROM JAI_CMN_RG_23D_TRXS
795: WHERE organization_id = p_org_id and
796: -- location_id = p_location_id and
797: inventory_item_id = v_inventory_item_id
798: and fin_year = p_fin_year ;
798: and fin_year = p_fin_year ;
799:
800: CURSOR balance_cur(p_previous_serial_no IN NUMBER,v_inventory_item_id Number,x_fin_year Number) IS
801: SELECT NVL(opening_balance_qty,0),NVL(closing_balance_qty,0)
802: FROM JAI_CMN_RG_23D_TRXS
803: WHERE organization_id = p_org_id and
804: --location_id = p_location_id and
805: slno = p_previous_serial_no and
806: inventory_item_id = v_inventory_item_id and
819: FETCH serial_no_cur INTO v_previous_serial_no, v_serial_no;
820: CLOSE serial_no_cur; */
821:
822: -- added below code on 10-may-2001 by K V UDAY KUMAR
823: select count(*) into cnt from JAI_CMN_RG_23D_TRXS
824: WHERE organization_id = p_org_id
825: and inventory_item_id = v_inventory_item_id
826: and fin_year = p_fin_year;
827:
884: END calculate_qty_balances;
885:
886: procedure upd_receipt_qty_matched(p_receipt_id in number,p_quantity_applied in number,p_qty_to_adjust Number) is
887: begin
888: update JAI_CMN_RG_23D_TRXS
889: set qty_to_adjust= nvl(qty_to_adjust,0) - nvl(p_quantity_applied,0)
890: where register_id=p_receipt_id;
891: END upd_receipt_qty_matched;
892:
889: set qty_to_adjust= nvl(qty_to_adjust,0) - nvl(p_quantity_applied,0)
890: where register_id=p_receipt_id;
891: END upd_receipt_qty_matched;
892:
893: END JAI_CMN_RG_23D_TRXS_PKG;