APPS.ARP_ARXVASUM dependencies on HZ_CUST_SITE_USES

Line 7: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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,
11: p_inv_count IN OUT NOCOPY NUMBER,

Line 451: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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,
455: p_precision IN NUMBER,

Line 519: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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,
523: p_precision IN NUMBER,

Line 568: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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,
572: p_precision IN NUMBER,

Line 622: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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,
626: p_precision IN NUMBER,

Line 678: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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,
682: p_precision IN NUMBER,

Line 754: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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,
758: p_precision IN NUMBER,

Line 819: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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,
823: p_precision IN NUMBER,

Line 966: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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,
970: p_precision IN NUMBER,

Line 1087: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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,
1091: p_precision IN NUMBER,

Line 1145: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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,
1149: p_precision IN NUMBER,

Line 1204: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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,
1208: p_precision IN NUMBER,