DBA Data[Home] [Help]

APPS.JAI_CMN_RG_23AC_I_TRXS_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 1: PACKAGE jai_cmn_rg_23ac_i_trxs_pkg AS

1: PACKAGE jai_cmn_rg_23ac_i_trxs_pkg AS
2: /* $Header: jai_cmn_rg_23p1.pls 120.2 2006/11/23 09:34:07 sacsethi ship $ */
3:
4: CURSOR c_get_last_record(cp_register_id IN NUMBER) IS
5: SELECT slno, opening_balance_qty, closing_balance_qty, fin_year

Line 6: FROM JAI_CMN_RG_23AC_I_TRXS

2: /* $Header: jai_cmn_rg_23p1.pls 120.2 2006/11/23 09:34:07 sacsethi ship $ */
3:
4: CURSOR c_get_last_record(cp_register_id IN NUMBER) IS
5: SELECT slno, opening_balance_qty, closing_balance_qty, fin_year
6: FROM JAI_CMN_RG_23AC_I_TRXS
7: WHERE register_id = cp_register_id;
8:
9: PROCEDURE insert_row(
10: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE,

Line 10: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE,

6: FROM JAI_CMN_RG_23AC_I_TRXS
7: WHERE register_id = cp_register_id;
8:
9: PROCEDURE insert_row(
10: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE,
11: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_I_TRXS.inventory_item_id%TYPE,
12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,
13: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,
14: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE,

Line 11: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_I_TRXS.inventory_item_id%TYPE,

7: WHERE register_id = cp_register_id;
8:
9: PROCEDURE insert_row(
10: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE,
11: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_I_TRXS.inventory_item_id%TYPE,
12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,
13: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,
14: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE,
15: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,

Line 12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,

8:
9: PROCEDURE insert_row(
10: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE,
11: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_I_TRXS.inventory_item_id%TYPE,
12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,
13: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,
14: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE,
15: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,
16: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE,

Line 13: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,

9: PROCEDURE insert_row(
10: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE,
11: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_I_TRXS.inventory_item_id%TYPE,
12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,
13: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,
14: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE,
15: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,
16: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE,
17: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE,

Line 14: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE,

10: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE,
11: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_I_TRXS.inventory_item_id%TYPE,
12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,
13: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,
14: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE,
15: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,
16: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE,
17: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE,
18: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE,

Line 15: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,

11: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_I_TRXS.inventory_item_id%TYPE,
12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,
13: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,
14: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE,
15: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,
16: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE,
17: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE,
18: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE,
19: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE,

Line 16: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE,

12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,
13: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,
14: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE,
15: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,
16: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE,
17: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE,
18: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE,
19: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE,
20: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE,

Line 17: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE,

13: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,
14: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE,
15: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,
16: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE,
17: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE,
18: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE,
19: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE,
20: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE,
21: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE,

Line 18: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE,

14: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE,
15: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,
16: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE,
17: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE,
18: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE,
19: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE,
20: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE,
21: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE,
22: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE,

Line 19: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE,

15: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,
16: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE,
17: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE,
18: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE,
19: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE,
20: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE,
21: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE,
22: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE,
23: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,

Line 20: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE,

16: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE,
17: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE,
18: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE,
19: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE,
20: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE,
21: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE,
22: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE,
23: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,
24: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,

Line 21: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE,

17: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE,
18: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE,
19: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE,
20: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE,
21: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE,
22: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE,
23: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,
24: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,
25: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE,

Line 22: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE,

18: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE,
19: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE,
20: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE,
21: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE,
22: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE,
23: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,
24: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,
25: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE,
26: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,

Line 23: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,

19: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE,
20: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE,
21: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE,
22: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE,
23: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,
24: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,
25: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE,
26: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
27: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,

Line 24: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,

20: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE,
21: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE,
22: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE,
23: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,
24: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,
25: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE,
26: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
27: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
28: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE,

Line 25: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE,

21: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE,
22: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE,
23: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,
24: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,
25: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE,
26: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
27: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
28: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE,
29: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,

Line 26: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,

22: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE,
23: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,
24: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,
25: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE,
26: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
27: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
28: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE,
29: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
30: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,

Line 27: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,

23: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,
24: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,
25: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE,
26: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
27: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
28: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE,
29: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
30: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
31: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE,

Line 28: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE,

24: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,
25: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE,
26: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
27: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
28: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE,
29: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
30: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
31: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE,
32: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,

Line 29: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,

25: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE,
26: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
27: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
28: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE,
29: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
30: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
31: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE,
32: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
33: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,

Line 30: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,

26: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
27: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
28: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE,
29: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
30: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
31: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE,
32: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
33: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
34: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE,

Line 31: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE,

27: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
28: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE,
29: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
30: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
31: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE,
32: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
33: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
34: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE,
35: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,

Line 32: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,

28: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE,
29: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
30: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
31: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE,
32: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
33: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
34: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE,
35: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,
36: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,

Line 33: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,

29: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
30: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
31: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE,
32: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
33: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
34: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE,
35: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,
36: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,
37: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE,

Line 34: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE,

30: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
31: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE,
32: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
33: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
34: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE,
35: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,
36: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,
37: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE,
38: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE,

Line 35: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,

31: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE,
32: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
33: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
34: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE,
35: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,
36: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,
37: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE,
38: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE,
39: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE,

Line 36: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,

32: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
33: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
34: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE,
35: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,
36: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,
37: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE,
38: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE,
39: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE,
40: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE,

Line 37: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE,

33: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
34: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE,
35: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,
36: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,
37: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE,
38: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE,
39: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE,
40: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE,
41: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE,

Line 38: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE,

34: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE,
35: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,
36: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,
37: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE,
38: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE,
39: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE,
40: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE,
41: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE,
42: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE,

Line 39: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE,

35: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,
36: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,
37: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE,
38: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE,
39: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE,
40: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE,
41: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE,
42: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE,
43: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE,

Line 40: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE,

36: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,
37: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE,
38: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE,
39: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE,
40: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE,
41: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE,
42: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE,
43: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE,
44: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE,

Line 41: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE,

37: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE,
38: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE,
39: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE,
40: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE,
41: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE,
42: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE,
43: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE,
44: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE,
45: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE,

Line 42: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE,

38: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE,
39: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE,
40: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE,
41: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE,
42: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE,
43: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE,
44: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE,
45: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE,
46: P_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.location_id%TYPE,

Line 43: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE,

39: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE,
40: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE,
41: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE,
42: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE,
43: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE,
44: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE,
45: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE,
46: P_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.location_id%TYPE,
47: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23AC_I_TRXS.transaction_uom_code%TYPE,

Line 44: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE,

40: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE,
41: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE,
42: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE,
43: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE,
44: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE,
45: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE,
46: P_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.location_id%TYPE,
47: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23AC_I_TRXS.transaction_uom_code%TYPE,
48: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_I_TRXS.transaction_date%TYPE,

Line 45: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE,

41: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE,
42: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE,
43: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE,
44: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE,
45: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE,
46: P_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.location_id%TYPE,
47: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23AC_I_TRXS.transaction_uom_code%TYPE,
48: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_I_TRXS.transaction_date%TYPE,
49: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE,

Line 46: P_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.location_id%TYPE,

42: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE,
43: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE,
44: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE,
45: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE,
46: P_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.location_id%TYPE,
47: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23AC_I_TRXS.transaction_uom_code%TYPE,
48: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_I_TRXS.transaction_date%TYPE,
49: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE,
50: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE,

Line 47: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23AC_I_TRXS.transaction_uom_code%TYPE,

43: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE,
44: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE,
45: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE,
46: P_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.location_id%TYPE,
47: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23AC_I_TRXS.transaction_uom_code%TYPE,
48: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_I_TRXS.transaction_date%TYPE,
49: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE,
50: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE,
51: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* bug 5228046 by sacsethi */

Line 48: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_I_TRXS.transaction_date%TYPE,

44: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE,
45: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE,
46: P_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.location_id%TYPE,
47: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23AC_I_TRXS.transaction_uom_code%TYPE,
48: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_I_TRXS.transaction_date%TYPE,
49: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE,
50: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE,
51: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* bug 5228046 by sacsethi */
52: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE,

Line 49: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE,

45: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE,
46: P_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.location_id%TYPE,
47: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23AC_I_TRXS.transaction_uom_code%TYPE,
48: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_I_TRXS.transaction_date%TYPE,
49: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE,
50: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE,
51: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* bug 5228046 by sacsethi */
52: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE,
53: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE,

Line 50: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE,

46: P_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.location_id%TYPE,
47: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23AC_I_TRXS.transaction_uom_code%TYPE,
48: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_I_TRXS.transaction_date%TYPE,
49: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE,
50: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE,
51: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* bug 5228046 by sacsethi */
52: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE,
53: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE,
54: P_TRANSACTION_SOURCE IN VARCHAR2,

Line 51: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* bug 5228046 by sacsethi */

47: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23AC_I_TRXS.transaction_uom_code%TYPE,
48: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_I_TRXS.transaction_date%TYPE,
49: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE,
50: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE,
51: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* bug 5228046 by sacsethi */
52: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE,
53: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE,
54: P_TRANSACTION_SOURCE IN VARCHAR2,
55: P_CALLED_FROM IN VARCHAR2,

Line 52: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE,

48: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_I_TRXS.transaction_date%TYPE,
49: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE,
50: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE,
51: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* bug 5228046 by sacsethi */
52: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE,
53: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE,
54: P_TRANSACTION_SOURCE IN VARCHAR2,
55: P_CALLED_FROM IN VARCHAR2,
56: P_SIMULATE_FLAG IN VARCHAR2,

Line 53: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE,

49: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE,
50: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE,
51: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* bug 5228046 by sacsethi */
52: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE,
53: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE,
54: P_TRANSACTION_SOURCE IN VARCHAR2,
55: P_CALLED_FROM IN VARCHAR2,
56: P_SIMULATE_FLAG IN VARCHAR2,
57: P_PROCESS_STATUS OUT NOCOPY VARCHAR2,

Line 62: P_REGISTER_ID IN JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE DEFAULT NULL,

58: P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2
59: );
60:
61: PROCEDURE update_row(
62: P_REGISTER_ID IN JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE DEFAULT NULL,
63: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE DEFAULT NULL,
64: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE DEFAULT NULL,
65: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
66: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,

Line 63: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE DEFAULT NULL,

59: );
60:
61: PROCEDURE update_row(
62: P_REGISTER_ID IN JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE DEFAULT NULL,
63: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE DEFAULT NULL,
64: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE DEFAULT NULL,
65: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
66: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
67: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,

Line 64: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE DEFAULT NULL,

60:
61: PROCEDURE update_row(
62: P_REGISTER_ID IN JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE DEFAULT NULL,
63: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE DEFAULT NULL,
64: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE DEFAULT NULL,
65: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
66: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
67: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
68: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,

Line 65: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,

61: PROCEDURE update_row(
62: P_REGISTER_ID IN JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE DEFAULT NULL,
63: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE DEFAULT NULL,
64: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE DEFAULT NULL,
65: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
66: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
67: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
68: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
69: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,

Line 66: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,

62: P_REGISTER_ID IN JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE DEFAULT NULL,
63: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE DEFAULT NULL,
64: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE DEFAULT NULL,
65: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
66: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
67: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
68: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
69: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
70: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,

Line 67: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,

63: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE DEFAULT NULL,
64: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE DEFAULT NULL,
65: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
66: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
67: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
68: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
69: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
70: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
71: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,

Line 68: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,

64: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.receipt_ref%TYPE DEFAULT NULL,
65: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
66: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
67: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
68: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
69: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
70: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
71: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
72: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,

Line 69: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,

65: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
66: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
67: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
68: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
69: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
70: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
71: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
72: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
73: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,

Line 70: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,

66: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
67: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
68: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
69: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
70: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
71: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
72: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
73: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
74: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,

Line 71: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,

67: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
68: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
69: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
70: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
71: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
72: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
73: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
74: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,

Line 72: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,

68: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
69: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
70: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
71: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
72: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
73: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
74: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
76: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,

Line 73: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,

69: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
70: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
71: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
72: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
73: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
74: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
76: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
77: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE DEFAULT NULL,

Line 74: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,

70: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
71: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
72: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
73: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
74: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
76: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
77: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE DEFAULT NULL,
78: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,

Line 75: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,

71: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
72: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
73: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
74: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
76: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
77: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE DEFAULT NULL,
78: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
79: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,

Line 76: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,

72: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
73: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
74: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
76: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
77: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE DEFAULT NULL,
78: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
79: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
80: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE DEFAULT NULL,

Line 77: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE DEFAULT NULL,

73: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
74: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
76: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
77: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE DEFAULT NULL,
78: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
79: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
80: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE DEFAULT NULL,
81: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,

Line 78: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,

74: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
76: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
77: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE DEFAULT NULL,
78: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
79: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
80: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE DEFAULT NULL,
81: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
82: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,

Line 79: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,

75: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
76: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
77: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE DEFAULT NULL,
78: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
79: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
80: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE DEFAULT NULL,
81: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
82: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
83: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE DEFAULT NULL,

Line 80: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE DEFAULT NULL,

76: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
77: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE DEFAULT NULL,
78: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
79: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
80: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE DEFAULT NULL,
81: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
82: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
83: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
84: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,

Line 81: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,

77: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_id_ref%TYPE DEFAULT NULL,
78: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
79: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
80: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE DEFAULT NULL,
81: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
82: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
83: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
84: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
85: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,

Line 82: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,

78: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
79: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
80: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE DEFAULT NULL,
81: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
82: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
83: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
84: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
85: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
86: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE DEFAULT NULL,

Line 83: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE DEFAULT NULL,

79: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
80: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE DEFAULT NULL,
81: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
82: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
83: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
84: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
85: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
86: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE DEFAULT NULL,
87: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,

Line 84: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,

80: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_no%TYPE DEFAULT NULL,
81: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
82: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
83: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
84: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
85: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
86: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE DEFAULT NULL,
87: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
88: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,

Line 85: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,

81: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
82: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
83: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
84: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
85: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
86: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE DEFAULT NULL,
87: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
88: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
89: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,

Line 86: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE DEFAULT NULL,

82: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
83: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
84: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
85: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
86: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE DEFAULT NULL,
87: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
88: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
89: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
90: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,

Line 87: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,

83: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
84: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
85: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
86: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE DEFAULT NULL,
87: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
88: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
89: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
90: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
91: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,

Line 88: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,

84: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
85: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
86: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE DEFAULT NULL,
87: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
88: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
89: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
90: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
91: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
92: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,

Line 89: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,

85: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
86: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE DEFAULT NULL,
87: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
88: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
89: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
90: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
91: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
92: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
93: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,

Line 90: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,

86: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_id_ref%TYPE DEFAULT NULL,
87: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
88: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
89: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
90: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
91: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
92: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
93: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
94: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,

Line 91: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,

87: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
88: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
89: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
90: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
91: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
92: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
93: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
94: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
95: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE DEFAULT NULL,

Line 92: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,

88: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
89: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
90: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
91: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
92: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
93: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
94: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
95: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE DEFAULT NULL,
96: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,

Line 93: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,

89: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
90: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
91: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
92: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
93: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
94: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
95: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE DEFAULT NULL,
96: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
97: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,

Line 94: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,

90: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
91: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
92: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
93: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
94: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
95: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE DEFAULT NULL,
96: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
97: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
98: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,

Line 95: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE DEFAULT NULL,

91: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
92: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
93: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
94: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
95: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE DEFAULT NULL,
96: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
97: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
98: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
99: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,

Line 96: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,

92: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
93: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
94: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
95: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE DEFAULT NULL,
96: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
97: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
98: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
99: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
100: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* Bug 5228046 added by sacsethi */

Line 97: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,

93: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
94: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
95: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE DEFAULT NULL,
96: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
97: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
98: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
99: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
100: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* Bug 5228046 added by sacsethi */
101: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,

Line 98: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,

94: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
95: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE DEFAULT NULL,
96: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
97: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
98: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
99: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
100: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* Bug 5228046 added by sacsethi */
101: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,
102: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,

Line 99: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,

95: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.register_id_part_ii%TYPE DEFAULT NULL,
96: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
97: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
98: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
99: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
100: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* Bug 5228046 added by sacsethi */
101: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,
102: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,
103: P_POSTED_FLAG IN JAI_CMN_RG_23AC_I_TRXS.posted_flag%TYPE DEFAULT NULL,

Line 100: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* Bug 5228046 added by sacsethi */

96: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
97: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
98: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
99: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
100: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* Bug 5228046 added by sacsethi */
101: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,
102: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,
103: P_POSTED_FLAG IN JAI_CMN_RG_23AC_I_TRXS.posted_flag%TYPE DEFAULT NULL,
104: P_MASTER_FLAG IN JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE DEFAULT NULL,

Line 101: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,

97: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
98: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
99: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
100: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* Bug 5228046 added by sacsethi */
101: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,
102: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,
103: P_POSTED_FLAG IN JAI_CMN_RG_23AC_I_TRXS.posted_flag%TYPE DEFAULT NULL,
104: P_MASTER_FLAG IN JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE DEFAULT NULL,
105: P_TRANSACTION_SOURCE IN VARCHAR2,

Line 102: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,

98: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
99: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
100: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* Bug 5228046 added by sacsethi */
101: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,
102: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,
103: P_POSTED_FLAG IN JAI_CMN_RG_23AC_I_TRXS.posted_flag%TYPE DEFAULT NULL,
104: P_MASTER_FLAG IN JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE DEFAULT NULL,
105: P_TRANSACTION_SOURCE IN VARCHAR2,
106: P_CALLED_FROM IN VARCHAR2,

Line 103: P_POSTED_FLAG IN JAI_CMN_RG_23AC_I_TRXS.posted_flag%TYPE DEFAULT NULL,

99: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
100: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* Bug 5228046 added by sacsethi */
101: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,
102: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,
103: P_POSTED_FLAG IN JAI_CMN_RG_23AC_I_TRXS.posted_flag%TYPE DEFAULT NULL,
104: P_MASTER_FLAG IN JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE DEFAULT NULL,
105: P_TRANSACTION_SOURCE IN VARCHAR2,
106: P_CALLED_FROM IN VARCHAR2,
107: P_SIMULATE_FLAG IN VARCHAR2,

Line 104: P_MASTER_FLAG IN JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE DEFAULT NULL,

100: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, /* Bug 5228046 added by sacsethi */
101: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,
102: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,
103: P_POSTED_FLAG IN JAI_CMN_RG_23AC_I_TRXS.posted_flag%TYPE DEFAULT NULL,
104: P_MASTER_FLAG IN JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE DEFAULT NULL,
105: P_TRANSACTION_SOURCE IN VARCHAR2,
106: P_CALLED_FROM IN VARCHAR2,
107: P_SIMULATE_FLAG IN VARCHAR2,
108: P_PROCESS_STATUS OUT NOCOPY VARCHAR2,

Line 133: END jai_cmn_rg_23ac_i_trxs_pkg;

129: p_transaction_source IN VARCHAR2,
130: p_transaction_id OUT NOCOPY NUMBER
131: );
132:
133: END jai_cmn_rg_23ac_i_trxs_pkg;