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;
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;
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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;
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;
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,
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,
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,
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,
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
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'
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