DBA Data[Home] [Help]

APPS.ARP_PS_UTIL dependencies on ARP_STANDARD

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

549: gl_date = l_ps_rec.gl_date,
550: receipt_confirmed_flag = l_ps_rec.receipt_confirmed_flag,
551: last_updated_by = arp_global.last_updated_by,
552: last_update_date = SYSDATE,
553: last_update_login = NVL(arp_standard.profile.last_update_login,l_ps_rec.last_update_login ),
554: request_id = NVL(arp_standard.profile.request_id,l_ps_rec.request_id),
555: program_application_id = NVL(arp_standard.profile.program_application_id,
556: l_ps_rec.program_application_id ),
557: program_id = NVL(arp_standard.profile.program_id, l_ps_rec.program_id),

Line 554: request_id = NVL(arp_standard.profile.request_id,l_ps_rec.request_id),

550: receipt_confirmed_flag = l_ps_rec.receipt_confirmed_flag,
551: last_updated_by = arp_global.last_updated_by,
552: last_update_date = SYSDATE,
553: last_update_login = NVL(arp_standard.profile.last_update_login,l_ps_rec.last_update_login ),
554: request_id = NVL(arp_standard.profile.request_id,l_ps_rec.request_id),
555: program_application_id = NVL(arp_standard.profile.program_application_id,
556: l_ps_rec.program_application_id ),
557: program_id = NVL(arp_standard.profile.program_id, l_ps_rec.program_id),
558: program_update_date = DECODE(arp_standard.profile.program_id,

Line 555: program_application_id = NVL(arp_standard.profile.program_application_id,

551: last_updated_by = arp_global.last_updated_by,
552: last_update_date = SYSDATE,
553: last_update_login = NVL(arp_standard.profile.last_update_login,l_ps_rec.last_update_login ),
554: request_id = NVL(arp_standard.profile.request_id,l_ps_rec.request_id),
555: program_application_id = NVL(arp_standard.profile.program_application_id,
556: l_ps_rec.program_application_id ),
557: program_id = NVL(arp_standard.profile.program_id, l_ps_rec.program_id),
558: program_update_date = DECODE(arp_standard.profile.program_id,
559: NULL, l_ps_rec.program_update_date,SYSDATE),

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

553: last_update_login = NVL(arp_standard.profile.last_update_login,l_ps_rec.last_update_login ),
554: request_id = NVL(arp_standard.profile.request_id,l_ps_rec.request_id),
555: program_application_id = NVL(arp_standard.profile.program_application_id,
556: l_ps_rec.program_application_id ),
557: program_id = NVL(arp_standard.profile.program_id, l_ps_rec.program_id),
558: program_update_date = DECODE(arp_standard.profile.program_id,
559: NULL, l_ps_rec.program_update_date,SYSDATE),
560: due_date = NVL(NVL(p_maturity_date, l_ps_rec.due_date),due_date)
561: where

Line 558: program_update_date = DECODE(arp_standard.profile.program_id,

554: request_id = NVL(arp_standard.profile.request_id,l_ps_rec.request_id),
555: program_application_id = NVL(arp_standard.profile.program_application_id,
556: l_ps_rec.program_application_id ),
557: program_id = NVL(arp_standard.profile.program_id, l_ps_rec.program_id),
558: program_update_date = DECODE(arp_standard.profile.program_id,
559: NULL, l_ps_rec.program_update_date,SYSDATE),
560: due_date = NVL(NVL(p_maturity_date, l_ps_rec.due_date),due_date)
561: where
562: payment_schedule_id = l_ps_rec.payment_schedule_id;