131: END IF;
132:
133: /* Bug fix #464203
134: Two values may be passed into this procedure for trx_type
135: AR_APP ... Standard application reversal
136: AR_CM ... Credit Memo application reversal
137:
138: This procedure is called to update the applied transaction as
139: well as the Receipt or Credit Memo in payment schedules.
449: gl_date = l_ps_rec.gl_date,
450: receipt_confirmed_flag = l_ps_rec.receipt_confirmed_flag,
451: last_updated_by = arp_global.last_updated_by,
452: last_update_date = SYSDATE,
453: last_update_login = NVL(arp_standard.profile.last_update_login,l_ps_rec.last_update_login ),
454: request_id = NVL(arp_standard.profile.request_id,l_ps_rec.request_id),
455: program_application_id = NVL(arp_standard.profile.program_application_id,
456: l_ps_rec.program_application_id ),
457: program_id = NVL(arp_standard.profile.program_id, l_ps_rec.program_id),
450: receipt_confirmed_flag = l_ps_rec.receipt_confirmed_flag,
451: last_updated_by = arp_global.last_updated_by,
452: last_update_date = SYSDATE,
453: last_update_login = NVL(arp_standard.profile.last_update_login,l_ps_rec.last_update_login ),
454: request_id = NVL(arp_standard.profile.request_id,l_ps_rec.request_id),
455: program_application_id = NVL(arp_standard.profile.program_application_id,
456: l_ps_rec.program_application_id ),
457: program_id = NVL(arp_standard.profile.program_id, l_ps_rec.program_id),
458: program_update_date = DECODE(arp_standard.profile.program_id,
451: last_updated_by = arp_global.last_updated_by,
452: last_update_date = SYSDATE,
453: last_update_login = NVL(arp_standard.profile.last_update_login,l_ps_rec.last_update_login ),
454: request_id = NVL(arp_standard.profile.request_id,l_ps_rec.request_id),
455: program_application_id = NVL(arp_standard.profile.program_application_id,
456: l_ps_rec.program_application_id ),
457: program_id = NVL(arp_standard.profile.program_id, l_ps_rec.program_id),
458: program_update_date = DECODE(arp_standard.profile.program_id,
459: NULL, l_ps_rec.program_update_date,SYSDATE)
453: last_update_login = NVL(arp_standard.profile.last_update_login,l_ps_rec.last_update_login ),
454: request_id = NVL(arp_standard.profile.request_id,l_ps_rec.request_id),
455: program_application_id = NVL(arp_standard.profile.program_application_id,
456: l_ps_rec.program_application_id ),
457: program_id = NVL(arp_standard.profile.program_id, l_ps_rec.program_id),
458: program_update_date = DECODE(arp_standard.profile.program_id,
459: NULL, l_ps_rec.program_update_date,SYSDATE)
460: where
461: payment_schedule_id = l_ps_rec.payment_schedule_id;
454: request_id = NVL(arp_standard.profile.request_id,l_ps_rec.request_id),
455: program_application_id = NVL(arp_standard.profile.program_application_id,
456: l_ps_rec.program_application_id ),
457: program_id = NVL(arp_standard.profile.program_id, l_ps_rec.program_id),
458: program_update_date = DECODE(arp_standard.profile.program_id,
459: NULL, l_ps_rec.program_update_date,SYSDATE)
460: where
461: payment_schedule_id = l_ps_rec.payment_schedule_id;
462: END IF ;