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_CMN_CUS_ADDRESSES

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

5300: S.No Date Author and Details
5301:
5302: **************************************************************************/
5303:
5304: cursor c_get_customer_pan (cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)
5305: IS
5306: select pan_no
5307: from JAI_CMN_CUS_ADDRESSES
5308: where customer_id = cp_customer_id

Line 5307: from JAI_CMN_CUS_ADDRESSES

5303:
5304: cursor c_get_customer_pan (cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)
5305: IS
5306: select pan_no
5307: from JAI_CMN_CUS_ADDRESSES
5308: where customer_id = cp_customer_id
5309: and confirm_pan = jai_constants.yes;
5310:
5311: cursor c_get_cust_typ_lkup_code(cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)

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

5307: from JAI_CMN_CUS_ADDRESSES
5308: where customer_id = cp_customer_id
5309: and confirm_pan = jai_constants.yes;
5310:
5311: cursor c_get_cust_typ_lkup_code(cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)
5312: IS
5313: select tcs_customer_type
5314: from JAI_CMN_CUS_ADDRESSES
5315: where customer_id = cp_customer_id

Line 5314: from JAI_CMN_CUS_ADDRESSES

5310:
5311: cursor c_get_cust_typ_lkup_code(cp_customer_id JAI_CMN_CUS_ADDRESSES.customer_id%type)
5312: IS
5313: select tcs_customer_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,

Line 5319: cp_customer_type_lkup_code JAI_CMN_CUS_ADDRESSES.tcs_customer_type%type,

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
5323: select

Line 5361: ln_party_pan_no JAI_CMN_CUS_ADDRESSES.pan_no%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;
5365: ln_user_id fnd_user.user_id%type := fnd_global.user_id;

Line 5362: ln_customer_type_lkup_code JAI_CMN_CUS_ADDRESSES.tcs_customer_type%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;
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;

Line 5998: p_old_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE ,

5994:
5995: PROCEDURE update_pan_for_tcs ( p_return_code OUT NOCOPY VARCHAR2 ,
5996: p_errbuf OUT NOCOPY VARCHAR2 ,
5997: p_party_id IN JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,
5998: p_old_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE ,
5999: p_new_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE
6000:
6001: )
6002: AS

Line 5999: p_new_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE

5995: PROCEDURE update_pan_for_tcs ( p_return_code OUT NOCOPY VARCHAR2 ,
5996: p_errbuf OUT NOCOPY VARCHAR2 ,
5997: p_party_id IN JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,
5998: p_old_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE ,
5999: p_new_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE
6000:
6001: )
6002: AS
6003: ln_reg_id NUMBER ;

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

6029:
6030:
6031: /*commented by csahoo for bug# 6401388
6032: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6033: pv_log_msg => 'Updating the table JAI_CMN_CUS_ADDRESSES'
6034: );*/
6035:
6036: /*
6037: ||Update the JAI_CMN_CUS_ADDRESSES table . Set the Old pan number with the new pan number as specified in the input.

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

6033: pv_log_msg => 'Updating the table JAI_CMN_CUS_ADDRESSES'
6034: );*/
6035:
6036: /*
6037: ||Update the JAI_CMN_CUS_ADDRESSES table . Set the Old pan number with the new pan number as specified in the input.
6038: */
6039: UPDATE
6040: JAI_CMN_CUS_ADDRESSES
6041: SET

Line 6040: JAI_CMN_CUS_ADDRESSES

6036: /*
6037: ||Update the JAI_CMN_CUS_ADDRESSES table . Set the Old pan number with the new pan number as specified in the input.
6038: */
6039: UPDATE
6040: JAI_CMN_CUS_ADDRESSES
6041: SET
6042: pan_no = p_new_pan_no
6043: WHERE
6044: customer_id = p_party_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 6054: ||Update the JAI_CMN_CUS_ADDRESSES table . Set the Old pan number with the new pan number as specified in the input.

6050: );*/
6051:
6052:
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