DBA Data[Home] [Help]

APPS.ARP_ARXVASUM dependencies on HZ_CUST_ACCOUNTS

Line 6: procedure get_amounts( p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

2: /* $Header: ARCESUMB.pls 120.5 2005/10/30 04:14:10 appldev ship $ */
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:
6: procedure get_amounts( p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
7: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
8: p_start_date IN gl_period_statuses.start_date%TYPE,
9: p_end_date IN gl_period_statuses.end_date%TYPE,
10: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

Line 450: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

446: p_payments_late_func_amt IN OUT NOCOPY NUMBER,
447: p_payments_ontime_func_amt IN OUT NOCOPY NUMBER,
448: p_start_date IN gl_period_statuses.start_date%TYPE,
449: p_end_date IN gl_period_statuses.end_date%TYPE,
450: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
451: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
452: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
453: p_func_curr IN VARCHAR2,
454: p_exc_rate IN NUMBER,

Line 518: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

514: p_nsf_stop_func_amt IN OUT NOCOPY NUMBER,
515: p_nsf_stop_count IN OUT NOCOPY NUMBER,
516: p_start_date IN gl_period_statuses.start_date%TYPE,
517: p_end_date IN gl_period_statuses.end_date%TYPE,
518: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
519: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
520: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
521: p_func_curr IN VARCHAR2,
522: p_exc_rate IN NUMBER,

Line 567: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

563: p_adjustment_func_amt IN OUT NOCOPY NUMBER,
564: p_adjustment_count IN OUT NOCOPY NUMBER,
565: p_start_date IN gl_period_statuses.start_date%TYPE,
566: p_end_date IN gl_period_statuses.end_date%TYPE,
567: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
568: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
569: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
570: p_func_curr IN VARCHAR2,
571: p_exc_rate IN NUMBER,

Line 621: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

617: p_financecharg_func_amt IN OUT NOCOPY NUMBER,
618: p_financecharg_count IN OUT NOCOPY NUMBER,
619: p_start_date IN gl_period_statuses.start_date%TYPE,
620: p_end_date IN gl_period_statuses.end_date%TYPE,
621: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
622: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
623: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
624: p_func_curr IN VARCHAR2,
625: p_exc_rate IN NUMBER,

Line 677: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

673: p_earned_disc_count IN OUT NOCOPY NUMBER,
674: p_unearned_disc_count IN OUT NOCOPY NUMBER,
675: p_start_date IN gl_period_statuses.start_date%TYPE,
676: p_end_date IN gl_period_statuses.end_date%TYPE,
677: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
678: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
679: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
680: p_func_curr IN VARCHAR2,
681: p_exc_rate IN NUMBER,

Line 753: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

749: p_pend_confirm_func_amt IN OUT NOCOPY NUMBER,
750: p_pend_confirm_count IN OUT NOCOPY NUMBER,
751: p_start_date IN gl_period_statuses.start_date%TYPE,
752: p_end_date IN gl_period_statuses.end_date%TYPE,
753: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
754: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
755: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
756: p_func_curr IN VARCHAR2,
757: p_exc_rate IN NUMBER,

Line 818: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

814: p_other_func_rem_amt IN OUT NOCOPY NUMBER,
815: p_other_count IN OUT NOCOPY NUMBER,
816: p_start_date IN gl_period_statuses.start_date%TYPE,
817: p_end_date IN gl_period_statuses.end_date%TYPE,
818: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
819: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
820: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
821: p_func_curr IN VARCHAR2,
822: p_exc_rate IN NUMBER,

Line 965: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

961: p_factored_func_rem_amt IN OUT NOCOPY NUMBER,
962: p_factored_count IN OUT NOCOPY NUMBER,
963: p_start_date IN gl_period_statuses.start_date%TYPE,
964: p_end_date IN gl_period_statuses.end_date%TYPE,
965: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
966: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
967: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
968: p_func_curr IN VARCHAR2,
969: p_exc_rate IN NUMBER,

Line 1086: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

1082: p_BR_protested_func_amt IN OUT NOCOPY NUMBER,
1083: p_BR_protested_count IN OUT NOCOPY NUMBER,
1084: p_start_date IN gl_period_statuses.start_date%TYPE,
1085: p_end_date IN gl_period_statuses.end_date%TYPE,
1086: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1087: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1088: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
1089: p_func_curr IN VARCHAR2,
1090: p_exc_rate IN NUMBER,

Line 1144: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

1140: p_BR_unpaid_func_amt IN OUT NOCOPY NUMBER,
1141: p_BR_unpaid_count IN OUT NOCOPY NUMBER,
1142: p_start_date IN gl_period_statuses.start_date%TYPE,
1143: p_end_date IN gl_period_statuses.end_date%TYPE,
1144: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1145: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1146: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
1147: p_func_curr IN VARCHAR2,
1148: p_exc_rate IN NUMBER,

Line 1203: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

1199: p_BR_pend_acceptance_func_amt IN OUT NOCOPY NUMBER,
1200: p_BR_pend_acceptance_count IN OUT NOCOPY NUMBER,
1201: p_start_date IN gl_period_statuses.start_date%TYPE,
1202: p_end_date IN gl_period_statuses.end_date%TYPE,
1203: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1204: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1205: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
1206: p_func_curr IN VARCHAR2,
1207: p_exc_rate IN NUMBER,