DBA Data[Home] [Help]

APPS.ARP_ARXVASUM2 dependencies on GL_PERIOD_STATUSES

Line 6: p_start_date IN gl_period_statuses.start_date%TYPE,

2: /* $Header: ARCESU2S.pls 120.2 2005/10/30 04:14:08 appldev noship $ */
3:
4: procedure get_amounts( p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
5: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
6: p_start_date IN gl_period_statuses.start_date%TYPE,
7: p_end_date IN gl_period_statuses.end_date%TYPE,
8: p_currency_code IN
9: ar_payment_schedules.invoice_currency_code%TYPE,
10: p_inv_count IN OUT NOCOPY NUMBER,

Line 7: p_end_date IN gl_period_statuses.end_date%TYPE,

3:
4: procedure get_amounts( p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
5: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
6: p_start_date IN gl_period_statuses.start_date%TYPE,
7: p_end_date IN gl_period_statuses.end_date%TYPE,
8: p_currency_code IN
9: ar_payment_schedules.invoice_currency_code%TYPE,
10: p_inv_count IN OUT NOCOPY NUMBER,
11: p_dm_count IN OUT NOCOPY NUMBER,

Line 70: p_start_date IN gl_period_statuses.start_date%TYPE,

66: p_payments_late_amount IN OUT NOCOPY NUMBER,
67: p_payments_ontime_amount IN OUT NOCOPY NUMBER,
68: p_payments_late_func_amt IN OUT NOCOPY NUMBER,
69: p_payments_ontime_func_amt IN OUT NOCOPY NUMBER,
70: p_start_date IN gl_period_statuses.start_date%TYPE,
71: p_end_date IN gl_period_statuses.end_date%TYPE,
72: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
73: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
74: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

Line 71: p_end_date IN gl_period_statuses.end_date%TYPE,

67: p_payments_ontime_amount IN OUT NOCOPY NUMBER,
68: p_payments_late_func_amt IN OUT NOCOPY NUMBER,
69: p_payments_ontime_func_amt IN OUT NOCOPY NUMBER,
70: p_start_date IN gl_period_statuses.start_date%TYPE,
71: p_end_date IN gl_period_statuses.end_date%TYPE,
72: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
73: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
74: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
75: p_func_curr IN VARCHAR2,

Line 90: p_start_date IN gl_period_statuses.start_date%TYPE,

86: procedure get_nsf_stop(
87: p_nsf_stop_amount IN OUT NOCOPY NUMBER,
88: p_nsf_stop_func_amt IN OUT NOCOPY NUMBER,
89: p_nsf_stop_count IN OUT NOCOPY NUMBER,
90: p_start_date IN gl_period_statuses.start_date%TYPE,
91: p_end_date IN gl_period_statuses.end_date%TYPE,
92: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
93: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
94: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

Line 91: p_end_date IN gl_period_statuses.end_date%TYPE,

87: p_nsf_stop_amount IN OUT NOCOPY NUMBER,
88: p_nsf_stop_func_amt IN OUT NOCOPY NUMBER,
89: p_nsf_stop_count IN OUT NOCOPY NUMBER,
90: p_start_date IN gl_period_statuses.start_date%TYPE,
91: p_end_date IN gl_period_statuses.end_date%TYPE,
92: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
93: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
94: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
95: p_func_curr IN VARCHAR2,

Line 108: p_start_date IN gl_period_statuses.start_date%TYPE,

104: procedure get_adjustments(
105: p_adjustment_amount IN OUT NOCOPY NUMBER,
106: p_adjustment_func_amt IN OUT NOCOPY NUMBER,
107: p_adjustment_count IN OUT NOCOPY NUMBER,
108: p_start_date IN gl_period_statuses.start_date%TYPE,
109: p_end_date IN gl_period_statuses.end_date%TYPE,
110: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
111: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
112: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

Line 109: p_end_date IN gl_period_statuses.end_date%TYPE,

105: p_adjustment_amount IN OUT NOCOPY NUMBER,
106: p_adjustment_func_amt IN OUT NOCOPY NUMBER,
107: p_adjustment_count IN OUT NOCOPY NUMBER,
108: p_start_date IN gl_period_statuses.start_date%TYPE,
109: p_end_date IN gl_period_statuses.end_date%TYPE,
110: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
111: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
112: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
113: p_func_curr IN VARCHAR2,

Line 125: p_start_date IN gl_period_statuses.start_date%TYPE,

121: procedure get_financecharg(
122: p_financecharg_amount IN OUT NOCOPY NUMBER,
123: p_financecharg_func_amt IN OUT NOCOPY NUMBER,
124: p_financecharg_count IN OUT NOCOPY NUMBER,
125: p_start_date IN gl_period_statuses.start_date%TYPE,
126: p_end_date IN gl_period_statuses.end_date%TYPE,
127: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
128: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
129: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

Line 126: p_end_date IN gl_period_statuses.end_date%TYPE,

122: p_financecharg_amount IN OUT NOCOPY NUMBER,
123: p_financecharg_func_amt IN OUT NOCOPY NUMBER,
124: p_financecharg_count IN OUT NOCOPY NUMBER,
125: p_start_date IN gl_period_statuses.start_date%TYPE,
126: p_end_date IN gl_period_statuses.end_date%TYPE,
127: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
128: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
129: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
130: p_func_curr IN VARCHAR2,

Line 145: p_start_date IN gl_period_statuses.start_date%TYPE,

141: p_earned_func_disc IN OUT NOCOPY NUMBER,
142: p_unearned_func_disc IN OUT NOCOPY NUMBER,
143: p_earned_disc_count IN OUT NOCOPY NUMBER,
144: p_unearned_disc_count IN OUT NOCOPY NUMBER,
145: p_start_date IN gl_period_statuses.start_date%TYPE,
146: p_end_date IN gl_period_statuses.end_date%TYPE,
147: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
148: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
149: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

Line 146: p_end_date IN gl_period_statuses.end_date%TYPE,

142: p_unearned_func_disc IN OUT NOCOPY NUMBER,
143: p_earned_disc_count IN OUT NOCOPY NUMBER,
144: p_unearned_disc_count IN OUT NOCOPY NUMBER,
145: p_start_date IN gl_period_statuses.start_date%TYPE,
146: p_end_date IN gl_period_statuses.end_date%TYPE,
147: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
148: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
149: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
150: p_func_curr IN VARCHAR2,

Line 162: p_start_date IN gl_period_statuses.start_date%TYPE,

158: procedure get_pending_confirmation(
159: p_pend_confirm_amt IN OUT NOCOPY NUMBER,
160: p_pend_confirm_func_amt IN OUT NOCOPY NUMBER,
161: p_pend_confirm_count IN OUT NOCOPY NUMBER,
162: p_start_date IN gl_period_statuses.start_date%TYPE,
163: p_end_date IN gl_period_statuses.end_date%TYPE,
164: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
165: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
166: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

Line 163: p_end_date IN gl_period_statuses.end_date%TYPE,

159: p_pend_confirm_amt IN OUT NOCOPY NUMBER,
160: p_pend_confirm_func_amt IN OUT NOCOPY NUMBER,
161: p_pend_confirm_count IN OUT NOCOPY NUMBER,
162: p_start_date IN gl_period_statuses.start_date%TYPE,
163: p_end_date IN gl_period_statuses.end_date%TYPE,
164: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
165: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
166: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
167: p_func_curr IN VARCHAR2,

Line 191: p_start_date IN gl_period_statuses.start_date%TYPE,p_end_date IN gl_period_statuses.end_date%TYPE,

187: p_other_func_ori_amt IN OUT NOCOPY NUMBER,
188: p_other_rem_amt IN OUT NOCOPY NUMBER,
189: p_other_func_rem_amt IN OUT NOCOPY NUMBER,
190: p_other_count IN OUT NOCOPY NUMBER,
191: p_start_date IN gl_period_statuses.start_date%TYPE,p_end_date IN gl_period_statuses.end_date%TYPE,
192: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
193: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
194: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
195: p_func_curr IN VARCHAR2,

Line 215: p_start_date IN gl_period_statuses.start_date%TYPE,

211: p_factored_func_ori_amt IN OUT NOCOPY NUMBER,
212: p_factored_rem_amt IN OUT NOCOPY NUMBER,
213: p_factored_func_rem_amt IN OUT NOCOPY NUMBER,
214: p_factored_count IN OUT NOCOPY NUMBER,
215: p_start_date IN gl_period_statuses.start_date%TYPE,
216: p_end_date IN gl_period_statuses.end_date%TYPE,
217: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
218: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
219: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

Line 216: p_end_date IN gl_period_statuses.end_date%TYPE,

212: p_factored_rem_amt IN OUT NOCOPY NUMBER,
213: p_factored_func_rem_amt IN OUT NOCOPY NUMBER,
214: p_factored_count IN OUT NOCOPY NUMBER,
215: p_start_date IN gl_period_statuses.start_date%TYPE,
216: p_end_date IN gl_period_statuses.end_date%TYPE,
217: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
218: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
219: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
220: p_func_curr IN VARCHAR2,

Line 231: p_start_date IN gl_period_statuses.start_date%TYPE,

227:
228: procedure get_protested_BR(p_BR_protested_amt IN OUT NOCOPY NUMBER,
229: p_BR_protested_func_amt IN OUT NOCOPY NUMBER,
230: p_BR_protested_count IN OUT NOCOPY NUMBER,
231: p_start_date IN gl_period_statuses.start_date%TYPE,
232: p_end_date IN gl_period_statuses.end_date%TYPE,
233: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
234: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
235: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

Line 232: p_end_date IN gl_period_statuses.end_date%TYPE,

228: procedure get_protested_BR(p_BR_protested_amt IN OUT NOCOPY NUMBER,
229: p_BR_protested_func_amt IN OUT NOCOPY NUMBER,
230: p_BR_protested_count IN OUT NOCOPY NUMBER,
231: p_start_date IN gl_period_statuses.start_date%TYPE,
232: p_end_date IN gl_period_statuses.end_date%TYPE,
233: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
234: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
235: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
236: p_func_curr IN VARCHAR2,

Line 245: p_start_date IN gl_period_statuses.start_date%TYPE,

241:
242: procedure get_unpaid_BR(p_BR_unpaid_amt IN OUT NOCOPY NUMBER,
243: p_BR_unpaid_func_amt IN OUT NOCOPY NUMBER,
244: p_BR_unpaid_count IN OUT NOCOPY NUMBER,
245: p_start_date IN gl_period_statuses.start_date%TYPE,
246: p_end_date IN gl_period_statuses.end_date%TYPE,
247: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
248: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
249: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

Line 246: p_end_date IN gl_period_statuses.end_date%TYPE,

242: procedure get_unpaid_BR(p_BR_unpaid_amt IN OUT NOCOPY NUMBER,
243: p_BR_unpaid_func_amt IN OUT NOCOPY NUMBER,
244: p_BR_unpaid_count IN OUT NOCOPY NUMBER,
245: p_start_date IN gl_period_statuses.start_date%TYPE,
246: p_end_date IN gl_period_statuses.end_date%TYPE,
247: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
248: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
249: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
250: p_func_curr IN VARCHAR2,