DBA Data[Home] [Help]

APPS.ARP_ARXVASUM dependencies on AR_PAYMENT_SCHEDULES

Line 9: ar_payment_schedules.invoice_currency_code%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,
12: p_cb_count IN OUT NOCOPY NUMBER,
13: p_dep_count IN OUT NOCOPY NUMBER,

Line 59: p_status IN ar_payment_schedules.status%TYPE,

55: p_func_curr IN VARCHAR2,
56: p_exc_rate IN NUMBER,
57: p_precision IN NUMBER,
58: p_min_acc_unit IN NUMBER,
59: p_status IN ar_payment_schedules.status%TYPE,
60: p_incl_rct_spmenu IN VARCHAR2
61: );
62:
63: procedure get_payments_ontime(

Line 74: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

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,
76: p_exc_rate IN NUMBER,
77: p_precision IN NUMBER,
78: p_min_acc_unit IN NUMBER,

Line 79: p_status IN ar_payment_schedules.status%TYPE

75: p_func_curr IN VARCHAR2,
76: p_exc_rate IN NUMBER,
77: p_precision IN NUMBER,
78: p_min_acc_unit IN NUMBER,
79: p_status IN ar_payment_schedules.status%TYPE
80: );
81:
82:
83:

Line 94: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

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,
96: p_exc_rate IN NUMBER,
97: p_precision IN NUMBER,
98: p_min_acc_unit NUMBER,

Line 99: p_status IN ar_payment_schedules.status%TYPE

95: p_func_curr IN VARCHAR2,
96: p_exc_rate IN NUMBER,
97: p_precision IN NUMBER,
98: p_min_acc_unit NUMBER,
99: p_status IN ar_payment_schedules.status%TYPE
100: ) ;
101:
102:
103:

Line 112: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

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,
114: p_exc_rate IN NUMBER,
115: p_precision IN NUMBER,
116: p_min_acc_unit IN NUMBER,

Line 117: p_status IN ar_payment_schedules.status%TYPE

113: p_func_curr IN VARCHAR2,
114: p_exc_rate IN NUMBER,
115: p_precision IN NUMBER,
116: p_min_acc_unit IN NUMBER,
117: p_status IN ar_payment_schedules.status%TYPE
118: );
119:
120:
121: procedure get_financecharg(

Line 129: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

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,
131: p_exc_rate IN NUMBER,
132: p_precision IN NUMBER,
133: p_min_acc_unit IN NUMBER,

Line 134: p_status IN ar_payment_schedules.status%TYPE

130: p_func_curr IN VARCHAR2,
131: p_exc_rate IN NUMBER,
132: p_precision IN NUMBER,
133: p_min_acc_unit IN NUMBER,
134: p_status IN ar_payment_schedules.status%TYPE
135: ) ;
136:
137:
138: procedure get_discounts(

Line 149: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

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,
151: p_exc_rate IN NUMBER,
152: p_precision IN NUMBER,
153: p_min_acc_unit IN NUMBER,

Line 154: p_status IN ar_payment_schedules.status%TYPE

150: p_func_curr IN VARCHAR2,
151: p_exc_rate IN NUMBER,
152: p_precision IN NUMBER,
153: p_min_acc_unit IN NUMBER,
154: p_status IN ar_payment_schedules.status%TYPE
155: );
156:
157:
158: procedure get_pending_confirmation(

Line 166: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

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,
168: p_exc_rate IN NUMBER,
169: p_precision IN NUMBER,
170: p_min_acc_unit IN NUMBER,

Line 171: p_status IN ar_payment_schedules.status%TYPE

167: p_func_curr IN VARCHAR2,
168: p_exc_rate IN NUMBER,
169: p_precision IN NUMBER,
170: p_min_acc_unit IN NUMBER,
171: p_status IN ar_payment_schedules.status%TYPE
172: );
173:
174:
175: procedure get_pending_remit(

Line 194: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

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,
196: p_exc_rate IN NUMBER,
197: p_precision IN NUMBER,
198: p_min_acc_unit IN NUMBER,

Line 199: p_status IN ar_payment_schedules.status%TYPE,

195: p_func_curr IN VARCHAR2,
196: p_exc_rate IN NUMBER,
197: p_precision IN NUMBER,
198: p_min_acc_unit IN NUMBER,
199: p_status IN ar_payment_schedules.status%TYPE,
200: p_incl_rct_spmenu IN VARCHAR2
201: );
202:
203:

Line 219: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

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,
221: p_exc_rate IN NUMBER,
222: p_precision IN NUMBER,
223: p_min_acc_unit IN NUMBER,

Line 224: p_status IN ar_payment_schedules.status%TYPE,

220: p_func_curr IN VARCHAR2,
221: p_exc_rate IN NUMBER,
222: p_precision IN NUMBER,
223: p_min_acc_unit IN NUMBER,
224: p_status IN ar_payment_schedules.status%TYPE,
225: p_incl_rct_spmenu IN VARCHAR2
226: );
227:
228: procedure get_protested_BR(p_BR_protested_amt IN OUT NOCOPY NUMBER,

Line 235: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

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,
237: p_exc_rate IN NUMBER,
238: p_precision IN NUMBER,
239: p_min_acc_unit IN NUMBER,

Line 240: p_status IN ar_payment_schedules.status%TYPE);

236: p_func_curr IN VARCHAR2,
237: p_exc_rate IN NUMBER,
238: p_precision IN NUMBER,
239: p_min_acc_unit IN NUMBER,
240: p_status IN ar_payment_schedules.status%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,

Line 249: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

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,
251: p_exc_rate IN NUMBER,
252: p_precision IN NUMBER,
253: p_min_acc_unit IN NUMBER,

Line 254: p_status IN ar_payment_schedules.status%TYPE);

250: p_func_curr IN VARCHAR2,
251: p_exc_rate IN NUMBER,
252: p_precision IN NUMBER,
253: p_min_acc_unit IN NUMBER,
254: p_status IN ar_payment_schedules.status%TYPE);
255:
256: End;