[Home] [Help]
18: l_batch_id NUMBER;
19:
20: cursor c_batch_id is
21: select batch_id
22: from xtr_batches
23: where period_start = p_batch_start
24: and period_end = p_batch_end
25: and company_code = p_company
26: and batch_type is null; -- 3527080 exclude NRA batch
79: l_batch_id NUMBER;
80:
81: cursor c_batch_id is
82: select batch_id
83: from xtr_batches
84: where period_start = p_batch_start
85: and period_end = p_batch_end
86: and company_code = p_company
87: and batch_type is null;
148: and period_to = nvl(p_batch_BED, period_to);
149:
150: cursor find_transfer is
151: select 'Y'
152: from xtr_batches
153: where batch_id = nvl(p_batch_id, batch_id)
154: and company_code = p_company
155: and period_end = nvl(p_batch_BED, period_end)
156: and gl_group_id is not null
158:
159: cursor find_event is
160: select 'Y'
161: from xtr_batch_events a,
162: xtr_batches b
163: where a.batch_id = nvl(p_batch_id, a.batch_id)
164: and a.event_code = p_event
165: and a.authorized = nvl(p_authorize,a.authorized)
166: and b.batch_id = a.batch_id
328: --==========================================================================================--
329:
330: select rowid
331: into l_rowid
332: from xtr_batches
333: where batch_id = p_batch_id
334: and company_code = p_company
335: and batch_type is null -- 3527080 exclude NRA batch
336: for update of last_update_date nowait;
489: cursor INCOMPLETE_TRANSFER_BATCH is
490: select batch_id,
491: period_start,
492: period_end
493: from xtr_batches a
494: where company_code = p_company
495: and period_end <= p_cutoff_date
496: and nvl(upgrade_batch,'N') = 'N'
497: and batch_type is null
501: cursor INCOMPLETE_JOURNAL_BATCH is
502: select batch_id,
503: period_start,
504: period_end
505: from xtr_batches a
506: where company_code = p_company
507: and period_end <= p_cutoff_date
508: and nvl(upgrade_batch,'N') = 'N'
509: and batch_type is null
516: cursor INCOMPLETE_ACCRUAL_BATCH is
517: select batch_id,
518: period_start,
519: period_end
520: from xtr_batches a
521: where company_code = p_company
522: and period_end <= p_cutoff_date
523: and nvl(upgrade_batch,'N') = 'N'
524: and batch_type is null
537: cursor INCOMPLETE_RETRO_BATCH is
538: select batch_id,
539: period_start,
540: period_end
541: from xtr_batches a
542: where company_code = p_company
543: and period_end <= p_cutoff_date
544: and nvl(upgrade_batch,'N') = 'N'
545: and batch_type is null
559: cursor INCOMPLETE_REVAL_BATCH is
560: select batch_id,
561: period_start,
562: period_end
563: from xtr_batches a
564: where company_code = p_company
565: and period_end <= p_cutoff_date
566: and nvl(upgrade_batch,'N') = 'N'
567: and batch_type is null
573: order by period_end, period_start;
574:
575: cursor UPGRADE_REQUIRED is
576: SELECT 'Y'
577: FROM xtr_batches b,
578: xtr_revaluation_details a
579: WHERE b.company_code = p_company
580: AND b.batch_id = a.batch_id
581: AND NVL(b.upgrade_batch,'N') = 'Y'
581: AND NVL(b.upgrade_batch,'N') = 'Y'
582: AND b.batch_type is null -- 3527080 exclude NRA batch
583: UNION
584: SELECT 'Y'
585: FROM xtr_batches b,
586: xtr_accrls_amort a
587: WHERE b.company_code = p_company
588: AND b.batch_id = a.batch_id
589: AND NVL(b.upgrade_batch,'N') = 'Y'
867:
868: cursor prev_normal is
869: select batch_id,
870: period_end
871: from xtr_batches
872: where company_code = p_company
873: and period_end < p_curr_BED
874: and nvl(upgrade_batch,'N') = 'N'
875: and batch_type is null -- RA batch only
917: period_start,
918: period_end,
919: gl_group_id,
920: nvl(upgrade_batch,'N')
921: from xtr_batches
922: where company_code = p_company
923: and batch_type is null -- RA batch only
924: order by period_end desc, period_start desc, batch_id desc;
925:
1035: l_batch_id NUMBER := 0;
1036:
1037: cursor c_batch_id is
1038: select batch_id
1039: from xtr_batches
1040: where period_start = p_batch_start
1041: and period_end = p_batch_end
1042: and company_code = p_company
1043: and batch_type is null; -- 3527080 exclude NRA batch
1474: *------------------------------------------------------------------------------*/
1475:
1476: cursor cur_new_BID is
1477: select batch_id
1478: from xtr_batches
1479: where company_code = p_company
1480: and period_start = p_batch_start
1481: and period_end = p_batch_end
1482: and batch_type is null; -- 3527080 exclude NRA batch
1840: cursor INCOMPLETE_REVAL_BATCH is
1841: select batch_id,
1842: period_start,
1843: period_end
1844: from xtr_batches a
1845: where company_code = p_company
1846: and period_end <= p_cutoff_date
1847: and batch_type is null
1848: and nvl(upgrade_batch,'N') = 'N'
2071: cursor INCOMPLETE_RETRO_BATCH is
2072: select batch_id,
2073: period_start,
2074: period_end
2075: from xtr_batches a
2076: where company_code = p_company
2077: and period_end <= p_cutoff_date
2078: and batch_type is null
2079: and nvl(upgrade_batch,'N') = 'N'
2187: cursor INCOMPLETE_ACCRUAL_BATCH is
2188: select batch_id,
2189: period_start,
2190: period_end
2191: from xtr_batches a
2192: where company_code = p_company
2193: and period_end <= p_cutoff_date
2194: and batch_type is null
2195: and nvl(upgrade_batch,'N') = 'N'
2399: cursor INCOMPLETE_JOURNAL_BATCH is
2400: select batch_id,
2401: period_start,
2402: period_end
2403: from XTR_BATCHES a
2404: where company_code = p_company
2405: and period_end <= p_cutoff_date
2406: and batch_type is null
2407: and nvl(upgrade_batch,'N') = 'N'
2480: cursor INCOMPLETE_TRANSFER_BATCH is
2481: select batch_id,
2482: period_start,
2483: period_end
2484: from xtr_batches a
2485: where company_code = p_company
2486: and period_end <= p_cutoff_date
2487: and batch_type is null
2488: and gl_group_id is null