APPS.AR_AUTOREM_API dependencies on FND_DATE

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

191: END IF;
192: TOTAL_WORKERS := NVL(p_total_workers, 0);
193: WORKER_NUMBER := NVL(p_worker_number, 0);
194:
195: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
196: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
197: l_create_flag := p_create_flag;
198: l_approve_flag := p_approve_flag;
199: l_format_flag := p_format_flag;

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

192: TOTAL_WORKERS := NVL(p_total_workers, 0);
193: WORKER_NUMBER := NVL(p_worker_number, 0);
194:
195: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
196: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
197: l_create_flag := p_create_flag;
198: l_approve_flag := p_approve_flag;
199: l_format_flag := p_format_flag;
200: l_currency_code := p_batch_currency;

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

399: p_customer_name_l=> p_customer_name_l,
400: p_customer_name_h=> p_customer_name_h,
401: p_doc_num_l=> p_doc_num_l,
402: p_doc_num_h=> p_doc_num_h,
403: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
404: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
405: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
406: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
407: p_trx_num_l=> p_trx_num_l,

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

400: p_customer_name_h=> p_customer_name_h,
401: p_doc_num_l=> p_doc_num_l,
402: p_doc_num_h=> p_doc_num_h,
403: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
404: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
405: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
406: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
407: p_trx_num_l=> p_trx_num_l,
408: p_trx_num_h=> p_trx_num_h,

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

401: p_doc_num_l=> p_doc_num_l,
402: p_doc_num_h=> p_doc_num_h,
403: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
404: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
405: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
406: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
407: p_trx_num_l=> p_trx_num_l,
408: p_trx_num_h=> p_trx_num_h,
409: p_remittance_total_to=> p_remittance_total_to,

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

402: p_doc_num_h=> p_doc_num_h,
403: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
404: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
405: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
406: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
407: p_trx_num_l=> p_trx_num_l,
408: p_trx_num_h=> p_trx_num_h,
409: p_remittance_total_to=> p_remittance_total_to,
410: p_remittance_total_from=> p_remittance_total_from,

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

473: p_customer_name_l=> p_customer_name_l,
474: p_customer_name_h=> p_customer_name_h,
475: p_doc_num_l=> p_doc_num_l,
476: p_doc_num_h=> p_doc_num_h,
477: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
478: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
479: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
480: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
481: p_trx_num_l=> p_trx_num_l,

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

474: p_customer_name_h=> p_customer_name_h,
475: p_doc_num_l=> p_doc_num_l,
476: p_doc_num_h=> p_doc_num_h,
477: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
478: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
479: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
480: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
481: p_trx_num_l=> p_trx_num_l,
482: p_trx_num_h=> p_trx_num_h,

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

475: p_doc_num_l=> p_doc_num_l,
476: p_doc_num_h=> p_doc_num_h,
477: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
478: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
479: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
480: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
481: p_trx_num_l=> p_trx_num_l,
482: p_trx_num_h=> p_trx_num_h,
483: p_remittance_total_to=> p_remittance_total_to,

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

476: p_doc_num_h=> p_doc_num_h,
477: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
478: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
479: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
480: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
481: p_trx_num_l=> p_trx_num_l,
482: p_trx_num_h=> p_trx_num_h,
483: p_remittance_total_to=> p_remittance_total_to,
484: p_remittance_total_from=> p_remittance_total_from,

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

565: p_customer_name_l=> p_customer_name_l,
566: p_customer_name_h=> p_customer_name_h,
567: p_doc_num_l=> p_doc_num_l,
568: p_doc_num_h=> p_doc_num_h,
569: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
570: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
571: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
572: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
573: p_trx_num_l=> p_trx_num_l,

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

566: p_customer_name_h=> p_customer_name_h,
567: p_doc_num_l=> p_doc_num_l,
568: p_doc_num_h=> p_doc_num_h,
569: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
570: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
571: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
572: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
573: p_trx_num_l=> p_trx_num_l,
574: p_trx_num_h=> p_trx_num_h,

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

567: p_doc_num_l=> p_doc_num_l,
568: p_doc_num_h=> p_doc_num_h,
569: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
570: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
571: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
572: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
573: p_trx_num_l=> p_trx_num_l,
574: p_trx_num_h=> p_trx_num_h,
575: p_remittance_total_to=> p_remittance_total_to,

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

568: p_doc_num_h=> p_doc_num_h,
569: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
570: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
571: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
572: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
573: p_trx_num_l=> p_trx_num_l,
574: p_trx_num_h=> p_trx_num_h,
575: p_remittance_total_to=> p_remittance_total_to,
576: p_remittance_total_from=> p_remittance_total_from,

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

622: p_customer_name_l=> p_customer_name_l,
623: p_customer_name_h=> p_customer_name_h,
624: p_doc_num_l=> p_doc_num_l,
625: p_doc_num_h=> p_doc_num_h,
626: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
627: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
628: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
629: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
630: p_trx_num_l=> p_trx_num_l,

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

623: p_customer_name_h=> p_customer_name_h,
624: p_doc_num_l=> p_doc_num_l,
625: p_doc_num_h=> p_doc_num_h,
626: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
627: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
628: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
629: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
630: p_trx_num_l=> p_trx_num_l,
631: p_trx_num_h=> p_trx_num_h,

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

