DBA Data[Home] [Help]

APPS.ARP_PS_PKG dependencies on AR_PAYMENT_SCHEDULES_S

Line 241: SELECT ar_payment_schedules_s.nextval

237: IF PG_DEBUG in ('Y', 'C') THEN
238: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.insert_p()+');
239: END IF;
240:
241: SELECT ar_payment_schedules_s.nextval
242: INTO l_ps_id
243: FROM dual;
244:
245: p_ps_rec.created_by := FND_GLOBAL.user_id;

Line 633: UPDATE ar_payment_schedules SET

629: l_last_update_login);
630: END IF;
631: END IF;--IF get_existing_ps%ROWCOUNT>0 THEN
632: CLOSE get_existing_ps;
633: UPDATE ar_payment_schedules SET
634: acctd_amount_due_remaining =
635: DECODE( p_ps_rec.acctd_amount_due_remaining,
636: AR_NUMBER_DUMMY, acctd_amount_due_remaining,
637: p_ps_rec.acctd_amount_due_remaining ),

Line 1125: UPDATE ar_payment_schedules SET

1121: l_last_update_login);
1122: END IF;
1123: END IF;--IF get_existing_ps%ROWCOUNT>0 THEN
1124: CLOSE get_existing_ps;
1125: UPDATE ar_payment_schedules SET
1126: acctd_amount_due_remaining =
1127: p_ps_rec.acctd_amount_due_remaining,
1128: amount_due_original = p_ps_rec.amount_due_original,
1129: amount_due_remaining = p_ps_rec.amount_due_remaining,