237: p_doc_sequence_id OUT NOCOPY NUMBER,
238: p_return_status OUT NOCOPY VARCHAR2
239: );
240: PROCEDURE Derive_cust_info_from_trx(
241: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,
242: p_trx_number IN ra_customer_trx.trx_number%TYPE,
243: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
244: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
245: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
239: );
240: PROCEDURE Derive_cust_info_from_trx(
241: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,
242: p_trx_number IN ra_customer_trx.trx_number%TYPE,
243: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
244: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
245: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
246: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
247: p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
240: PROCEDURE Derive_cust_info_from_trx(
241: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,
242: p_trx_number IN ra_customer_trx.trx_number%TYPE,
243: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
244: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
245: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
246: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
247: p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
248: p_return_status OUT NOCOPY VARCHAR2
242: p_trx_number IN ra_customer_trx.trx_number%TYPE,
243: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
244: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
245: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
246: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
247: p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
248: p_return_status OUT NOCOPY VARCHAR2
249: );
250: PROCEDURE Validate_Desc_Flexfield(