eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_TCS_REP_PKG dependencies on JAI_RGM_THRESHOLDS

Line 5297: Purpose : Insert the record in jai_rgm_thresholds while booking the sales order

5293: /* **************************************************************************
5294: Creation Date : 01-Aug-2008
5295: Created By : JMEENA
5296: Bug Number : 7277211
5297: Purpose : Insert the record in jai_rgm_thresholds while booking the sales order
5298: Called From : PROCESS_TRANSACTION when p_event is BOOKED (sales order booked)
5299: CHANGE HISTORY:
5300: S.No Date Author and Details
5301:

Line 5318: cursor c_get_threshold_slab ( cp_regime_id jai_rgm_thresholds.regime_id%type,

5314: from JAI_CMN_CUS_ADDRESSES
5315: where customer_id = cp_customer_id
5316: AND tcs_customer_type IS NOT NULL;
5317:
5318: cursor c_get_threshold_slab ( cp_regime_id jai_rgm_thresholds.regime_id%type,
5319: cp_customer_type_lkup_code JAI_CMN_CUS_ADDRESSES.tcs_customer_type%type,
5320: cp_source_trx_date DATE
5321: )
5322: IS

Line 5340: cursor get_jai_rgm_thresholds_count ( cp_fin_year jai_rgm_thresholds.fin_year%type,

5336: and nvl(thtyps.to_date, trunc(cp_source_trx_date))
5337: and NVL(thslbs.from_amount,0) = 0;
5338:
5339:
5340: cursor get_jai_rgm_thresholds_count ( cp_fin_year jai_rgm_thresholds.fin_year%type,
5341: cp_org_tan_no jai_rgm_thresholds.org_tan_no%type,
5342: cp_party_type jai_rgm_thresholds.party_type%type,
5343: cp_party_id jai_rgm_thresholds.party_id%type,
5344: cp_regime_id jai_rgm_thresholds.regime_id%type

Line 5341: cp_org_tan_no jai_rgm_thresholds.org_tan_no%type,

5337: and NVL(thslbs.from_amount,0) = 0;
5338:
5339:
5340: cursor get_jai_rgm_thresholds_count ( cp_fin_year jai_rgm_thresholds.fin_year%type,
5341: cp_org_tan_no jai_rgm_thresholds.org_tan_no%type,
5342: cp_party_type jai_rgm_thresholds.party_type%type,
5343: cp_party_id jai_rgm_thresholds.party_id%type,
5344: cp_regime_id jai_rgm_thresholds.regime_id%type
5345: )

Line 5342: cp_party_type jai_rgm_thresholds.party_type%type,

5338:
5339:
5340: cursor get_jai_rgm_thresholds_count ( cp_fin_year jai_rgm_thresholds.fin_year%type,
5341: cp_org_tan_no jai_rgm_thresholds.org_tan_no%type,
5342: cp_party_type jai_rgm_thresholds.party_type%type,
5343: cp_party_id jai_rgm_thresholds.party_id%type,
5344: cp_regime_id jai_rgm_thresholds.regime_id%type
5345: )
5346: IS

Line 5343: cp_party_id jai_rgm_thresholds.party_id%type,

5339:
5340: cursor get_jai_rgm_thresholds_count ( cp_fin_year jai_rgm_thresholds.fin_year%type,
5341: cp_org_tan_no jai_rgm_thresholds.org_tan_no%type,
5342: cp_party_type jai_rgm_thresholds.party_type%type,
5343: cp_party_id jai_rgm_thresholds.party_id%type,
5344: cp_regime_id jai_rgm_thresholds.regime_id%type
5345: )
5346: IS
5347: select count(*)

Line 5344: cp_regime_id jai_rgm_thresholds.regime_id%type

5340: cursor get_jai_rgm_thresholds_count ( cp_fin_year jai_rgm_thresholds.fin_year%type,
5341: cp_org_tan_no jai_rgm_thresholds.org_tan_no%type,
5342: cp_party_type jai_rgm_thresholds.party_type%type,
5343: cp_party_id jai_rgm_thresholds.party_id%type,
5344: cp_regime_id jai_rgm_thresholds.regime_id%type
5345: )
5346: IS
5347: select count(*)
5348: from jai_rgm_thresholds

Line 5348: from jai_rgm_thresholds

5344: cp_regime_id jai_rgm_thresholds.regime_id%type
5345: )
5346: IS
5347: select count(*)
5348: from jai_rgm_thresholds
5349: where fin_year = cp_fin_year
5350: and org_tan_no = cp_org_tan_no
5351: and party_type = cp_party_type
5352: and party_id = cp_party_id

Line 5356: ln_regime_id jai_rgm_thresholds.regime_id%type;

5352: and party_id = cp_party_id
5353: and regime_id = cp_regime_id;
5354:
5355: lx_row_id rowid;
5356: ln_regime_id jai_rgm_thresholds.regime_id%type;
5357: ln_org_tan_no jai_rgm_thresholds.org_tan_no%type;
5358: ln_party_id jai_rgm_thresholds.party_id%type;
5359: ln_party_type jai_rgm_thresholds.party_type%type;
5360: ln_fin_year jai_rgm_thresholds.fin_year%type;

Line 5357: ln_org_tan_no jai_rgm_thresholds.org_tan_no%type;

5353: and regime_id = cp_regime_id;
5354:
5355: lx_row_id rowid;
5356: ln_regime_id jai_rgm_thresholds.regime_id%type;
5357: ln_org_tan_no jai_rgm_thresholds.org_tan_no%type;
5358: ln_party_id jai_rgm_thresholds.party_id%type;
5359: ln_party_type jai_rgm_thresholds.party_type%type;
5360: ln_fin_year jai_rgm_thresholds.fin_year%type;
5361: ln_party_pan_no JAI_CMN_CUS_ADDRESSES.pan_no%type;

Line 5358: ln_party_id jai_rgm_thresholds.party_id%type;

5354:
5355: lx_row_id rowid;
5356: ln_regime_id jai_rgm_thresholds.regime_id%type;
5357: ln_org_tan_no jai_rgm_thresholds.org_tan_no%type;
5358: ln_party_id jai_rgm_thresholds.party_id%type;
5359: ln_party_type jai_rgm_thresholds.party_type%type;
5360: ln_fin_year jai_rgm_thresholds.fin_year%type;
5361: ln_party_pan_no JAI_CMN_CUS_ADDRESSES.pan_no%type;
5362: ln_customer_type_lkup_code JAI_CMN_CUS_ADDRESSES.tcs_customer_type%type;

Line 5359: ln_party_type jai_rgm_thresholds.party_type%type;

5355: lx_row_id rowid;
5356: ln_regime_id jai_rgm_thresholds.regime_id%type;
5357: ln_org_tan_no jai_rgm_thresholds.org_tan_no%type;
5358: ln_party_id jai_rgm_thresholds.party_id%type;
5359: ln_party_type jai_rgm_thresholds.party_type%type;
5360: ln_fin_year jai_rgm_thresholds.fin_year%type;
5361: ln_party_pan_no JAI_CMN_CUS_ADDRESSES.pan_no%type;
5362: ln_customer_type_lkup_code JAI_CMN_CUS_ADDRESSES.tcs_customer_type%type;
5363: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type default NULL;

Line 5360: ln_fin_year jai_rgm_thresholds.fin_year%type;

5356: ln_regime_id jai_rgm_thresholds.regime_id%type;
5357: ln_org_tan_no jai_rgm_thresholds.org_tan_no%type;
5358: ln_party_id jai_rgm_thresholds.party_id%type;
5359: ln_party_type jai_rgm_thresholds.party_type%type;
5360: ln_fin_year jai_rgm_thresholds.fin_year%type;
5361: ln_party_pan_no JAI_CMN_CUS_ADDRESSES.pan_no%type;
5362: ln_customer_type_lkup_code JAI_CMN_CUS_ADDRESSES.tcs_customer_type%type;
5363: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type default NULL;
5364: lr_hdr_record jai_rgm_thresholds%rowtype;

Line 5364: lr_hdr_record jai_rgm_thresholds%rowtype;

5360: ln_fin_year jai_rgm_thresholds.fin_year%type;
5361: ln_party_pan_no JAI_CMN_CUS_ADDRESSES.pan_no%type;
5362: ln_customer_type_lkup_code JAI_CMN_CUS_ADDRESSES.tcs_customer_type%type;
5363: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type default NULL;
5364: lr_hdr_record jai_rgm_thresholds%rowtype;
5365: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
5366: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
5367: ln_count NUMBER;
5368: ln_threshold_id jai_rgm_thresholds.threshold_id%type default NULL;

Line 5368: ln_threshold_id jai_rgm_thresholds.threshold_id%type default NULL;

5364: lr_hdr_record jai_rgm_thresholds%rowtype;
5365: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
5366: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
5367: ln_count NUMBER;
5368: ln_threshold_id jai_rgm_thresholds.threshold_id%type default NULL;
5369: BEGIN
5370:
5371: OPEN get_tcs_fin_year( cp_org_id => p_ooh.org_id ,
5372: cp_trx_date => p_ooh.creation_date

Line 5425: OPEN get_jai_rgm_thresholds_count ( cp_fin_year => ln_fin_year,

5421: CLOSE c_get_threshold_slab;
5422:
5423: ln_count :=0;
5424:
5425: OPEN get_jai_rgm_thresholds_count ( cp_fin_year => ln_fin_year,
5426: cp_org_tan_no => ln_org_tan_no,
5427: cp_party_type => jai_constants.party_type_customer,
5428: cp_party_id => p_ooh.sold_to_org_id ,
5429: cp_regime_id => ln_regime_id

Line 5431: FETCH get_jai_rgm_thresholds_count INTO ln_count;

5427: cp_party_type => jai_constants.party_type_customer,
5428: cp_party_id => p_ooh.sold_to_org_id ,
5429: cp_regime_id => ln_regime_id
5430: );
5431: FETCH get_jai_rgm_thresholds_count INTO ln_count;
5432: CLOSE get_jai_rgm_thresholds_count;
5433:
5434: lr_hdr_record.threshold_id := ln_threshold_id ;
5435: lr_hdr_record.regime_id := ln_regime_id;

Line 5432: CLOSE get_jai_rgm_thresholds_count;

5428: cp_party_id => p_ooh.sold_to_org_id ,
5429: cp_regime_id => ln_regime_id
5430: );
5431: FETCH get_jai_rgm_thresholds_count INTO ln_count;
5432: CLOSE get_jai_rgm_thresholds_count;
5433:
5434: lr_hdr_record.threshold_id := ln_threshold_id ;
5435: lr_hdr_record.regime_id := ln_regime_id;
5436: lr_hdr_record.org_tan_no := ln_org_tan_no ;

Line 5449: --Insert in jai_rgm_thresholds only if records does not exists.

5445: lr_hdr_record.last_update_date := sysdate ;
5446: lr_hdr_record.last_updated_by := ln_user_id ;
5447: lr_hdr_record.last_update_login := ln_login_id ;
5448: lr_hdr_record.party_pan_no :=ln_party_pan_no;
5449: --Insert in jai_rgm_thresholds only if records does not exists.
5450: IF NVL(ln_count,0) = 0 THEN
5451:
5452: jai_rgm_thhold_proc_pkg.insert_threshold_hdr ( p_record => lr_hdr_record
5453: , p_threshold_id => ln_threshold_id

Line 6049: pv_log_msg => 'Update to table JAI_CMN_CUS_ADDRESSES successful. Now updating the table jai_rgm_thresholds '

6045: AND pan_no = p_old_pan_no ;
6046:
6047: /*commented by csahoo for bug# 6401388
6048: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6049: pv_log_msg => 'Update to table JAI_CMN_CUS_ADDRESSES successful. Now updating the table jai_rgm_thresholds '
6050: );*/
6051:
6052:
6053: /*

Line 6057: jai_rgm_thresholds

6053: /*
6054: ||Update the JAI_CMN_CUS_ADDRESSES table . Set the Old pan number with the new pan number as specified in the input.
6055: */
6056: UPDATE
6057: jai_rgm_thresholds
6058: SET
6059: party_pan_no = p_new_pan_no
6060: WHERE
6061: party_id = p_party_id