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.
PACKAGE: APPS.JAI_CMN_RG_23AC_I_TRXS_PKG

Source


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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
109   P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2
110 );
111 
112 PROCEDURE update_payment_details(
113   p_register_id         IN  NUMBER,
114   p_register_id_part_ii IN  NUMBER,
115   p_charge_account_id   IN  NUMBER
116 );
117 
118 FUNCTION get_trxn_entry_cnt(
119   p_register_type   IN VARCHAR2,
120   p_organization_id   IN NUMBER,
121   p_location_id     IN NUMBER,
122   p_inventory_item_id IN NUMBER,
123   p_receipt_id    IN VARCHAR2,
124   p_transaction_id IN NUMBER
125 ) RETURN NUMBER;
126 
127 PROCEDURE get_trxn_type_and_id(
128   p_transaction_type    IN OUT NOCOPY VARCHAR2,
129   p_transaction_source  IN      VARCHAR2,
130   p_transaction_id OUT NOCOPY NUMBER
131 );
132 
133 END jai_cmn_rg_23ac_i_trxs_pkg;