[Home] [Help]
25: IF p_trx_number IS NOT NULL THEN
26: BEGIN
27: SELECT customer_trx_id
28: INTO p_customer_trx_id
29: FROM ra_customer_trx
30: WHERE trx_number = p_trx_number;
31: EXCEPTION
32: WHEN no_data_found THEN
33: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_NUM_INVALID');
88: IF p_inv_line_number IS NOT NULL THEN
89: BEGIN
90: SELECT customer_trx_line_id
91: INTO p_inv_customer_trx_line_id
92: FROM ra_customer_trx_lines
93: WHERE customer_trx_id = p_inv_customer_trx_id
94: AND line_number = p_inv_line_number
95: AND line_type = 'LINE';
96: EXCEPTION
105: IF p_inv_customer_trx_line_id IS NOT NULL THEN
106: BEGIN
107: SELECT customer_trx_id
108: INTO p_inv_customer_trx_id
109: FROM ra_customer_trx_lines
110: WHERE customer_trx_line_id = p_inv_customer_trx_line_id
111: AND line_type = 'LINE';
112: EXCEPTION
113: WHEN no_data_found THEN
128: END default_customer_trx_line_id;
129:
130:
131: PROCEDURE default_cm_info(
132: p_cm_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
133: p_cm_gl_date OUT NOCOPY DATE,
134: p_cm_amount_rem OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
135: p_cm_trx_date OUT NOCOPY DATE,
136: p_cm_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE ,
134: p_cm_amount_rem OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
135: p_cm_trx_date OUT NOCOPY DATE,
136: p_cm_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE ,
137: p_cm_currency_code OUT NOCOPY fnd_currencies.currency_code%TYPE,
138: p_cm_customer_id OUT NOCOPY ra_customer_trx.paying_customer_id%TYPE,
139: p_return_status OUT NOCOPY VARCHAR2
140: ) IS
141:
142: BEGIN
161: p_cm_gl_date,
162: p_cm_amount_rem,
163: p_cm_customer_id,
164: p_cm_currency_code
165: FROM ra_customer_trx cm,
166: ar_payment_schedules ps
167: WHERE ps.customer_trx_id = cm.customer_trx_id
168: AND cm.customer_trx_id = p_cm_customer_trx_id;
169:
193:
194:
195:
196: PROCEDURE default_trx_info(
197: p_inv_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
198: p_inv_customer_trx_line_id IN NUMBER,
199: p_show_closed_invoices IN VARCHAR2,
200: p_cm_gl_date IN DATE,
201: p_cm_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
197: p_inv_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
198: p_inv_customer_trx_line_id IN NUMBER,
199: p_show_closed_invoices IN VARCHAR2,
200: p_cm_gl_date IN DATE,
201: p_cm_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
202: p_cm_currency_code IN fnd_currencies.currency_code%TYPE,
203: p_cm_ps_id IN NUMBER,
204: p_cm_trx_date IN DATE,
205: p_inv_customer_id OUT NOCOPY NUMBER, --customer on transaction
202: p_cm_currency_code IN fnd_currencies.currency_code%TYPE,
203: p_cm_ps_id IN NUMBER,
204: p_cm_trx_date IN DATE,
205: p_inv_customer_id OUT NOCOPY NUMBER, --customer on transaction
206: p_inv_cust_trx_type_id OUT NOCOPY ra_customer_trx.cust_trx_type_id%TYPE ,
207: p_inv_due_date OUT NOCOPY DATE,
208: p_inv_trx_date OUT NOCOPY DATE,
209: p_inv_gl_date OUT NOCOPY DATE,
210: p_allow_overappln_flag OUT NOCOPY VARCHAR2,
577: IF p_installment IS NOT NULL THEN
578: BEGIN
579: SELECT ps.payment_schedule_id
580: INTO l_inv_ps_id
581: FROM ra_customer_trx ct,
582: ar_payment_schedules ps
583: WHERE ct.customer_trx_id = p_inv_customer_trx_id
584: AND ct.customer_trx_id = ps.customer_trx_id
585: --AND ps.class IN ('CB','CM','DEP','DM','INV','BR')
603: --has only one installment, get the ps_id for that installment
604: BEGIN
605: SELECT ps.payment_schedule_id
606: INTO l_inv_ps_id
607: FROM ra_customer_trx ct,
608: ar_payment_schedules ps
609: WHERE ct.customer_trx_id = p_inv_customer_trx_id
610: AND ct.customer_trx_id = ps.customer_trx_id
611: --AND ps.class IN ('CB','CM','DEP','DM','INV','BR')
703: THEN
704: SELECT receivable_application_id, gl_date
705: INTO p_receivable_application_id, p_apply_gl_date
706: FROM ar_receivable_applications ra
707: WHERE ra.customer_trx_id = p_cm_customer_trx_id
708: AND ra.applied_payment_schedule_id = p_applied_payment_schedule_id
709: AND ra.display = 'Y'
710: AND ra.status = 'APP'
711: AND ra.application_type = 'CM';