DBA Data[Home] [Help]

APPS.FV_CCR_UTIL_PVT dependencies on IBY_PMT_INSTR_USES_ALL

Line 1501: update iby_pmt_instr_uses_all

1497: end;
1498:
1499:
1500: Begin
1501: update iby_pmt_instr_uses_all
1502: set end_date=sysdate
1503: where ext_pmt_party_id in
1504: (select distinct ext_payee_id from iby_external_payees_all
1505: where supplier_site_id=l_ss_vendor_site_id

Line 3118: 'Updating iby_pmt_instr_uses_all with end date');

3114: AND nvl(p_pay_site_id,0)<>0 AND
3115: (p_valid_bank_info='Y' OR p_federal_vendor='N')) THEN
3116:
3117: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
3118: 'Updating iby_pmt_instr_uses_all with end date');
3119:
3120: UPDATE iby_pmt_instr_uses_all
3121: SET END_DATE = sysdate-1,
3122: last_update_date=sysdate,

Line 3120: UPDATE iby_pmt_instr_uses_all

3116:
3117: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
3118: 'Updating iby_pmt_instr_uses_all with end date');
3119:
3120: UPDATE iby_pmt_instr_uses_all
3121: SET END_DATE = sysdate-1,
3122: last_update_date=sysdate,
3123: last_updated_by=l_user_id,
3124: last_update_login=l_login_id

Line 3172: UPDATE iby_pmt_instr_uses_all

3168:
3169: if(l_uses_reln_exists = 'Y') THEN
3170:
3171: IF(l_end_date IS NOT NULL) THEN
3172: UPDATE iby_pmt_instr_uses_all
3173: SET end_date=null,
3174: start_date=p_file_date,
3175: last_update_date = sysdate,
3176: last_updated_by = l_user_id,