1 PACKAGE jai_cmn_rgm_settlement_pkg AS
2 /* $Header: jai_cmn_rgm_stl.pls 120.3.12010000.2 2008/10/17 09:48:02 jmeena 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 -- 4. 14-OCT-2008 JMEENA for bug#7445742
17 -- Incorporate the changes of bug#6835541
18 -- # Future Dependencies For the release Of this Object:-
19 -- # (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/
20 -- # A datamodel change )
21
22
23 --==============================================================================================================
24 -- # --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25 -- # Current Version Current Bug Dependent Files Version Author Date Remarks
26 -- # Of File On Bug/Patchset Dependent On
27 -- # jai_rgm_settlement_pkg_s.sql
28 -- # --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
29 -- # 115.0 4068930 4146708 Sanjikum 27/01/2005 This file is part of Service tax enhancement. So
30 -- # dependent on Service Tax and Education Cess Enhancement
31 -- # 115.2 4245365 4245089 Rchandan 17/03/2005 Changes were made to implement VAT. Two new procedures are added to this package
32 -- # --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
33 -- # ****************************************************************************************************************************************************************************************
34
35 PROCEDURE transfer_balance( pn_settlement_id IN jai_rgm_stl_balances.settlement_id%TYPE,
36 pv_process_flag OUT NOCOPY VARCHAR2,
37 pv_process_message OUT NOCOPY VARCHAR2);
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 )
61 RETURN DATE;
62
63 PROCEDURE get_last_balance_amount(pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
64 pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
65 pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,
66 pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE);
67
68 PROCEDURE register_entry( pn_regime_id IN NUMBER,
69 pn_settlement_id IN NUMBER,
70 pd_transaction_date IN DATE,
71 pv_process_flag OUT NOCOPY VARCHAR2,
72 pv_process_message OUT NOCOPY VARCHAR2);
73
74 FUNCTION get_last_settlement_date(pn_regime_id IN jai_rgm_settlements.regime_id%type,
75 pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
76 pn_location_id IN jai_rgm_stl_balances.location_id%TYPE)
77 RETURN DATE; ---4245365
78 /*Below code add by JMEENA for bug#7445742 */
79 /*
80 ||The following function addded by rchandan for bug#6835541
81 ||This function is used for VAT settlement where the user has the flexibility of
82 || of doing settlement at either registartion or organization or organization-location level
83 */
84 FUNCTION get_last_settlement_date(pn_regime_id IN NUMBER,
85 pn_regn_no IN VARCHAR2,
86 pn_organization_id IN NUMBER,
87 pn_location_id IN NUMBER)
88 RETURN DATE;
89
90 PROCEDURE get_last_balance_amount(pn_regime_id IN jai_rgm_settlements.regime_id%type,
91 pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
92 pn_location_id IN jai_rgm_stl_balances.location_id%TYPE,
93 pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
94 pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,
95 pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE,
96 pv_service_type_code IN jai_rgm_stl_balances.service_type_code%TYPE DEFAULT NULL /* added by ssawant for bug 5879769 */
97 ); ---4245365
98
99 END jai_cmn_rgm_settlement_pkg;
[Home] [Help]