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

APPS.JAI_CMN_RG_23AC_I_TRXS_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 1: PACKAGE BODY jai_cmn_rg_23ac_i_trxs_pkg AS

1: PACKAGE BODY jai_cmn_rg_23ac_i_trxs_pkg AS
2: /* $Header: jai_cmn_rg_23p1.plb 120.4 2006/11/27 06:37:01 sacsethi ship $ */
3:
4:
5: PROCEDURE insert_row(

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

3:
4:
5: PROCEDURE insert_row(
6:
7: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE,
8: -- P_FIN_YEAR IN JAI_CMN_RG_23AC_I_TRXS.fin_year%TYPE,
9: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_I_TRXS.inventory_item_id%TYPE,
10: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,
11: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,

Line 8: -- P_FIN_YEAR IN JAI_CMN_RG_23AC_I_TRXS.fin_year%TYPE,

4:
5: PROCEDURE insert_row(
6:
7: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE,
8: -- P_FIN_YEAR IN JAI_CMN_RG_23AC_I_TRXS.fin_year%TYPE,
9: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_I_TRXS.inventory_item_id%TYPE,
10: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,
11: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,
12: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.RECEIPT_REF%TYPE,

Line 9: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_I_TRXS.inventory_item_id%TYPE,

5: PROCEDURE insert_row(
6:
7: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE,
8: -- P_FIN_YEAR IN JAI_CMN_RG_23AC_I_TRXS.fin_year%TYPE,
9: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_I_TRXS.inventory_item_id%TYPE,
10: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,
11: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,
12: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.RECEIPT_REF%TYPE,
13: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,

Line 10: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,

6:
7: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE,
8: -- P_FIN_YEAR IN JAI_CMN_RG_23AC_I_TRXS.fin_year%TYPE,
9: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_I_TRXS.inventory_item_id%TYPE,
10: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,
11: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,
12: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.RECEIPT_REF%TYPE,
13: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,
14: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE,

Line 11: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,

7: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE,
8: -- P_FIN_YEAR IN JAI_CMN_RG_23AC_I_TRXS.fin_year%TYPE,
9: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_I_TRXS.inventory_item_id%TYPE,
10: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,
11: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,
12: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.RECEIPT_REF%TYPE,
13: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,
14: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE,
15: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE,

Line 12: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.RECEIPT_REF%TYPE,

8: -- P_FIN_YEAR IN JAI_CMN_RG_23AC_I_TRXS.fin_year%TYPE,
9: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_I_TRXS.inventory_item_id%TYPE,
10: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_I_TRXS.organization_id%TYPE,
11: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE,
12: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.RECEIPT_REF%TYPE,
13: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,
14: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE,
15: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE,
16: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE,

Line 13: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE,

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

Line 14: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE,

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

Line 15: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE,

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

Line 16: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE,

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

Line 17: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE,

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

Line 18: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE,

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

Line 19: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE,

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

Line 20: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE,

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

Line 21: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,

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

Line 22: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,

18: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE,
19: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE,
20: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE,
21: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,
22: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,
23: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE,
24: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
25: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
26: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE,

Line 23: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE,

19: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE,
20: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE,
21: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,
22: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,
23: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE,
24: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
25: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
26: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE,
27: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,

Line 24: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,

20: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE,
21: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,
22: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,
23: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE,
24: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
25: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
26: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE,
27: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
28: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,

Line 25: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,

21: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE,
22: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,
23: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE,
24: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
25: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
26: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE,
27: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
28: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
29: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE,

Line 26: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE,

22: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,
23: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE,
24: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
25: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
26: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE,
27: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
28: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
29: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE,
30: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,

Line 27: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,

23: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE,
24: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
25: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
26: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE,
27: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
28: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
29: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE,
30: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
31: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,

Line 28: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,

24: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
25: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
26: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE,
27: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
28: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
29: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE,
30: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
31: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
32: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE,

Line 29: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE,

25: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
26: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE,
27: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
28: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
29: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE,
30: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
31: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
32: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE,
33: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,

Line 30: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,

26: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE,
27: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
28: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
29: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE,
30: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
31: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
32: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE,
33: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,
34: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,

Line 31: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,

27: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
28: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
29: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE,
30: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
31: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
32: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE,
33: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,
34: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,
35: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE,

Line 32: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE,

28: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
29: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE,
30: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
31: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
32: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE,
33: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,
34: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,
35: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE,
36: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE,

Line 33: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,

29: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE,
30: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
31: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
32: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE,
33: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE,
34: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,
35: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE,
36: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE,
37: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE,

Line 34: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE,

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

Line 35: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE,

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

Line 36: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE,

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

Line 37: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE,

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

Line 38: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE,

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

Line 39: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE,

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

Line 40: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE,

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

Line 41: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.REGISTER_ID_PART_II%TYPE,

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

Line 42: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE,

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

Line 43: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE,

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

Line 44: P_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.location_id%TYPE,

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

Line 45: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23AC_I_TRXS.transaction_uom_code%TYPE,

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

Line 46: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_I_TRXS.transaction_date%TYPE,

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

Line 47: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE,

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

Line 48: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE,

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

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

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

Line 50: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE,

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

Line 51: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE,

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

Line 76: lv_range JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE;

72: lv_primary_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%TYPE;
73: vTransToPrimaryUOMConv NUMBER;
74:
75: ln_fin_year NUMBER(4);
76: lv_range JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE;
77: lv_division JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE;
78: lv_master_flag JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE;
79:
80: r_last_record c_get_last_record%ROWTYPE;

Line 77: lv_division JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE;

73: vTransToPrimaryUOMConv NUMBER;
74:
75: ln_fin_year NUMBER(4);
76: lv_range JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE;
77: lv_division JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE;
78: lv_master_flag JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE;
79:
80: r_last_record c_get_last_record%ROWTYPE;
81:

Line 78: lv_master_flag JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE;

74:
75: ln_fin_year NUMBER(4);
76: lv_range JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE;
77: lv_division JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE;
78: lv_master_flag JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE;
79:
80: r_last_record c_get_last_record%ROWTYPE;
81:
82: ln_record_exist_cnt NUMBER(4);

Line 88: CHANGE HISTORY for FILENAME: jai_cmn_rg_23ac_i_trxs_pkg.sql

84:
85: BEGIN
86:
87: /*----------------------------------------------------------------------------------------------------------------------------
88: CHANGE HISTORY for FILENAME: jai_cmn_rg_23ac_i_trxs_pkg.sql
89: S.No dd/mm/yyyy Author and Details
90: ------------------------------------------------------------------------------------------------------------------------------
91: 1 16/07/2002 Vijay Shankar for Bug# 3496408, Version:115.0
92: Table handler Package for JAI_CMN_RG_23AC_I_TRXS table

Line 92: Table handler Package for JAI_CMN_RG_23AC_I_TRXS table

88: CHANGE HISTORY for FILENAME: jai_cmn_rg_23ac_i_trxs_pkg.sql
89: S.No dd/mm/yyyy Author and Details
90: ------------------------------------------------------------------------------------------------------------------------------
91: 1 16/07/2002 Vijay Shankar for Bug# 3496408, Version:115.0
92: Table handler Package for JAI_CMN_RG_23AC_I_TRXS table
93:
94: 2. 08/06/2005 Version 116.1
95: Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
96: as required for CASE COMPLAINCE.

Line 112: So Commented the Call to get_trxn_entry_cnt in jai_cmn_rg_23ac_i_trxs_pkg.insert_row

108: Fix
109: ---
110: As in 11.0.3, entry in the RG23_I is made at the time of Receipt Creation.
111: So for Migrated receipts, entry is already present in RG23_I.
112: So Commented the Call to get_trxn_entry_cnt in jai_cmn_rg_23ac_i_trxs_pkg.insert_row
113:
114: 5. 31/10/2006 SACSETHI for bug 5228046, File version 120.3
115: Forward porting the change in 11i bug 5365523 (Additional CVD Enhancement).
116: This bug has datamodel and spec changes.

Line 170: INSERT INTO JAI_CMN_RG_23AC_I_TRXS(

166: ln_opening_balance_qty := nvl(r_last_record.closing_balance_qty, 0);
167: ln_closing_balance_qty := ln_opening_balance_qty + ln_quantity;
168:
169: lv_statement_id := '10';
170: INSERT INTO JAI_CMN_RG_23AC_I_TRXS(
171: REGISTER_ID,
172: FIN_YEAR,
173: SLNO,
174: TRANSACTION_SOURCE_NUM,

Line 231: JAI_CMN_RG_23AC_I_TRXS_S.nextval,

227: LAST_UPDATE_LOGIN,
228: POSTED_FLAG,
229: MASTER_FLAG
230: ) VALUES (
231: JAI_CMN_RG_23AC_I_TRXS_S.nextval,
232: ln_fin_year,
233: ln_slno,
234: ln_transaction_id,
235: P_INVENTORY_ITEM_ID,

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

307: END insert_row;
308:
309: PROCEDURE update_row(
310:
311: P_REGISTER_ID IN JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE DEFAULT NULL,
312: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE DEFAULT NULL,
313: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
314: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
315: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,

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

308:
309: PROCEDURE update_row(
310:
311: P_REGISTER_ID IN JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE DEFAULT NULL,
312: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE DEFAULT NULL,
313: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
314: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
315: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
316: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,

Line 313: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,

309: PROCEDURE update_row(
310:
311: P_REGISTER_ID IN JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE DEFAULT NULL,
312: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE DEFAULT NULL,
313: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
314: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
315: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
316: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
317: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,

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

310:
311: P_REGISTER_ID IN JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE DEFAULT NULL,
312: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE DEFAULT NULL,
313: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
314: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
315: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
316: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
317: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
318: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,

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

311: P_REGISTER_ID IN JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE DEFAULT NULL,
312: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE DEFAULT NULL,
313: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
314: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
315: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
316: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
317: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
318: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
319: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,

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

312: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23AC_I_TRXS.quantity_received%TYPE DEFAULT NULL,
313: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
314: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
315: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
316: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
317: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
318: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
319: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
320: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,

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

313: P_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
314: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
315: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
316: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
317: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
318: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
319: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
320: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
321: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,

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

314: P_TRANSACTION_TYPE IN JAI_CMN_RG_23AC_I_TRXS.transaction_type%TYPE DEFAULT NULL,
315: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
316: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
317: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
318: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
319: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
320: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
321: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
322: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,

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

315: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.receipt_date%TYPE DEFAULT NULL,
316: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
317: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
318: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
319: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
320: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
321: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
322: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
323: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,

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

316: P_RANGE_NO IN JAI_CMN_RG_23AC_I_TRXS.range_no%TYPE DEFAULT NULL,
317: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
318: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
319: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
320: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
321: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
322: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
323: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
324: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,

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

317: P_DIVISION_NO IN JAI_CMN_RG_23AC_I_TRXS.division_no%TYPE DEFAULT NULL,
318: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
319: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
320: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
321: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
322: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
323: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
324: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
325: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,

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

318: P_PO_HEADER_ID IN JAI_CMN_RG_23AC_I_TRXS.po_header_id%TYPE DEFAULT NULL,
319: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
320: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
321: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
322: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
323: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
324: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
325: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
326: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE DEFAULT NULL,

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

319: P_PO_HEADER_DATE IN JAI_CMN_RG_23AC_I_TRXS.po_header_date%TYPE DEFAULT NULL,
320: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
321: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
322: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
323: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
324: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
325: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
326: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE DEFAULT NULL,
327: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,

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

320: P_PO_LINE_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_id%TYPE DEFAULT NULL,
321: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
322: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
323: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
324: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
325: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
326: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE DEFAULT NULL,
327: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
328: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,

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

321: P_PO_LINE_LOCATION_ID IN JAI_CMN_RG_23AC_I_TRXS.po_line_location_id%TYPE DEFAULT NULL,
322: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
323: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
324: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
325: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
326: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE DEFAULT NULL,
327: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
328: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
329: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE DEFAULT NULL,

Line 326: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE DEFAULT NULL,

322: P_VENDOR_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_id%TYPE DEFAULT NULL,
323: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
324: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
325: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
326: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE DEFAULT NULL,
327: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
328: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
329: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE DEFAULT NULL,
330: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,

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

323: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.vendor_site_id%TYPE DEFAULT NULL,
324: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
325: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
326: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE DEFAULT NULL,
327: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
328: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
329: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE DEFAULT NULL,
330: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
331: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,

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

324: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_id%TYPE DEFAULT NULL,
325: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
326: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE DEFAULT NULL,
327: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
328: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
329: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE DEFAULT NULL,
330: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
331: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
332: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE DEFAULT NULL,

Line 329: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE DEFAULT NULL,

325: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
326: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE DEFAULT NULL,
327: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
328: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
329: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE DEFAULT NULL,
330: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
331: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
332: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE DEFAULT NULL,
333: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,

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

326: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE DEFAULT NULL,
327: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
328: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
329: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE DEFAULT NULL,
330: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
331: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
332: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE DEFAULT NULL,
333: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
334: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,

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

327: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
328: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
329: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE DEFAULT NULL,
330: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
331: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
332: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE DEFAULT NULL,
333: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
334: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
335: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,

Line 332: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE DEFAULT NULL,

328: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
329: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE DEFAULT NULL,
330: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
331: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
332: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE DEFAULT NULL,
333: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
334: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
335: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
336: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,

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

329: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE DEFAULT NULL,
330: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
331: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
332: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE DEFAULT NULL,
333: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
334: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
335: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
336: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
337: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,

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

330: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
331: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
332: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE DEFAULT NULL,
333: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
334: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
335: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
336: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
337: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
338: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,

Line 335: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,

331: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
332: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE DEFAULT NULL,
333: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
334: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
335: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
336: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
337: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
338: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
339: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,

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

332: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE DEFAULT NULL,
333: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
334: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
335: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
336: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
337: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
338: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
339: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
340: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,

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

333: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
334: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
335: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
336: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
337: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
338: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
339: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
340: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
341: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,

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

334: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
335: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
336: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
337: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
338: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
339: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
340: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
341: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
342: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,

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

335: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,
336: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
337: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
338: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
339: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
340: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
341: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
342: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
343: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,

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

336: P_OTH_RECEIPT_DATE IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_date%TYPE DEFAULT NULL,
337: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
338: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
339: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
340: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
341: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
342: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
343: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
344: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.REGISTER_ID_PART_II%TYPE DEFAULT NULL,

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

337: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_I_TRXS.register_type%TYPE DEFAULT NULL,
338: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
339: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
340: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
341: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
342: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
343: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
344: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.REGISTER_ID_PART_II%TYPE DEFAULT NULL,
345: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,

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

338: P_IDENTIFICATION_NO IN JAI_CMN_RG_23AC_I_TRXS.identification_no%TYPE DEFAULT NULL,
339: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
340: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
341: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
342: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
343: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
344: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.REGISTER_ID_PART_II%TYPE DEFAULT NULL,
345: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
346: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,

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

339: P_IDENTIFICATION_MARK IN JAI_CMN_RG_23AC_I_TRXS.identification_mark%TYPE DEFAULT NULL,
340: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
341: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
342: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
343: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
344: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.REGISTER_ID_PART_II%TYPE DEFAULT NULL,
345: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
346: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
347: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,

Line 344: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.REGISTER_ID_PART_II%TYPE DEFAULT NULL,

340: P_BRAND_NAME IN JAI_CMN_RG_23AC_I_TRXS.brand_name%TYPE DEFAULT NULL,
341: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
342: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
343: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
344: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.REGISTER_ID_PART_II%TYPE DEFAULT NULL,
345: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
346: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
347: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
348: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,

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

341: P_DATE_OF_VERIFICATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_verification%TYPE DEFAULT NULL,
342: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
343: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
344: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.REGISTER_ID_PART_II%TYPE DEFAULT NULL,
345: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
346: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
347: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
348: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
349: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Bug 5228046 added by sacsethi

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

342: P_DATE_OF_INSTALLATION IN JAI_CMN_RG_23AC_I_TRXS.date_of_installation%TYPE DEFAULT NULL,
343: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
344: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.REGISTER_ID_PART_II%TYPE DEFAULT NULL,
345: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
346: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
347: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
348: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
349: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Bug 5228046 added by sacsethi
350: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,

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

343: P_DATE_OF_COMMISSION IN JAI_CMN_RG_23AC_I_TRXS.date_of_commission%TYPE DEFAULT NULL,
344: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.REGISTER_ID_PART_II%TYPE DEFAULT NULL,
345: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
346: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
347: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
348: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
349: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Bug 5228046 added by sacsethi
350: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,
351: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,

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

344: P_REGISER_ID_PART_II IN JAI_CMN_RG_23AC_I_TRXS.REGISTER_ID_PART_II%TYPE DEFAULT NULL,
345: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
346: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
347: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
348: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
349: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Bug 5228046 added by sacsethi
350: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,
351: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,
352: P_POSTED_FLAG IN JAI_CMN_RG_23AC_I_TRXS.posted_flag%TYPE DEFAULT NULL,

Line 349: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Bug 5228046 added by sacsethi

345: P_PLACE_OF_INSTALL IN JAI_CMN_RG_23AC_I_TRXS.place_of_install%TYPE DEFAULT NULL,
346: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
347: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
348: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
349: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Bug 5228046 added by sacsethi
350: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,
351: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,
352: P_POSTED_FLAG IN JAI_CMN_RG_23AC_I_TRXS.posted_flag%TYPE DEFAULT NULL,
353: P_MASTER_FLAG IN JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE DEFAULT NULL,

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

346: P_REMARKS IN JAI_CMN_RG_23AC_I_TRXS.remarks%TYPE DEFAULT NULL,
347: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
348: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
349: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Bug 5228046 added by sacsethi
350: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,
351: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,
352: P_POSTED_FLAG IN JAI_CMN_RG_23AC_I_TRXS.posted_flag%TYPE DEFAULT NULL,
353: P_MASTER_FLAG IN JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE DEFAULT NULL,
354: P_TRANSACTION_SOURCE IN VARCHAR2,

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

347: P_BASIC_ED IN JAI_CMN_RG_23AC_I_TRXS.basic_ed%TYPE DEFAULT NULL,
348: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
349: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Bug 5228046 added by sacsethi
350: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,
351: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,
352: P_POSTED_FLAG IN JAI_CMN_RG_23AC_I_TRXS.posted_flag%TYPE DEFAULT NULL,
353: P_MASTER_FLAG IN JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE DEFAULT NULL,
354: P_TRANSACTION_SOURCE IN VARCHAR2,
355: P_CALLED_FROM IN VARCHAR2,

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

348: P_ADDITIONAL_ED IN JAI_CMN_RG_23AC_I_TRXS.additional_ed%TYPE DEFAULT NULL,
349: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Bug 5228046 added by sacsethi
350: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,
351: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,
352: P_POSTED_FLAG IN JAI_CMN_RG_23AC_I_TRXS.posted_flag%TYPE DEFAULT NULL,
353: P_MASTER_FLAG IN JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE DEFAULT NULL,
354: P_TRANSACTION_SOURCE IN VARCHAR2,
355: P_CALLED_FROM IN VARCHAR2,
356: P_SIMULATE_FLAG IN VARCHAR2,

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

349: P_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_I_TRXS.additional_cvd%TYPE DEFAULT NULL, -- Bug 5228046 added by sacsethi
350: P_OTHER_ED IN JAI_CMN_RG_23AC_I_TRXS.other_ed%TYPE DEFAULT NULL,
351: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_I_TRXS.charge_account_id%TYPE DEFAULT NULL,
352: P_POSTED_FLAG IN JAI_CMN_RG_23AC_I_TRXS.posted_flag%TYPE DEFAULT NULL,
353: P_MASTER_FLAG IN JAI_CMN_RG_23AC_I_TRXS.master_flag%TYPE DEFAULT NULL,
354: P_TRANSACTION_SOURCE IN VARCHAR2,
355: P_CALLED_FROM IN VARCHAR2,
356: P_SIMULATE_FLAG IN VARCHAR2,
357: P_PROCESS_STATUS OUT NOCOPY VARCHAR2,

Line 375: UPDATE JAI_CMN_RG_23AC_I_TRXS SET

371: ld_last_update_date := SYSDATE;
372: ln_last_updated_by := FND_GLOBAL.user_id;
373: ln_last_update_login := FND_GLOBAL.login_id;
374:
375: UPDATE JAI_CMN_RG_23AC_I_TRXS SET
376: QUANTITY_RECEIVED = nvl(P_QUANTITY_RECEIVED, QUANTITY_RECEIVED),
377: RECEIPT_REF = nvl(P_RECEIPT_ID, RECEIPT_REF),
378: TRANSACTION_TYPE = nvl(P_TRANSACTION_TYPE, TRANSACTION_TYPE),
379: RECEIPT_DATE = nvl(P_RECEIPT_DATE, RECEIPT_DATE),

Line 435: UPDATE JAI_CMN_RG_23AC_I_TRXS

431: ) IS
432:
433: BEGIN
434:
435: UPDATE JAI_CMN_RG_23AC_I_TRXS
436: SET
437: REGISTER_ID_PART_II = p_register_id_part_ii,
438: charge_account_id = p_charge_account_id,
439: last_update_date = SYSDATE

Line 456: FROM JAI_CMN_RG_23AC_I_TRXS

452:
453: ln_record_exist_cnt NUMBER(4);
454: CURSOR c_record_exist IS
455: SELECT count(1)
456: FROM JAI_CMN_RG_23AC_I_TRXS
457: WHERE organization_id = p_organization_id
458: AND location_id = p_location_id
459: AND inventory_item_id = p_inventory_item_id
460: AND register_type = p_register_type

Line 520: END jai_cmn_rg_23ac_i_trxs_pkg;

516: END IF;
517:
518: END get_trxn_type_and_id;
519:
520: END jai_cmn_rg_23ac_i_trxs_pkg;