[Home] [Help]
PACKAGE: APPS.JAI_CMN_GST_INV_GEN_PKG
Source
1 package jai_cmn_gst_inv_gen_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_gst_inv_gen.pls 120.2 2010/09/20 06:38:44 boboli noship $ */
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| jai_gst_inv_gen.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package is mainly used for generate GST |
13 --| invoice number and process accounting for GST |
14 --| |
15 --| TDD REFERENCE |
16 --| Take referce TDD_12_2_FIN_JAI_Enhanced_GST.doc |
17 --| |
18 --| |
19 --| PURPOSE |
20 --| PROCEDURE process |
21 --| |
22 --| HISTORY |
23 --| 02-Sep-2010 Created by Bo Li for bug#10043656 |
24 --| GST Enhancement for R12.1.3 |
25 --| |
26 --+======================================================================*/
27 g_debug VARCHAR2(1);
28 gv_called_from_dflt CONSTANT VARCHAR2(10) := 'Batch';
29
30 gn_cgst_regime_id jai_rgm_definitions.regime_id%type;
31 gn_sgst_regime_id jai_rgm_definitions.regime_id%type;
32
33 TYPE MainRecord IS RECORD (delivery_id JAI_RGM_GST_INVOICE_GEN_T.delivery_id%TYPE
34 , delivery_date JAI_RGM_GST_INVOICE_GEN_T.delivery_date%TYPE
35 , organization_id JAI_RGM_GST_INVOICE_GEN_T.organization_id%TYPE
36 , location_id JAI_RGM_GST_INVOICE_GEN_T.location_id%TYPE
37 , party_id JAI_RGM_GST_INVOICE_GEN_T.party_id%TYPE
38 , party_site_id JAI_RGM_GST_INVOICE_GEN_T.party_site_id%TYPE
39 , party_type JAI_RGM_GST_INVOICE_GEN_T.party_type%TYPE
40 , gst_invoice_no JAI_RGM_GST_INVOICE_GEN_T.gst_invoice_no%TYPE
41 , gst_inv_gen_status JAI_RGM_GST_INVOICE_GEN_T.gst_inv_gen_status%TYPE
42 , gst_acct_status JAI_RGM_GST_INVOICE_GEN_T.gst_acct_status%TYPE
43 , order_line_id JAI_RGM_GST_INVOICE_GEN_T.order_line_id%TYPE
44 , order_number JAI_RGM_GST_INVOICE_GEN_T.order_number%TYPE);
45
46 TYPE MainRec_Cur IS REF CURSOR;
47
48 -- Public constant declarations
49 PROCEDURE process (
50 retcode OUT NOCOPY VARCHAR2,
51 errbuf OUT NOCOPY VARCHAR2,
52 p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
53 p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
54 p_order_number_from OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
55 p_order_number_to OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
56 p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
57 p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
58 pv_delivery_date_from VARCHAR2,
59 pv_delivery_date_to VARCHAR2,
60 p_process_action VARCHAR2,
61 p_single_invoice_num VARCHAR2,
62 p_override_invoice_date VARCHAR2,
63 p_debug VARCHAR2
64 );
65
66
67 end jai_cmn_gst_inv_gen_pkg;