APPS.ARP_ARXVASUM2 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 448: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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

Line 515: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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

Line 563: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

559: p_adjustment_count IN OUT NOCOPY NUMBER,
560: p_start_date IN gl_period_statuses.start_date%TYPE,
561: p_end_date IN gl_period_statuses.end_date%TYPE,
562: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
563: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
564: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
565: p_func_curr IN VARCHAR2,
566: p_exc_rate IN NUMBER,
567: p_precision IN NUMBER,

Line 616: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

612: p_financecharg_count IN OUT NOCOPY NUMBER,
613: p_start_date IN gl_period_statuses.start_date%TYPE,
614: p_end_date IN gl_period_statuses.end_date%TYPE,
615: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
616: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
617: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
618: p_func_curr IN VARCHAR2,
619: p_exc_rate IN NUMBER,
620: p_precision IN NUMBER,

Line 671: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

667: p_unearned_disc_count IN OUT NOCOPY NUMBER,
668: p_start_date IN gl_period_statuses.start_date%TYPE,
669: p_end_date IN gl_period_statuses.end_date%TYPE,
670: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
671: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
672: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
673: p_func_curr IN VARCHAR2,
674: p_exc_rate IN NUMBER,
675: p_precision IN NUMBER,

Line 746: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

742: p_pend_confirm_count IN OUT NOCOPY NUMBER,
743: p_start_date IN gl_period_statuses.start_date%TYPE,
744: p_end_date IN gl_period_statuses.end_date%TYPE,
745: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
746: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
747: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
748: p_func_curr IN VARCHAR2,
749: p_exc_rate IN NUMBER,
750: p_precision IN NUMBER,

Line 810: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

806: p_other_count IN OUT NOCOPY NUMBER,
807: p_start_date IN gl_period_statuses.start_date%TYPE,
808: p_end_date IN gl_period_statuses.end_date%TYPE,
809: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
810: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
811: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
812: p_func_curr IN VARCHAR2,
813: p_exc_rate IN NUMBER,
814: p_precision IN NUMBER,

Line 956: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

952: p_factored_count IN OUT NOCOPY NUMBER,
953: p_start_date IN gl_period_statuses.start_date%TYPE,
954: p_end_date IN gl_period_statuses.end_date%TYPE,
955: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
956: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
957: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
958: p_func_curr IN VARCHAR2,
959: p_exc_rate IN NUMBER,
960: p_precision IN NUMBER,

Line 1076: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

1072: p_BR_protested_count IN OUT NOCOPY NUMBER,
1073: p_start_date IN gl_period_statuses.start_date%TYPE,
1074: p_end_date IN gl_period_statuses.end_date%TYPE,
1075: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1076: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1077: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
1078: p_func_curr IN VARCHAR2,
1079: p_exc_rate IN NUMBER,
1080: p_precision IN NUMBER,

Line 1133: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

1129: p_BR_unpaid_count IN OUT NOCOPY NUMBER,
1130: p_start_date IN gl_period_statuses.start_date%TYPE,
1131: p_end_date IN gl_period_statuses.end_date%TYPE,
1132: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1133: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1134: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
1135: p_func_curr IN VARCHAR2,
1136: p_exc_rate IN NUMBER,
1137: p_precision IN NUMBER,

Line 1191: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

1187: p_BR_pend_acceptance_count IN OUT NOCOPY NUMBER,
1188: p_start_date IN gl_period_statuses.start_date%TYPE,
1189: p_end_date IN gl_period_statuses.end_date%TYPE,
1190: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1191: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1192: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
1193: p_func_curr IN VARCHAR2,
1194: p_exc_rate IN NUMBER,
1195: p_precision IN NUMBER,