DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_CMN_RGM_TAX_DIST_PKG

Line 1: PACKAGE BODY jai_cmn_rgm_tax_dist_pkg AS

1: PACKAGE BODY jai_cmn_rgm_tax_dist_pkg AS
2: /* $Header: jai_cmn_rgm_dist.plb 120.14.12010000.6 2009/02/04 12:21:14 vkaranam ship $ */
3: /***************************************************************************************************
4: CREATED BY : ssumaith
5: CREATED DATE : 11-JAN-2005

Line 153: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.insert_records_into_temp';

149: p_service_type_code VARCHAR2 DEFAULT NULL/*Bug 5879769 bduvarag*/
150: )
151: is
152: /* Added by Ramananda for bug#4407165 */
153: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.insert_records_into_temp';
154:
155: BEGIN
156: INSERT INTO JAI_RGM_BALANCE_T
157: (

Line 219: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.calculate_balances_for_io';

215: p_request_id number,
216: p_service_type_code VARCHAR2 DEFAULT NULL/*Bug 5879769 bduvarag*/
217: ) is
218: /* Added by Ramananda for bug#4407165 */
219: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.calculate_balances_for_io';
220: /*
221: ||CSahoo. Bug 5073553. removed the where clause that the nvl(rg23A_balance,0) + nvl(rg23c_balance,0) <> 0
222: ||instead now the criteria should be that in the form JAIRGMDT.fmb , user should not be able to select a IO with this sum = 0.
223: */

Line 414: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.punch_settlement_id';

410: p_regn_no VARCHAR2 default NULL/*6835541*/
411: )
412: is
413: /* Added by Ramananda for bug#4407165 */
414: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.punch_settlement_id';
415:
416: CURSOR cur_regime_code IS /* 4245365*/
417: SELECT regime_code
418: FROM JAI_RGM_DEFINITIONS -- ADDED BY SACSETHI ON 30-01-2007 FOR BUG 5631784

Line 483: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.calculate_balances_for_ou';

479: p_location_id number default null, /*rchandan for bug#5642053*/
480: p_service_type_code varchar2 default null -- bduvarag for Bug 5694855
481: ) is
482: /* Added by Ramananda for bug#4407165 */
483: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.calculate_balances_for_ou';
484: lv_source_trx_type jai_rgm_trx_records.source_trx_type%TYPE ;--rchandan for bug#4428980
485: lv_reg_type jai_rgm_registrations.registration_type%TYPE ;
486:
487: CURSOR c_regime_code IS

Line 2293: END JAI_CMN_RGM_TAX_DIST_PKG;

2289:
2290: END ;
2291: -- ended, Harshita for Bug 5096787
2292: ----------------------------------------------------------------------------------------------------------------
2293: END JAI_CMN_RGM_TAX_DIST_PKG;