1 PACKAGE jai_cmn_rgm_processing_pkg AS
2 /* $Header: jai_cmn_rgm_prc.pls 120.4 2007/05/22 14:54:04 kunkumar ship $ */
3
4 /*----------------------------------------------------------------------------------------------------------------------------
5 CHANGE HISTORY for FILENAME: jai_rgm_trx_processing_pkg_s.sql
6 S.No dd/mm/yyyy Author and Details
7 ------------------------------------------------------------------------------------------------------------------------------
8 1 26/07/2004 Vijay Shankar for Bug# 4068823, Version:115.0
9
10 Package that Starts Service Tax Processing of both AP and AR transactions based on the inputs
11 provided through request of "India - Service Tax Processing" concurrent
12 2 12/04/2005 Brathod, for Bug# 4286646, Version 115.1
13 Issue :-
14 Because of change in Valueset from JA_IN_DATE to FND_STANDARD_DATE Concurrent was resulting
15 in error because JA_IN_DATE uses normal date format while FND_STANDARD_DATE uses NLS_DATE format
16 and it is passed as character value.
17 Fix :-
18 Procedure signature modified to convert p_trx_from_date, p_trx_from_date from date to
19 pv_trx_from_date, pv_trx_from_date varchar2.
20 DEPENDANCY:
21 -----------
22 IN60106 + 4068823
23
24 3. 08-Jun-2005 Version 116.1 jai_cmn_rgm_prc -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
25 as required for CASE COMPLAINCE.
26
27 4. 05-Jul-2006 Aiyer for the bug 5369250, Version 120.3
28 Issue:-
29 --------
30 The concurrent failes with the following error :-
31 "FDPSTP failed due to ORA-01861: literal does not match format string ORA-06512: at line 1 "
32
33 Reason:-
34 ---------
35 The procedure PROCESS had a parameters p_override_invoice_date of type date , however the concurrent program
36 passes it in the canonical format and hence the failure.
37
38 Fix:-
39 -----------
40 Modified the procedure process.
41 Changed the datatype of p_override_invoice_date from date to varchar2 as this parameter.
42 Also added the new parameter ld_override_invoice_date . The value in p_override_invoice_date would be converted to date format and
43 stored in the local variable ld_override_invoice_date.
44
45 Dependency due to this fix:-
46 None
47 ----------------------------------------------------------------------------------------------------------------------------*/
48
49 g_debug VARCHAR2(1); --File.Sql.35 by Brathod
50 gv_called_from_dflt CONSTANT VARCHAR2(10) := 'Batch'; -- File.Sql.35 by Brathod
51
52 PROCEDURE process_batch(
53 errbuf OUT NOCOPY VARCHAR2,
54 retcode OUT NOCOPY VARCHAR2,
55 p_regime_id IN NUMBER,
56 p_rgm_registration_num IN VARCHAR2,
57 pv_trx_from_date IN VARCHAR2,
58 pv_trx_till_date IN VARCHAR2,
59 p_called_from IN VARCHAR2, -- DEFAULT 'Batch' File.Sql.35 by Brathod
60 p_debug IN VARCHAR2, -- DEFAULT 'Y' File.Sql.35 by Brathod
61 p_trace_switch IN VARCHAR2, -- DEFAULT 'N' File.Sql.35 by Brathod
62 p_organization_id IN NUMBER default null --Added by kunkumar for bug#6066813
63 );
64
65 PROCEDURE process_payments(
66 p_regime_id IN NUMBER,
67 p_organization_type IN VARCHAR2,
68 p_trx_from_date IN DATE,
69 p_trx_to_date IN DATE,
70 p_org_id IN NUMBER,
71 p_batch_id IN NUMBER,
72 p_debug IN VARCHAR2,
73 p_process_flag OUT NOCOPY VARCHAR2,
74 p_process_message OUT NOCOPY VARCHAR2,
75 p_organization_id IN NUMBER default null --Added by kunkumar for bug#6066813
76 );
77
78 PROCEDURE insert_request_details(
79 p_batch_id OUT NOCOPY NUMBER,
80 p_regime_id IN NUMBER,
81 p_rgm_registration_num IN VARCHAR2,
82 p_trx_from_date IN DATE,
83 p_trx_till_date IN DATE
84 );
85
86 FUNCTION get_item_line_id(
87 p_invoice_id IN NUMBER,
88 p_po_distribution_id IN NUMBER,
89 p_rcv_transaction_id IN NUMBER
90 ) RETURN NUMBER;
91
92 /*
93 CREATED BY : ssumaith
94 CREATED DATE : 15-MAR-2005
95 ENHANCEMENT BUG : 4245053
96 PURPOSE : wrapper program to interpret the input parameters and suitably call program to
97 generate vat imvoice number and pass accounting during shipment
98 CALLED FROM : Concurrent program JAIVATP
99 */
100 PROCEDURE process (
101 retcode OUT NOCOPY VARCHAR2,
102 errbuf OUT NOCOPY VARCHAR2,
103 p_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE,
104 p_registration_num JAI_RGM_TRX_RECORDS.REGIME_PRIMARY_REGNO%TYPE,
105 p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
106 p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
107 p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
108 p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
109 pv_delivery_date_from VARCHAR2, --DATE, Harshita for Bug 4918870
110 pv_delivery_date_to VARCHAR2, --DATE, Harshita for Bug 4918870
111 p_process_action VARCHAR2,
112 p_single_invoice_num VARCHAR2,
113 p_override_invoice_date VARCHAR2 , /* aiyer for the bug 5369250 */
114 p_debug VARCHAR2
115 );
116
117
118 END jai_cmn_rgm_processing_pkg;