DBA Data[Home] [Help]

APPS.ARP_ARXVASUM dependencies on GL_PERIOD_STATUSES

Line 8: p_start_date IN gl_period_statuses.start_date%TYPE,

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,
12: p_dm_count IN OUT NOCOPY NUMBER,

Line 9: p_end_date IN gl_period_statuses.end_date%TYPE,

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,
12: p_dm_count IN OUT NOCOPY NUMBER,
13: p_cb_count IN OUT NOCOPY NUMBER,

Line 448: p_start_date IN gl_period_statuses.start_date%TYPE,

444: p_payments_late_amount IN OUT NOCOPY NUMBER,
445: p_payments_ontime_amount IN OUT NOCOPY NUMBER,
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,

Line 449: p_end_date IN gl_period_statuses.end_date%TYPE,

445: p_payments_ontime_amount IN OUT NOCOPY NUMBER,
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,

Line 516: p_start_date IN gl_period_statuses.start_date%TYPE,

512: procedure get_nsf_stop(
513: p_nsf_stop_amount IN OUT NOCOPY NUMBER,
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,

Line 517: p_end_date IN gl_period_statuses.end_date%TYPE,

513: p_nsf_stop_amount IN OUT NOCOPY NUMBER,
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,

Line 565: p_start_date IN gl_period_statuses.start_date%TYPE,

561: procedure get_adjustments(
562: p_adjustment_amount IN OUT NOCOPY NUMBER,
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,

Line 566: p_end_date IN gl_period_statuses.end_date%TYPE,

562: p_adjustment_amount IN OUT NOCOPY NUMBER,
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,

Line 619: p_start_date IN gl_period_statuses.start_date%TYPE,

615: procedure get_financecharg(
616: p_financecharg_amount IN OUT NOCOPY NUMBER,
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,

Line 620: p_end_date IN gl_period_statuses.end_date%TYPE,

616: p_financecharg_amount IN OUT NOCOPY NUMBER,
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,

Line 675: p_start_date IN gl_period_statuses.start_date%TYPE,

671: p_earned_func_disc IN OUT NOCOPY NUMBER,
672: p_unearned_func_disc IN OUT NOCOPY NUMBER,
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,

Line 676: p_end_date IN gl_period_statuses.end_date%TYPE,

672: p_unearned_func_disc IN OUT NOCOPY NUMBER,
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,

Line 751: p_start_date IN gl_period_statuses.start_date%TYPE,

747: procedure get_pending_confirmation(
748: p_pend_confirm_amt IN OUT NOCOPY NUMBER,
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,

Line 752: p_end_date IN gl_period_statuses.end_date%TYPE,

748: p_pend_confirm_amt IN OUT NOCOPY NUMBER,
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,

Line 816: p_start_date IN gl_period_statuses.start_date%TYPE,

812: p_other_func_ori_amt IN OUT NOCOPY NUMBER,
813: p_other_rem_amt IN OUT NOCOPY NUMBER,
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,

Line 817: p_end_date IN gl_period_statuses.end_date%TYPE,

813: p_other_rem_amt IN OUT NOCOPY NUMBER,
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,

Line 963: p_start_date IN gl_period_statuses.start_date%TYPE,

959: p_factored_func_ori_amt IN OUT NOCOPY NUMBER,
960: p_factored_rem_amt IN OUT NOCOPY NUMBER,
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,

Line 964: p_end_date IN gl_period_statuses.end_date%TYPE,

960: p_factored_rem_amt IN OUT NOCOPY NUMBER,
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,

Line 1084: p_start_date IN gl_period_statuses.start_date%TYPE,

1080:
1081: procedure get_protested_BR(p_BR_protested_amt IN OUT NOCOPY NUMBER,
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,

Line 1085: p_end_date IN gl_period_statuses.end_date%TYPE,

1081: procedure get_protested_BR(p_BR_protested_amt IN OUT NOCOPY NUMBER,
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,

Line 1142: p_start_date IN gl_period_statuses.start_date%TYPE,

1138:
1139: procedure get_unpaid_BR(p_BR_unpaid_amt IN OUT NOCOPY NUMBER,
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,

Line 1143: p_end_date IN gl_period_statuses.end_date%TYPE,

1139: procedure get_unpaid_BR(p_BR_unpaid_amt IN OUT NOCOPY NUMBER,
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,

Line 1201: p_start_date IN gl_period_statuses.start_date%TYPE,

1197:
1198: procedure get_pend_acceptance_BR(p_BR_pend_acceptance_amt IN OUT NOCOPY NUMBER,
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,

Line 1202: p_end_date IN gl_period_statuses.end_date%TYPE,

1198: procedure get_pend_acceptance_BR(p_BR_pend_acceptance_amt IN OUT NOCOPY NUMBER,
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,