DBA Data[Home] [Help]

APPS.ARP_ARXVASUM2 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 445: p_start_date IN gl_period_statuses.start_date%TYPE,

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

Line 446: p_end_date IN gl_period_statuses.end_date%TYPE,

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

Line 512: p_start_date IN gl_period_statuses.start_date%TYPE,

508: procedure get_nsf_stop(
509: p_nsf_stop_amount IN OUT NOCOPY 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,

Line 513: p_end_date IN gl_period_statuses.end_date%TYPE,

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

Line 560: p_start_date IN gl_period_statuses.start_date%TYPE,

556: procedure get_adjustments(
557: p_adjustment_amount IN OUT NOCOPY 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,

Line 561: p_end_date IN gl_period_statuses.end_date%TYPE,

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

Line 613: p_start_date IN gl_period_statuses.start_date%TYPE,

609: procedure get_financecharg(
610: p_financecharg_amount IN OUT NOCOPY 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,

Line 614: p_end_date IN gl_period_statuses.end_date%TYPE,

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

Line 668: p_start_date IN gl_period_statuses.start_date%TYPE,

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

Line 669: p_end_date IN gl_period_statuses.end_date%TYPE,

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

Line 743: p_start_date IN gl_period_statuses.start_date%TYPE,

739: procedure get_pending_confirmation(
740: p_pend_confirm_amt IN OUT NOCOPY 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,

Line 744: p_end_date IN gl_period_statuses.end_date%TYPE,

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

Line 807: p_start_date IN gl_period_statuses.start_date%TYPE,

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

Line 808: p_end_date IN gl_period_statuses.end_date%TYPE,

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

Line 953: p_start_date IN gl_period_statuses.start_date%TYPE,

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

Line 954: p_end_date IN gl_period_statuses.end_date%TYPE,

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

Line 1073: p_start_date IN gl_period_statuses.start_date%TYPE,

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

Line 1074: p_end_date IN gl_period_statuses.end_date%TYPE,

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

Line 1130: p_start_date IN gl_period_statuses.start_date%TYPE,

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

Line 1131: p_end_date IN gl_period_statuses.end_date%TYPE,

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

Line 1188: p_start_date IN gl_period_statuses.start_date%TYPE,

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

Line 1189: p_end_date IN gl_period_statuses.end_date%TYPE,

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