DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on FND_DATE

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

183: END IF;
184: TOTAL_WORKERS := NVL(p_total_workers, 0);
185: WORKER_NUMBER := NVL(p_worker_number, 0);
186:
187: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
188: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
189: l_create_flag := p_create_flag;
190: l_approve_flag := p_approve_flag;
191: l_format_flag := p_format_flag;

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

184: TOTAL_WORKERS := NVL(p_total_workers, 0);
185: WORKER_NUMBER := NVL(p_worker_number, 0);
186:
187: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
188: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
189: l_create_flag := p_create_flag;
190: l_approve_flag := p_approve_flag;
191: l_format_flag := p_format_flag;
192: l_currency_code := p_batch_currency;

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

386:
387: select_update_rec(
388: p_customer_number_l=> p_customer_number_l,
389: p_customer_number_h=> p_customer_number_h,
390: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
391: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
392: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
393: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
394: p_trx_num_l=> p_trx_num_l,

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

387: select_update_rec(
388: p_customer_number_l=> p_customer_number_l,
389: p_customer_number_h=> p_customer_number_h,
390: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
391: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
392: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
393: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
394: p_trx_num_l=> p_trx_num_l,
395: p_trx_num_h=> p_trx_num_h,

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

388: p_customer_number_l=> p_customer_number_l,
389: p_customer_number_h=> p_customer_number_h,
390: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
391: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
392: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
393: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
394: p_trx_num_l=> p_trx_num_l,
395: p_trx_num_h=> p_trx_num_h,
396: p_remittance_total_to=> p_remittance_total_to,

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

389: p_customer_number_h=> p_customer_number_h,
390: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
391: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
392: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
393: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
394: p_trx_num_l=> p_trx_num_l,
395: p_trx_num_h=> p_trx_num_h,
396: p_remittance_total_to=> p_remittance_total_to,
397: p_remittance_total_from=> p_remittance_total_from,

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

455:
456: select_update_rec(
457: p_customer_number_l=> p_customer_number_l,
458: p_customer_number_h=> p_customer_number_h,
459: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
460: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
461: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
462: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
463: p_trx_num_l=> p_trx_num_l,

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

456: select_update_rec(
457: p_customer_number_l=> p_customer_number_l,
458: p_customer_number_h=> p_customer_number_h,
459: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
460: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
461: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
462: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
463: p_trx_num_l=> p_trx_num_l,
464: p_trx_num_h=> p_trx_num_h,

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

457: p_customer_number_l=> p_customer_number_l,
458: p_customer_number_h=> p_customer_number_h,
459: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
460: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
461: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
462: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
463: p_trx_num_l=> p_trx_num_l,
464: p_trx_num_h=> p_trx_num_h,
465: p_remittance_total_to=> p_remittance_total_to,

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

458: p_customer_number_h=> p_customer_number_h,
459: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
460: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
461: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
462: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
463: p_trx_num_l=> p_trx_num_l,
464: p_trx_num_h=> p_trx_num_h,
465: p_remittance_total_to=> p_remittance_total_to,
466: p_remittance_total_from=> p_remittance_total_from,

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

543:
544: select_update_rec(
545: p_customer_number_l=> p_customer_number_l,
546: p_customer_number_h=> p_customer_number_h,
547: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
548: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
549: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
550: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
551: p_trx_num_l=> p_trx_num_l,

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

544: select_update_rec(
545: p_customer_number_l=> p_customer_number_l,
546: p_customer_number_h=> p_customer_number_h,
547: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
548: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
549: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
550: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
551: p_trx_num_l=> p_trx_num_l,
552: p_trx_num_h=> p_trx_num_h,

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

545: p_customer_number_l=> p_customer_number_l,
546: p_customer_number_h=> p_customer_number_h,
547: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
548: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
549: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
550: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
551: p_trx_num_l=> p_trx_num_l,
552: p_trx_num_h=> p_trx_num_h,
553: p_remittance_total_to=> p_remittance_total_to,

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

546: p_customer_number_h=> p_customer_number_h,
547: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
548: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
549: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
550: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
551: p_trx_num_l=> p_trx_num_l,
552: p_trx_num_h=> p_trx_num_h,
553: p_remittance_total_to=> p_remittance_total_to,
554: p_remittance_total_from=> p_remittance_total_from,

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

596: IF p_create_flag = 'Y' THEN
597: select_update_rec(
598: p_customer_number_l=> p_customer_number_l,
599: p_customer_number_h=> p_customer_number_h,
600: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
601: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
602: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
603: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
604: p_trx_num_l=> p_trx_num_l,

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

597: select_update_rec(
598: p_customer_number_l=> p_customer_number_l,
599: p_customer_number_h=> p_customer_number_h,
600: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
601: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
602: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
603: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
604: p_trx_num_l=> p_trx_num_l,
605: p_trx_num_h=> p_trx_num_h,

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

598: p_customer_number_l=> p_customer_number_l,
599: p_customer_number_h=> p_customer_number_h,
600: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
601: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
602: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
603: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
604: p_trx_num_l=> p_trx_num_l,
605: p_trx_num_h=> p_trx_num_h,
606: p_remittance_total_to=> p_remittance_total_to,

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

599: p_customer_number_h=> p_customer_number_h,
600: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
601: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
602: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
603: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
604: p_trx_num_l=> p_trx_num_l,
605: p_trx_num_h=> p_trx_num_h,
606: p_remittance_total_to=> p_remittance_total_to,
607: p_remittance_total_from=> p_remittance_total_from,

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

1044:
1045: BEGIN
1046: fnd_file.put_line( FND_FILE.LOG, 'submit_autorem_parallel()+');
1047:
1048: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
1049: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
1050: l_create_flag := p_create_flag;
1051: l_approve_flag := p_approve_flag;
1052: l_format_flag := p_format_flag;

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

1045: BEGIN
1046: fnd_file.put_line( FND_FILE.LOG, 'submit_autorem_parallel()+');
1047:
1048: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
1049: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
1050: l_create_flag := p_create_flag;
1051: l_approve_flag := p_approve_flag;
1052: l_format_flag := p_format_flag;
1053: l_currency_code := p_batch_currency;

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

1128: end if;
1129: select_update_rec(
1130: p_customer_number_l=> p_customer_number_l,
1131: p_customer_number_h=> p_customer_number_h,
1132: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
1133: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
1134: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
1135: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
1136: p_trx_num_l=> p_trx_num_l,

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

1129: select_update_rec(
1130: p_customer_number_l=> p_customer_number_l,
1131: p_customer_number_h=> p_customer_number_h,
1132: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
1133: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
1134: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
1135: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
1136: p_trx_num_l=> p_trx_num_l,
1137: p_trx_num_h=> p_trx_num_h,

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

1130: p_customer_number_l=> p_customer_number_l,
1131: p_customer_number_h=> p_customer_number_h,
1132: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
1133: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
1134: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
1135: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
1136: p_trx_num_l=> p_trx_num_l,
1137: p_trx_num_h=> p_trx_num_h,
1138: p_remittance_total_to=> p_remittance_total_to,

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

1131: p_customer_number_h=> p_customer_number_h,
1132: p_trx_date_l=> fnd_date.canonical_to_date(p_trx_date_l),
1133: p_trx_date_h=> fnd_date.canonical_to_date(p_trx_date_h),
1134: p_due_date_l=> fnd_date.canonical_to_date(p_due_date_l),
1135: p_due_date_h=> fnd_date.canonical_to_date(p_due_date_h),
1136: p_trx_num_l=> p_trx_num_l,
1137: p_trx_num_h=> p_trx_num_h,
1138: p_remittance_total_to=> p_remittance_total_to,
1139: p_remittance_total_from=> p_remittance_total_from,

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

1530: and rma.bank_account_id = ba.bank_account_id
1531: and ( ba.currency_code = p_currency_code
1532: or ba.receipt_multi_currency_flag = 'Y' )
1533: and ba.set_of_books_id = asp.set_of_books_id
1534: and nvl(ba.inactive_date , fnd_date.canonical_to_date(p_batch_date) + 1 ) > fnd_date.canonical_to_date(p_batch_date)
1535: and fnd_date.canonical_to_date(p_batch_date)
1536: between rma.start_date
1537: and nvl(rma.end_date,fnd_date.canonical_to_date(p_batch_date))
1538: and ( bb.bank_branch_id = ba.bank_branch_id

Line 1535: and fnd_date.canonical_to_date(p_batch_date)

1531: and ( ba.currency_code = p_currency_code
1532: or ba.receipt_multi_currency_flag = 'Y' )
1533: and ba.set_of_books_id = asp.set_of_books_id
1534: and nvl(ba.inactive_date , fnd_date.canonical_to_date(p_batch_date) + 1 ) > fnd_date.canonical_to_date(p_batch_date)
1535: and fnd_date.canonical_to_date(p_batch_date)
1536: between rma.start_date
1537: and nvl(rma.end_date,fnd_date.canonical_to_date(p_batch_date))
1538: and ( bb.bank_branch_id = ba.bank_branch_id
1539: or ( bb.institution_type = 'CLEARING HOUSE'

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

1533: and ba.set_of_books_id = asp.set_of_books_id
1534: and nvl(ba.inactive_date , fnd_date.canonical_to_date(p_batch_date) + 1 ) > fnd_date.canonical_to_date(p_batch_date)
1535: and fnd_date.canonical_to_date(p_batch_date)
1536: between rma.start_date
1537: and nvl(rma.end_date,fnd_date.canonical_to_date(p_batch_date))
1538: and ( bb.bank_branch_id = ba.bank_branch_id
1539: or ( bb.institution_type = 'CLEARING HOUSE'
1540: and exists
1541: ( select 1