624: p_doc_num_l=> p_doc_num_l,
625: p_doc_num_h=> p_doc_num_h,
626: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
627: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
628: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
629: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
630: p_trx_num_l=> p_trx_num_l,
631: p_trx_num_h=> p_trx_num_h,
632: p_remittance_total_to=> p_remittance_total_to,

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

625: p_doc_num_h=> p_doc_num_h,
626: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
627: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
628: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
629: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
630: p_trx_num_l=> p_trx_num_l,
631: p_trx_num_h=> p_trx_num_h,
632: p_remittance_total_to=> p_remittance_total_to,
633: p_remittance_total_from=> p_remittance_total_from,

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

1096: pg_execution_from := 'PARALLEL';
1097:
1098: fnd_file.put_line( FND_FILE.LOG, 'submit_autorem_parallel()+');
1099:
1100: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
1101: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
1102: l_create_flag := p_create_flag;
1103: l_approve_flag := p_approve_flag;
1104: l_format_flag := p_format_flag;

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

1097:
1098: fnd_file.put_line( FND_FILE.LOG, 'submit_autorem_parallel()+');
1099:
1100: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
1101: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
1102: l_create_flag := p_create_flag;
1103: l_approve_flag := p_approve_flag;
1104: l_format_flag := p_format_flag;
1105: l_currency_code := p_batch_currency;

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

1185: p_customer_name_l=> p_customer_name_l,
1186: p_customer_name_h=> p_customer_name_h,
1187: p_doc_num_l=> p_doc_num_l,
1188: p_doc_num_h=> p_doc_num_h,
1189: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
1190: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
1191: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
1192: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
1193: p_trx_num_l=> p_trx_num_l,

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

1186: p_customer_name_h=> p_customer_name_h,
1187: p_doc_num_l=> p_doc_num_l,
1188: p_doc_num_h=> p_doc_num_h,
1189: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
1190: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
1191: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
1192: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
1193: p_trx_num_l=> p_trx_num_l,
1194: p_trx_num_h=> p_trx_num_h,

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

1187: p_doc_num_l=> p_doc_num_l,
1188: p_doc_num_h=> p_doc_num_h,
1189: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
1190: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
1191: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
1192: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
1193: p_trx_num_l=> p_trx_num_l,
1194: p_trx_num_h=> p_trx_num_h,
1195: p_remittance_total_to=> p_remittance_total_to,

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

1188: p_doc_num_h=> p_doc_num_h,
1189: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
1190: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
1191: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
1192: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
1193: p_trx_num_l=> p_trx_num_l,
1194: p_trx_num_h=> p_trx_num_h,
1195: p_remittance_total_to=> p_remittance_total_to,
1196: p_remittance_total_from=> p_remittance_total_from,

Line 1598: and nvl(ba.inactive_date , fnd_date.canonical_to_date(p_batch_date) + 1 ) > fnd_date.canonical_to_date(p_batch_date)

1594: and rma.bank_account_id = ba.bank_account_id
1595: and ( ba.currency_code = p_currency_code
1596: or ba.receipt_multi_currency_flag = 'Y' )
1597: and ba.set_of_books_id = asp.set_of_books_id
1598: and nvl(ba.inactive_date , fnd_date.canonical_to_date(p_batch_date) + 1 ) > fnd_date.canonical_to_date(p_batch_date)
1599: and fnd_date.canonical_to_date(p_batch_date)
1600: between rma.start_date
1601: and nvl(rma.end_date,fnd_date.canonical_to_date(p_batch_date))
1602: and ( bb.bank_branch_id = ba.bank_branch_id

Line 1599: and fnd_date.canonical_to_date(p_batch_date)

1595: and ( ba.currency_code = p_currency_code
1596: or ba.receipt_multi_currency_flag = 'Y' )
1597: and ba.set_of_books_id = asp.set_of_books_id
1598: and nvl(ba.inactive_date , fnd_date.canonical_to_date(p_batch_date) + 1 ) > fnd_date.canonical_to_date(p_batch_date)
1599: and fnd_date.canonical_to_date(p_batch_date)
1600: between rma.start_date
1601: and nvl(rma.end_date,fnd_date.canonical_to_date(p_batch_date))
1602: and ( bb.bank_branch_id = ba.bank_branch_id
1603: or ( bb.institution_type = 'CLEARING HOUSE'

Line 1601: and nvl(rma.end_date,fnd_date.canonical_to_date(p_batch_date))

1597: and ba.set_of_books_id = asp.set_of_books_id
1598: and nvl(ba.inactive_date , fnd_date.canonical_to_date(p_batch_date) + 1 ) > fnd_date.canonical_to_date(p_batch_date)
1599: and fnd_date.canonical_to_date(p_batch_date)
1600: between rma.start_date
1601: and nvl(rma.end_date,fnd_date.canonical_to_date(p_batch_date))
1602: and ( bb.bank_branch_id = ba.bank_branch_id
1603: or ( bb.institution_type = 'CLEARING HOUSE'
1604: and exists
1605: ( select 1