[Home] [Help]
2: /* $Header: ARCESU2B.pls 120.2 2005/10/30 04:14:07 appldev noship $ */
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,
443: p_payments_late_func_amt IN OUT NOCOPY NUMBER,
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,
510: p_nsf_stop_func_amt IN OUT NOCOPY NUMBER,
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,
558: p_adjustment_func_amt IN OUT NOCOPY NUMBER,
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,
611: p_financecharg_func_amt IN OUT NOCOPY NUMBER,
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,
666: p_earned_disc_count IN OUT NOCOPY NUMBER,
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,
741: p_pend_confirm_func_amt IN OUT NOCOPY NUMBER,
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,
805: p_other_func_rem_amt IN OUT NOCOPY NUMBER,
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,
951: p_factored_func_rem_amt IN OUT NOCOPY NUMBER,
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,
1071: p_BR_protested_func_amt IN OUT NOCOPY NUMBER,
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,
1128: p_BR_unpaid_func_amt IN OUT NOCOPY NUMBER,
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,
1186: p_BR_pend_acceptance_func_amt IN OUT NOCOPY NUMBER,
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,