APPS.ZX_TRD_INTERNAL_SERVICES_PVT dependencies on DUAL

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

393: NVL(p_detail_tax_line_tbl(p_tax_line_index).summary_tax_line_id, -999999)
394: THEN
395:
396: SELECT zx_rec_nrec_dist_s.nextval INTO
397: p_rec_nrec_dist_tbl(i).rec_nrec_tax_dist_id FROM DUAL;
398:
399: END IF;
400:
401: IF NVL(p_rec_nrec_dist_tbl(i).freeze_flag, 'N') = 'Y' THEN

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

402:
403:
404: p_rec_nrec_dist_tbl(i).reverse_flag:= 'Y';
405:
406: SELECT zx_rec_nrec_dist_s.nextval INTO l_tax_dist_id from dual;
407:
408: l_new_index:= i + l_total_count;
409: p_rec_nrec_dist_tbl(l_new_index):= p_rec_nrec_dist_tbl(i);
410: p_rec_nrec_dist_tbl(l_new_index).rec_nrec_tax_dist_id:= l_tax_dist_id;

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

462: -- -p_rec_nrec_dist_tbl(l_new_index).exchange_rate_variance;
463:
464: l_new_index:= l_new_index + l_total_count;
465:
466: SELECT zx_rec_nrec_dist_s.nextval INTO l_tax_dist_id from dual;
467:
468: p_rec_nrec_dist_tbl(l_new_index) := p_rec_nrec_dist_tbl(i);
469: p_rec_nrec_dist_tbl(l_new_index).rec_nrec_tax_dist_id := l_tax_dist_id;
470: p_rec_nrec_dist_tbl(l_new_index).freeze_flag := 'N';

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

693: i1 := i;
694: i:= i1 + 1;
695: p_rec_nrec_dist_tbl(i):= p_rec_nrec_dist_tbl(i1);
696:
697: SELECT zx_rec_nrec_dist_s.NEXTVAL INTO p_rec_nrec_dist_tbl(i).rec_nrec_tax_dist_id FROM DUAL;
698:
699: p_rec_nrec_dist_tbl(i).reversed_tax_dist_id:= p_rec_nrec_dist_tbl(i1).rec_nrec_tax_dist_id;
700: p_rec_nrec_dist_tbl(i).rec_nrec_tax_amt:= -p_rec_nrec_dist_tbl(i1).rec_nrec_tax_amt;
701: 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 2549: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_id from dual;

2545: p_rec_nrec_dist_tbl(p_rnd_end_index):= p_rec_nrec_dist_tbl(p_rnd_end_index - 1);
2546:
2547: -- bug 5417252
2548: SELECT zx_rec_nrec_dist_s.nextval INTO
2549: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_id from dual;
2550:
2551: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_number :=
2552: p_rec_nrec_dist_tbl(p_rnd_end_index-1).rec_nrec_tax_dist_number + 1;
2553:

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

6763:
6764: -- set MRC related columns
6765: --
6766: SELECT zx_rec_nrec_dist_s.NEXTVAL INTO
6767: p_rec_nrec_dist_tbl(p_rnd_end_index).rec_nrec_tax_dist_id FROM DUAL;
6768:
6769: p_rec_nrec_dist_tbl(p_rnd_end_index).unrounded_rec_nrec_tax_amt :=
6770: p_rec_nrec_dist_tbl(j).unrounded_rec_nrec_tax_amt *
6771: mrc_line_rec.currency_conversion_rate;