77: p_ra_rec IN ar_receivable_applications%ROWTYPE
78: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS
79: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
80: BEGIN
81: arp_standard.debug( 'arp_app_pkg.insert_p()+' );
82: arp_standard.debug(' p_ra_id = ' || p_ra_id);
83: IF p_ra_id IS NULL
84: THEN
85: SELECT ar_receivable_applications_s.nextval
78: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS
79: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
80: BEGIN
81: arp_standard.debug( 'arp_app_pkg.insert_p()+' );
82: arp_standard.debug(' p_ra_id = ' || p_ra_id);
83: IF p_ra_id IS NULL
84: THEN
85: SELECT ar_receivable_applications_s.nextval
86: INTO l_ra_id
84: THEN
85: SELECT ar_receivable_applications_s.nextval
86: INTO l_ra_id
87: FROM dual;
88: arp_standard.debug(' assigned l_ra_id = ' || l_ra_id);
89: ELSE
90: l_ra_id := p_ra_id;
91: END IF;
92:
214: p_ra_rec.application_rule,
215: p_ra_rec.application_type,
216: p_ra_rec.apply_date,
217: p_ra_rec.code_combination_id,
218: arp_standard.profile.user_id,
219: SYSDATE,
220: p_ra_rec.display,
221: TRUNC(p_ra_rec.gl_date),
222: arp_standard.profile.user_id,
218: arp_standard.profile.user_id,
219: SYSDATE,
220: p_ra_rec.display,
221: TRUNC(p_ra_rec.gl_date),
222: arp_standard.profile.user_id,
223: SYSDATE,
224: p_ra_rec.payment_schedule_id,
225: arp_global.set_of_books_id,
226: p_ra_rec.status,
237: p_ra_rec.days_late,
238: p_ra_rec.earned_discount_taken,
239: p_ra_rec.freight_applied,
240: p_ra_rec.gl_posted_date,
241: NVL( arp_standard.profile.last_update_login,
242: p_ra_rec.last_update_login ),
243: p_ra_rec.line_applied,
244: p_ra_rec.postable,
245: p_ra_rec.posting_control_id,
242: p_ra_rec.last_update_login ),
243: p_ra_rec.line_applied,
244: p_ra_rec.postable,
245: p_ra_rec.posting_control_id,
246: NVL( arp_standard.profile.program_application_id,
247: p_ra_rec.program_application_id ),
248: NVL(
249: decode(arp_standard.profile.program_id
250: ,-1,p_ra_rec.program_id)
245: p_ra_rec.posting_control_id,
246: NVL( arp_standard.profile.program_application_id,
247: p_ra_rec.program_application_id ),
248: NVL(
249: decode(arp_standard.profile.program_id
250: ,-1,p_ra_rec.program_id)
251: ,p_ra_rec.program_id),
252: DECODE( arp_standard.profile.program_id,
253: NULL, NULL, SYSDATE ),
248: NVL(
249: decode(arp_standard.profile.program_id
250: ,-1,p_ra_rec.program_id)
251: ,p_ra_rec.program_id),
252: DECODE( arp_standard.profile.program_id,
253: NULL, NULL, SYSDATE ),
254: p_ra_rec.receivables_charges_applied,
255: NVL( arp_standard.profile.request_id, p_ra_rec.request_id ),
256: p_ra_rec.tax_applied,
251: ,p_ra_rec.program_id),
252: DECODE( arp_standard.profile.program_id,
253: NULL, NULL, SYSDATE ),
254: p_ra_rec.receivables_charges_applied,
255: NVL( arp_standard.profile.request_id, p_ra_rec.request_id ),
256: p_ra_rec.tax_applied,
257: p_ra_rec.unearned_discount_taken,
258: p_ra_rec.unearned_discount_ccid,
259: p_ra_rec.earned_discount_ccid,
323: p_ra_rec.application_ref_reason,
324: p_ra_rec.customer_reference,
325: p_ra_rec.customer_reason,
326: p_ra_rec.applied_rec_app_id
327: ,arp_standard.sysparm.org_id /* SSA changes anuj */
328: ,'R12'
329: );
330: p_ra_id := l_ra_id;
331:
328: ,'R12'
329: );
330: p_ra_id := l_ra_id;
331:
332: arp_standard.debug( 'arp_app_pkg.insert_p()-' );
333: EXCEPTION
334: WHEN OTHERS THEN
335: arp_standard.debug(
336: 'EXCEPTION: arp_app_pkg.insert_p' );
331:
332: arp_standard.debug( 'arp_app_pkg.insert_p()-' );
333: EXCEPTION
334: WHEN OTHERS THEN
335: arp_standard.debug(
336: 'EXCEPTION: arp_app_pkg.insert_p' );
337: arp_standard.debug('SYSDATE = ' || SYSDATE);
338: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
333: EXCEPTION
334: WHEN OTHERS THEN
335: arp_standard.debug(
336: 'EXCEPTION: arp_app_pkg.insert_p' );
337: arp_standard.debug('SYSDATE = ' || SYSDATE);
338: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
340: p_ra_rec.last_update_login) ), '
341: arp_standard.debug('---------------------------');
334: WHEN OTHERS THEN
335: arp_standard.debug(
336: 'EXCEPTION: arp_app_pkg.insert_p' );
337: arp_standard.debug('SYSDATE = ' || SYSDATE);
338: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
340: p_ra_rec.last_update_login) ), '
341: arp_standard.debug('---------------------------');
342: arp_standard.debug('ra_id = ' || l_ra_id);
335: arp_standard.debug(
336: 'EXCEPTION: arp_app_pkg.insert_p' );
337: arp_standard.debug('SYSDATE = ' || SYSDATE);
338: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
340: p_ra_rec.last_update_login) ), '
341: arp_standard.debug('---------------------------');
342: arp_standard.debug('ra_id = ' || l_ra_id);
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
337: arp_standard.debug('SYSDATE = ' || SYSDATE);
338: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
340: p_ra_rec.last_update_login) ), '
341: arp_standard.debug('---------------------------');
342: arp_standard.debug('ra_id = ' || l_ra_id);
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
338: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
340: p_ra_rec.last_update_login) ), '
341: arp_standard.debug('---------------------------');
342: arp_standard.debug('ra_id = ' || l_ra_id);
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
340: p_ra_rec.last_update_login) ), '
341: arp_standard.debug('---------------------------');
342: arp_standard.debug('ra_id = ' || l_ra_id);
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
340: p_ra_rec.last_update_login) ), '
341: arp_standard.debug('---------------------------');
342: arp_standard.debug('ra_id = ' || l_ra_id);
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
341: arp_standard.debug('---------------------------');
342: arp_standard.debug('ra_id = ' || l_ra_id);
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
342: arp_standard.debug('ra_id = ' || l_ra_id);
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
379: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
379: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
380: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
379: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
380: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
381: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
379: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
380: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
381: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
382:
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
379: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
380: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
381: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
382:
383:
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
379: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
380: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
381: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
382:
383:
384:
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
379: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
380: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
381: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
382:
383:
384:
385: RAISE;
441: PROCEDURE update_p( p_ra_rec IN ar_receivable_applications%ROWTYPE ) IS
442: lc_dump VARCHAR2(30000);
443:
444: BEGIN
445: arp_standard.debug( 'arp_app_pkg.update_p()+' );
446:
447: UPDATE ar_receivable_applications ra SET
448: acctd_amount_applied_from =
449: p_ra_rec.acctd_amount_applied_from,
455: apply_date = p_ra_rec.apply_date,
456: code_combination_id = p_ra_rec.code_combination_id,
457: display = p_ra_rec.display,
458: gl_date = p_ra_rec.gl_date,
459: last_updated_by = arp_standard.profile.user_id,
460: last_update_date = SYSDATE,
461: payment_schedule_id = p_ra_rec.payment_schedule_id,
462: set_of_books_id = p_ra_rec.set_of_books_id,
463: status = p_ra_rec.status,
479: earned_discount_taken = p_ra_rec.earned_discount_taken,
480: freight_applied = p_ra_rec.freight_applied,
481: gl_posted_date = p_ra_rec.gl_posted_date,
482: last_update_login =
483: NVL( arp_standard.profile.last_update_login,
484: p_ra_rec.last_update_login ),
485: line_applied = p_ra_rec.line_applied,
486: postable = p_ra_rec.postable,
487: posting_control_id = p_ra_rec.posting_control_id,
485: line_applied = p_ra_rec.line_applied,
486: postable = p_ra_rec.postable,
487: posting_control_id = p_ra_rec.posting_control_id,
488: program_application_id =
489: NVL( arp_standard.profile.program_application_id,
490: p_ra_rec.program_application_id ),
491: program_id = NVL( arp_standard.profile.program_id,
492: p_ra_rec.program_id ),
493: program_update_date = DECODE( arp_standard.profile.program_id,
487: posting_control_id = p_ra_rec.posting_control_id,
488: program_application_id =
489: NVL( arp_standard.profile.program_application_id,
490: p_ra_rec.program_application_id ),
491: program_id = NVL( arp_standard.profile.program_id,
492: p_ra_rec.program_id ),
493: program_update_date = DECODE( arp_standard.profile.program_id,
494: NULL, NULL,
495: SYSDATE
489: NVL( arp_standard.profile.program_application_id,
490: p_ra_rec.program_application_id ),
491: program_id = NVL( arp_standard.profile.program_id,
492: p_ra_rec.program_id ),
493: program_update_date = DECODE( arp_standard.profile.program_id,
494: NULL, NULL,
495: SYSDATE
496: ),
497: receivables_charges_applied =
495: SYSDATE
496: ),
497: receivables_charges_applied =
498: p_ra_rec.receivables_charges_applied,
499: request_id = NVL( arp_standard.profile.request_id,
500: p_ra_rec.request_id ),
501: tax_applied = p_ra_rec.tax_applied,
502: unearned_discount_taken = p_ra_rec.unearned_discount_taken,
503: unearned_discount_ccid = p_ra_rec.unearned_discount_ccid,
573: customer_reason = p_ra_rec.customer_reason,
574: applied_rec_app_id = p_ra_rec.applied_rec_app_id
575: WHERE ra.receivable_application_id = p_ra_rec.receivable_application_id;
576:
577: arp_standard.debug('arp_app_pkg.update_p()-' );
578:
579: EXCEPTION
580: WHEN OTHERS THEN
581: arp_standard.debug( 'EXCEPTION: arp_app_pkg.update_p' );
577: arp_standard.debug('arp_app_pkg.update_p()-' );
578:
579: EXCEPTION
580: WHEN OTHERS THEN
581: arp_standard.debug( 'EXCEPTION: arp_app_pkg.update_p' );
582:
583: -- Dump all parameter values and return them to error stack
584: -- for debugging purposes.
585: lc_dump := 'DUMP of procedure parameter values:'
593: ','||' p_ra_rec.apply_date'||TO_CHAR( p_ra_rec.apply_date)||
594: ','||' p_ra_rec.code_combination_id'||TO_CHAR( p_ra_rec.code_combination_id)||
595: ','||' p_ra_rec.display'||p_ra_rec.display||
596: ','||' p_ra_rec.gl_date'||TO_CHAR( p_ra_rec.gl_date)||
597: ','||' arp_standard.profile.user_id'||TO_CHAR( arp_standard.profile.user_id)||
598: ','||' SYSDATE='||TO_CHAR( SYSDATE)||
599: ','||' p_ra_rec.payment_schedule_id='||TO_CHAR( p_ra_rec.payment_schedule_id)||
600: ','||' p_ra_rec.set_of_books_id='||TO_CHAR( p_ra_rec.set_of_books_id)||
601: ','||' p_ra_rec.status='||p_ra_rec.status||
719: +===========================================================================*/
720: PROCEDURE delete_p(
721: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
722: BEGIN
723: arp_standard.debug( 'arp_app_pkg.delete_p()+' );
724:
725: DELETE FROM ar_receivable_applications ra
726: WHERE ra.receivable_application_id = p_ra_id;
727:
736: -- p_mode => 'SINGLE',
737: -- p_key_value => p_ra_id);
738: --}
739:
740: arp_standard.debug( 'arp_app_pkg.delete_p()-' );
741: EXCEPTION
742: WHEN OTHERS THEN
743: arp_standard.debug(
744: 'EXCEPTION: arp_app_pkg.delete_p' );
739:
740: arp_standard.debug( 'arp_app_pkg.delete_p()-' );
741: EXCEPTION
742: WHEN OTHERS THEN
743: arp_standard.debug(
744: 'EXCEPTION: arp_app_pkg.delete_p' );
745: RAISE;
746: END;
747:
778:
779: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
780:
781: BEGIN
782: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()+' );
783: FOR i IN c_ra_rec LOOP
784:
785: DELETE FROM ar_receivable_applications ra
786: WHERE ra.receivable_application_id = i.receivable_application_id;
814: -- p_mode => 'BATCH',
815: -- p_key_value_list => l_ar_dist_key_value_list);
816: --}
817: END LOOP;
818: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()-' );
819: EXCEPTION
820: WHEN OTHERS THEN
821: NULL;
822: END;
846: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
847: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
848: BEGIN
849: IF PG_DEBUG in ('Y', 'C') THEN
850: arp_standard.debug( 'arp_app_pkg.lock_p()+');
851: END IF;
852:
853: SELECT ra.receivable_application_id
854: INTO l_ra_id
856: WHERE ra.receivable_application_id = p_ra_id
857: FOR UPDATE OF STATUS NOWAIT;
858:
859: IF PG_DEBUG in ('Y', 'C') THEN
860: arp_standard.debug( 'arp_app_pkg.lock_p()-');
861: END IF;
862: EXCEPTION
863: WHEN OTHERS THEN
864: IF PG_DEBUG in ('Y', 'C') THEN
861: END IF;
862: EXCEPTION
863: WHEN OTHERS THEN
864: IF PG_DEBUG in ('Y', 'C') THEN
865: arp_standard.debug( 'EXCEPTION: arp_app_pkg.lock_p' );
866: END IF;
867: RAISE;
868: END lock_p;
869:
894: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
895: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
896: BEGIN
897: IF PG_DEBUG in ('Y', 'C') THEN
898: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()+');
899: END IF;
900:
901: SELECT ra.receivable_application_id
902: INTO l_ra_id
904: WHERE ra.receivable_application_id = p_ra_id
905: FOR UPDATE OF STATUS NOWAIT;
906:
907: IF PG_DEBUG in ('Y', 'C') THEN
908: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()-');
909: END IF;
910: EXCEPTION
911: WHEN OTHERS THEN
912: IF PG_DEBUG in ('Y', 'C') THEN
909: END IF;
910: EXCEPTION
911: WHEN OTHERS THEN
912: IF PG_DEBUG in ('Y', 'C') THEN
913: arp_standard.debug( 'EXCEPTION: arp_app_pkg.nowaitlock_p' );
914: END IF;
915: RAISE;
916: END nowaitlock_p;
917:
942: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
943: p_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ) IS
944: BEGIN
945: IF PG_DEBUG in ('Y', 'C') THEN
946: arp_standard.debug( 'arp_app_pkg.fetch_p()+' );
947: END IF;
948:
949: SELECT *
950: INTO p_ra_rec
951: FROM ar_receivable_applications
952: WHERE receivable_application_id = p_ra_id;
953:
954: IF PG_DEBUG in ('Y', 'C') THEN
955: arp_standard.debug( 'arp_app_pkg.fetch_p()-' );
956: END IF;
957: EXCEPTION
958: WHEN OTHERS THEN
959: IF PG_DEBUG in ('Y', 'C') THEN
956: END IF;
957: EXCEPTION
958: WHEN OTHERS THEN
959: IF PG_DEBUG in ('Y', 'C') THEN
960: arp_standard.debug('fetch_p: ' || 'EXCEPTION: arp_app_pkg error' );
961: END IF;
962: RAISE;
963:
964: END fetch_p;