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.

[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 5916: cursor c_get_customer_pan (cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)

5912: S.No Date Author and Details
5913:
5914: **************************************************************************/
5915:
5916: cursor c_get_customer_pan (cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)
5917: IS
5918: select pan_no
5919: from JAI_CMN_CUS_ADDRESSES
5920: where customer_id = cp_customer_id

Line 5919: from JAI_CMN_CUS_ADDRESSES

5915:
5916: cursor c_get_customer_pan (cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)
5917: IS
5918: select pan_no
5919: from JAI_CMN_CUS_ADDRESSES
5920: where customer_id = cp_customer_id
5921: and confirm_pan = jai_constants.yes;
5922:
5923: cursor c_get_cust_typ_lkup_code(cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)

Line 5923: cursor c_get_cust_typ_lkup_code(cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)

5919: from JAI_CMN_CUS_ADDRESSES
5920: where customer_id = cp_customer_id
5921: and confirm_pan = jai_constants.yes;
5922:
5923: cursor c_get_cust_typ_lkup_code(cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)
5924: IS
5925: select tcs_customer_type
5926: from JAI_CMN_CUS_ADDRESSES
5927: where customer_id = cp_customer_id

Line 5926: from JAI_CMN_CUS_ADDRESSES

5922:
5923: cursor c_get_cust_typ_lkup_code(cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)
5924: IS
5925: select tcs_customer_type
5926: from JAI_CMN_CUS_ADDRESSES
5927: where customer_id = cp_customer_id
5928: AND tcs_customer_type IS NOT NULL;
5929:
5930: cursor c_get_threshold_slab ( cp_regime_id jai_rgm_thresholds.regime_id%type,

Line 5931: cp_customer_type_lkup_code JAI_CMN_CUS_ADDRESSES.tcs_customer_type%type,

5927: where customer_id = cp_customer_id
5928: AND tcs_customer_type IS NOT NULL;
5929:
5930: cursor c_get_threshold_slab ( cp_regime_id jai_rgm_thresholds.regime_id%type,
5931: cp_customer_type_lkup_code JAI_CMN_CUS_ADDRESSES.tcs_customer_type%type,
5932: cp_source_trx_date DATE
5933: )
5934: IS
5935: select

Line 5973: ln_party_pan_no JAI_CMN_CUS_ADDRESSES.pan_no%type;

5969: ln_org_tan_no jai_rgm_thresholds.org_tan_no%type;
5970: ln_party_id jai_rgm_thresholds.party_id%type;
5971: ln_party_type jai_rgm_thresholds.party_type%type;
5972: ln_fin_year jai_rgm_thresholds.fin_year%type;
5973: ln_party_pan_no JAI_CMN_CUS_ADDRESSES.pan_no%type;
5974: ln_customer_type_lkup_code JAI_CMN_CUS_ADDRESSES.tcs_customer_type%type;
5975: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type default NULL;
5976: lr_hdr_record jai_rgm_thresholds%rowtype;
5977: ln_user_id fnd_user.user_id%type := fnd_global.user_id;

Line 5974: ln_customer_type_lkup_code JAI_CMN_CUS_ADDRESSES.tcs_customer_type%type;

5970: ln_party_id jai_rgm_thresholds.party_id%type;
5971: ln_party_type jai_rgm_thresholds.party_type%type;
5972: ln_fin_year jai_rgm_thresholds.fin_year%type;
5973: ln_party_pan_no JAI_CMN_CUS_ADDRESSES.pan_no%type;
5974: ln_customer_type_lkup_code JAI_CMN_CUS_ADDRESSES.tcs_customer_type%type;
5975: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type default NULL;
5976: lr_hdr_record jai_rgm_thresholds%rowtype;
5977: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
5978: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;

Line 6615: p_old_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE ,

6611:
6612: PROCEDURE update_pan_for_tcs ( p_return_code OUT NOCOPY VARCHAR2 ,
6613: p_errbuf OUT NOCOPY VARCHAR2 ,
6614: p_party_id IN JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,
6615: p_old_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE ,
6616: p_new_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE
6617:
6618: )
6619: AS

Line 6616: p_new_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE

6612: PROCEDURE update_pan_for_tcs ( p_return_code OUT NOCOPY VARCHAR2 ,
6613: p_errbuf OUT NOCOPY VARCHAR2 ,
6614: p_party_id IN JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,
6615: p_old_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE ,
6616: p_new_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE
6617:
6618: )
6619: AS
6620: ln_reg_id NUMBER ;

Line 6650: pv_log_msg => 'Updating the table JAI_CMN_CUS_ADDRESSES'

6646:
6647:
6648: /*commented by csahoo for bug# 6401388
6649: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6650: pv_log_msg => 'Updating the table JAI_CMN_CUS_ADDRESSES'
6651: );*/
6652:
6653: /*
6654: ||Update the JAI_CMN_CUS_ADDRESSES table . Set the Old pan number with the new pan number as specified in the input.

Line 6654: ||Update the JAI_CMN_CUS_ADDRESSES table . Set the Old pan number with the new pan number as specified in the input.

6650: pv_log_msg => 'Updating the table JAI_CMN_CUS_ADDRESSES'
6651: );*/
6652:
6653: /*
6654: ||Update the JAI_CMN_CUS_ADDRESSES table . Set the Old pan number with the new pan number as specified in the input.
6655: */
6656: UPDATE
6657: JAI_CMN_CUS_ADDRESSES
6658: SET

Line 6657: JAI_CMN_CUS_ADDRESSES

6653: /*
6654: ||Update the JAI_CMN_CUS_ADDRESSES table . Set the Old pan number with the new pan number as specified in the input.
6655: */
6656: UPDATE
6657: JAI_CMN_CUS_ADDRESSES
6658: SET
6659: pan_no = p_new_pan_no
6660: WHERE
6661: customer_id = p_party_id

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

6662: AND pan_no = p_old_pan_no ;
6663:
6664: /*commented by csahoo for bug# 6401388
6665: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6666: pv_log_msg => 'Update to table JAI_CMN_CUS_ADDRESSES successful. Now updating the table jai_rgm_thresholds '
6667: );*/
6668:
6669:
6670: /*

Line 6671: ||Update the JAI_CMN_CUS_ADDRESSES table . Set the Old pan number with the new pan number as specified in the input.

6667: );*/
6668:
6669:
6670: /*
6671: ||Update the JAI_CMN_CUS_ADDRESSES table . Set the Old pan number with the new pan number as specified in the input.
6672: */
6673: UPDATE
6674: jai_rgm_thresholds
6675: SET