APPS.ZX_TRD_INTERNAL_SERVICES_PVT dependencies on DUAL

Line 387: p_rec_nrec_dist_tbl(i).rec_nrec_tax_dist_id FROM DUAL;

383: NVL(p_detail_tax_line_tbl(p_tax_line_index).summary_tax_line_id, -999999)
384: THEN
385:
386: SELECT zx_rec_nrec_dist_s.nextval INTO
387: p_rec_nrec_dist_tbl(i).rec_nrec_tax_dist_id FROM DUAL;
388:
389: END IF;
390:
391: IF NVL(p_rec_nrec_dist_tbl(i).freeze_flag, 'N') = 'Y' THEN

Line 396: SELECT zx_rec_nrec_dist_s.nextval INTO l_tax_dist_id from dual;

392:
393:
394: p_rec_nrec_dist_tbl(i).reverse_flag:= 'Y';
395:
396: SELECT zx_rec_nrec_dist_s.nextval INTO l_tax_dist_id from dual;
397:
398: l_new_index:= i + l_total_count;
399: p_rec_nrec_dist_tbl(l_new_index):= p_rec_nrec_dist_tbl(i);
400: p_rec_nrec_dist_tbl(l_new_index).rec_nrec_tax_dist_id:= l_tax_dist_id;

Line 456: SELECT zx_rec_nrec_dist_s.nextval INTO l_tax_dist_id from dual;

452: -- -p_rec_nrec_dist_tbl(l_new_index).exchange_rate_variance;
453:
454: l_new_index:= l_new_index + l_total_count;
455:
456: SELECT zx_rec_nrec_dist_s.nextval INTO l_tax_dist_id from dual;
457:
458: p_rec_nrec_dist_tbl(l_new_index) := p_rec_nrec_dist_tbl(i);
459: p_rec_nrec_dist_tbl(l_new_index).rec_nrec_tax_dist_id := l_tax_dist_id;
460: p_rec_nrec_dist_tbl(l_new_index).freeze_flag := 'N';

Line 643: SELECT zx_rec_nrec_dist_s.NEXTVAL INTO p_rec_nrec_dist_tbl(i).rec_nrec_tax_dist_id FROM DUAL;

639: i1 := i;
640: i:= i1 + 1;
641: p_rec_nrec_dist_tbl(i):= p_rec_nrec_dist_tbl(i1);
642:
643: SELECT zx_rec_nrec_dist_s.NEXTVAL INTO p_rec_nrec_dist_tbl(i).rec_nrec_tax_dist_id FROM DUAL;
644:
645: p_rec_nrec_dist_tbl(i).reversed_tax_dist_id:= p_rec_nrec_dist_tbl(i1).rec_nrec_tax_dist_id;
646: p_rec_nrec_dist_tbl(i).rec_nrec_tax_amt:= -p_rec_nrec_dist_tbl(i1).rec_nrec_tax_amt;
647: p_rec_nrec_dist_tbl(i).REC_NREC_TAX_AMT_TAX_CURR:= -p_rec_nrec_dist_tbl(i1).REC_NREC_TAX_AMT_TAX_CURR;

Line 2289: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_id from dual;

2285: p_rec_nrec_dist_tbl(p_rnd_end_index):= p_rec_nrec_dist_tbl(p_rnd_end_index - 1);
2286:
2287: -- bug 5417252
2288: SELECT zx_rec_nrec_dist_s.nextval INTO
2289: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_id from dual;
2290:
2291: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_number :=
2292: p_rec_nrec_dist_tbl(p_rnd_end_index-1).rec_nrec_tax_dist_number + 1;
2293:

Line 5860: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_id FROM DUAL;

5856:
5857: -- set MRC related columns
5858: --
5859: SELECT zx_rec_nrec_dist_s.NEXTVAL INTO
5860: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_id FROM DUAL;
5861:
5862: p_rec_nrec_dist_tbl(p_rnd_end_index).unrounded_rec_nrec_tax_amt :=
5863: p_rec_nrec_dist_tbl(j).unrounded_rec_nrec_tax_amt *
5864: mrc_line_rec.currency_conversion_rate;