84: | using trx_type AR_APP and AR_CM. |
85: | Refer to comments in code. |
86: +===========================================================================*/
87: PROCEDURE update_reverse_actions(
88: p_app_rec IN arp_global.app_rec_type,
89: p_module_name IN VARCHAR2,
90: p_module_version IN VARCHAR2) IS
91:
92: l_ps_rec ar_payment_schedules%ROWTYPE;
124: l_ps_rec.actual_date_closed := NVL( p_app_rec.actual_date_closed,
125: l_ps_rec.actual_date_closed );
126: ELSE
127: l_ps_rec.status := 'OP';
128: l_ps_rec.gl_date_closed := ARP_GLOBAL.G_MAX_DATE;
129: l_ps_rec.actual_date_closed := ARP_GLOBAL.G_MAX_DATE;
130: END IF;
131:
132: /* Bug fix #464203
125: l_ps_rec.actual_date_closed );
126: ELSE
127: l_ps_rec.status := 'OP';
128: l_ps_rec.gl_date_closed := ARP_GLOBAL.G_MAX_DATE;
129: l_ps_rec.actual_date_closed := ARP_GLOBAL.G_MAX_DATE;
130: END IF;
131:
132: /* Bug fix #464203
133: Two values may be passed into this procedure for trx_type
547: gl_date_closed = l_ps_rec.gl_date_closed,
548: actual_date_closed = l_ps_rec.actual_date_closed ,
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,
2368: p_ps_rec.actual_date_closed := NVL( l_actual_date_closed,
2369: p_ps_rec.actual_date_closed );
2370: ELSE
2371: p_ps_rec.status := 'OP';
2372: p_ps_rec.gl_date_closed := ARP_GLOBAL.G_MAX_DATE;
2373: p_ps_rec.actual_date_closed := ARP_GLOBAL.G_MAX_DATE;
2374: END IF;
2375: --
2376: IF PG_DEBUG in ('Y', 'C') THEN
2369: p_ps_rec.actual_date_closed );
2370: ELSE
2371: p_ps_rec.status := 'OP';
2372: p_ps_rec.gl_date_closed := ARP_GLOBAL.G_MAX_DATE;
2373: p_ps_rec.actual_date_closed := ARP_GLOBAL.G_MAX_DATE;
2374: END IF;
2375: --
2376: IF PG_DEBUG in ('Y', 'C') THEN
2377: arp_debug.debug( 'arp_util.populate_closed_dates()-' );