1 PACKAGE jai_cmn_rgm_settlement_pkg AS
2 /* $Header: jai_cmn_rgm_stl.pls 120.5.12020000.2 2012/12/11 06:45:11 qioliu ship $ */
3 -- #****************************************************************************************************************************************************************************************
4 -- #
5 -- # Change History -
6 -- # 1. 27-Jan-2005 Sanjikum for Bug #4059774 Version #115.0
7 -- # New Package created for Service Tax settlement
8
9 -- 2. 08-Jun-2005 Version 116.1 jai_cmn_rgm_stl -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
10 -- as required for CASE COMPLAINCE.
11
12 -- 3. 25-April-2007 ssawant for bug 5879769 ,File version
13 -- Forward porting of
14 -- ENH : SERVICE TAX BY INVENTORY ORGANIZATION AND SERVICE TYPE SOLUTION from 11.5( bug no 5694855) to R12 (bug no 5879769).
15 -- Added p_service_type_code in get_last_balance_amount procedure
16
17 -- # Future Dependencies For the release Of this Object:-
18 -- # (Please add a row in the section below only if your bug introduces a dependency due to spec change/ A new call to a object/
19 -- # A datamodel change )
20
21
22 --==============================================================================================================
23 -- # --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
24 -- # Current Version Current Bug Dependent Files Version Author Date Remarks
25 -- # Of File On Bug/Patchset Dependent On
26 -- # jai_rgm_settlement_pkg_s.sql
27 -- # --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
28 -- # 115.0 4068930 4146708 Sanjikum 27/01/2005 This file is part of Service tax enhancement. So
29 -- # dependent on Service Tax and Education Cess Enhancement
30 -- # 115.2 4245365 4245089 Rchandan 17/03/2005 Changes were made to implement VAT. Two new procedures are added to this package
31 -- # --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
32 -- # ****************************************************************************************************************************************************************************************
33
34 PROCEDURE transfer_balance( pn_settlement_id IN jai_rgm_stl_balances.settlement_id%TYPE,
35 pv_process_flag OUT NOCOPY VARCHAR2,
36 pv_process_message OUT NOCOPY VARCHAR2,
37 pv_reverse_charge_flag IN jai_rgm_settlements.reverse_charge_flag%TYPE DEFAULT NULL);--Added by Qiong for reverse charge settlement
38
39 PROCEDURE create_invoice( pn_regime_id IN jai_rgm_settlements.regime_id%TYPE,
40 pn_settlement_id IN jai_rgm_settlements.settlement_id%TYPE,
41 pd_settlement_date IN jai_rgm_settlements.settlement_date%TYPE,
42 pn_vendor_id IN jai_rgm_settlements.tax_authority_id%TYPE,
43 pn_vendor_site_id IN jai_rgm_settlements.tax_authority_site_id%TYPE,
44 pn_calculated_amount IN jai_rgm_settlements.calculated_amount%TYPE,
45 pn_invoice_amount IN jai_rgm_settlements.payment_amount%TYPE,
46 pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
47 pv_regsitration_no IN jai_rgm_settlements.primary_registration_no%TYPE,
48 pn_created_by IN ap_invoices_interface.created_by%TYPE,
49 pd_creation_date IN ap_invoices_interface.creation_date%TYPE,
50 pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,
51 pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,
52 pn_last_update_login IN ap_invoices_interface.last_update_login%TYPE,
53 pv_system_invoice_no OUT NOCOPY jai_rgm_settlements.system_invoice_no%TYPE,
54 pv_process_flag OUT NOCOPY VARCHAR2,
55 pv_process_message OUT NOCOPY VARCHAR2);
56
57 FUNCTION get_last_settlement_date(pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
58 /* Bug 5096787. Added by Lakshmi Gopalsami */
59 pn_regime_id IN jai_rgm_settlements.regime_id%TYPE DEFAULT NULL,
60 pv_reverse_charge_flag IN jai_rgm_settlements.reverse_charge_flag%TYPE DEFAULT NULL--Added by Qiong for reverse charge settlement
61 )
62 RETURN DATE;
63
64 PROCEDURE get_last_balance_amount(pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
65 pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
66 pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,
67 pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE);
68
69 PROCEDURE register_entry( pn_regime_id IN NUMBER,
70 pn_settlement_id IN NUMBER,
71 pd_transaction_date IN DATE,
72 pv_process_flag OUT NOCOPY VARCHAR2,
73 pv_process_message OUT NOCOPY VARCHAR2);
74
75 FUNCTION get_last_settlement_date(pn_regime_id IN jai_rgm_settlements.regime_id%type,
76 pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
77 pn_location_id IN jai_rgm_stl_balances.location_id%TYPE,
78 pv_reverse_charge_flag IN jai_rgm_settlements.reverse_charge_flag%type DEFAULT NULL)
79 RETURN DATE; ---4245365
80
81 /*
82 ||The following function addded by rchandan for bug#6835541
83 ||This function is used for VAT settlement where the user has the flexibility of
84 || of doing settlement at either registartion or organization or organization-location level
85 */
86 FUNCTION get_last_settlement_date(pn_regime_id IN NUMBER,
87 pn_regn_no IN VARCHAR2,
88 pn_organization_id IN NUMBER,
89 pn_location_id IN NUMBER)
90 RETURN DATE;
91
92 PROCEDURE get_last_balance_amount(pn_regime_id IN jai_rgm_settlements.regime_id%type,
93 pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
94 pn_location_id IN jai_rgm_stl_balances.location_id%TYPE,
95 pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
96 pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,
97 pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE,
98 pv_service_type_code IN jai_rgm_stl_balances.service_type_code%TYPE DEFAULT NULL /* added by ssawant for bug 5879769 */
99 ); ---4245365
100
101 END jai_cmn_rgm_settlement_pkg;