DBA Data[Home] [Help]

APPS.ARP_PS_UTIL dependencies on ARP_STANDARD

Line 453: last_update_login = NVL(arp_standard.profile.last_update_login,l_ps_rec.last_update_login ),

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),

Line 454: request_id = NVL(arp_standard.profile.request_id,l_ps_rec.request_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,

Line 455: program_application_id = NVL(arp_standard.profile.program_application_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)

Line 457: program_id = NVL(arp_standard.profile.program_id, l_ps_rec.program_id),

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;

Line 458: program_update_date = DECODE(arp_standard.profile.program_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 ;