DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on FND_DATE

Line 211: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);

207: IF PG_DEBUG in ('Y','C') THEN
208: arp_standard.debug( 'converting the parameters');
209: END IF;
210:
211: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
212: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
213: l_receipt_class_id := to_number(p_receipt_class_id);
214: l_receipt_method_id := to_number(p_payment_method_id);
215: l_currency_code := p_batch_currency;

Line 212: l_batch_date := fnd_date.canonical_to_date(p_batch_date);

208: arp_standard.debug( 'converting the parameters');
209: END IF;
210:
211: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
212: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
213: l_receipt_class_id := to_number(p_receipt_class_id);
214: l_receipt_method_id := to_number(p_payment_method_id);
215: l_currency_code := p_batch_currency;
216: l_create_flag := p_create_flag;

Line 300: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),

296: arp_standard.debug( ' the error here is ' || SQLERRM );
297: END IF;
298:
299: select_valid_invoices
300: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
301: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
302: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
303: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
304: p_trx_num_l =>p_trx_num_l,

Line 301: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),

297: END IF;
298:
299: select_valid_invoices
300: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
301: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
302: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
303: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
304: p_trx_num_l =>p_trx_num_l,
305: p_trx_num_h => p_trx_num_h,

Line 302: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),

298:
299: select_valid_invoices
300: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
301: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
302: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
303: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
304: p_trx_num_l =>p_trx_num_l,
305: p_trx_num_h => p_trx_num_h,
306: p_doc_num_l =>p_doc_num_l,

Line 303: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),

299: select_valid_invoices
300: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
301: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
302: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
303: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
304: p_trx_num_l =>p_trx_num_l,
305: p_trx_num_h => p_trx_num_h,
306: p_doc_num_l =>p_doc_num_l,
307: p_doc_num_h => p_doc_num_h,

Line 370: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),

366: arp_standard.debug( ' the error here is ' || SQLERRM );
367: END IF;
368:
369: select_valid_invoices
370: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
371: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
372: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
373: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
374: p_trx_num_l =>p_trx_num_l,

Line 371: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),

367: END IF;
368:
369: select_valid_invoices
370: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
371: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
372: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
373: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
374: p_trx_num_l =>p_trx_num_l,
375: p_trx_num_h => p_trx_num_h,

Line 372: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),

368:
369: select_valid_invoices
370: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
371: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
372: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
373: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
374: p_trx_num_l =>p_trx_num_l,
375: p_trx_num_h => p_trx_num_h,
376: p_doc_num_l =>p_doc_num_l,

Line 373: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),

369: select_valid_invoices
370: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
371: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
372: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
373: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
374: p_trx_num_l =>p_trx_num_l,
375: p_trx_num_h => p_trx_num_h,
376: p_doc_num_l =>p_doc_num_l,
377: p_doc_num_h => p_doc_num_h,

Line 426: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),

422: arp_standard.debug( ' the error here is ' || SQLERRM );
423: END IF;
424:
425: select_valid_invoices
426: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
427: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
428: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
429: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
430: p_trx_num_l =>p_trx_num_l,

Line 427: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),

423: END IF;
424:
425: select_valid_invoices
426: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
427: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
428: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
429: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
430: p_trx_num_l =>p_trx_num_l,
431: p_trx_num_h => p_trx_num_h,

Line 428: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),

424:
425: select_valid_invoices
426: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
427: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
428: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
429: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
430: p_trx_num_l =>p_trx_num_l,
431: p_trx_num_h => p_trx_num_h,
432: p_doc_num_l =>p_doc_num_l,

Line 429: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),

425: select_valid_invoices
426: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
427: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
428: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
429: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
430: p_trx_num_l =>p_trx_num_l,
431: p_trx_num_h => p_trx_num_h,
432: p_doc_num_l =>p_doc_num_l,
433: p_doc_num_h => p_doc_num_h,