APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on DUAL

Line 312: FROM dual;

308: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_dist_id := NULL;
309:
310: SELECT ZX_REC_NREC_DIST_S.nextval
311: INTO ZX_TRD_SERVICES_PUB_PKG.g_tax_dist_id
312: FROM dual;
313:
314: -- For a update event in quote calls(only PO has such case now),
315: -- no need to Update_Item_Dist_Changed_Flag, since all tax lines have been
316: -- brought back to zx_detail_tax_lines_gt (bug 4313177).

Line 1374: FROM dual;

1370: -- get g_tax_dist_id
1371: --
1372: SELECT ZX_REC_NREC_DIST_S.nextval
1373: INTO ZX_TRD_SERVICES_PUB_PKG.g_tax_dist_id
1374: FROM dual;
1375:
1376: p_rec_nrec_dist_tbl(l_index).Reverse_Flag:= 'Y';
1377:
1378: l_index:= l_index + 1;

Line 1454: FROM dual;

1450: -- get g_tax_dist_id
1451: --
1452: SELECT ZX_REC_NREC_DIST_S.nextval
1453: INTO ZX_TRD_SERVICES_PUB_PKG.g_tax_dist_id
1454: FROM dual;
1455:
1456: -- ZX_TRD_SERVICES_PUB_PKG.g_tax_dist_id:= ZX_TRD_SERVICES_PUB_PKG.g_tax_dist_id + 1;
1457:
1458: p_rec_nrec_dist_tbl(l_index):= p_rec_nrec_dist_tbl(l_index - 2);

Line 4252: FROM dual;

4248: -- get g_tax_dist_id
4249: --
4250: SELECT ZX_REC_NREC_DIST_S.nextval
4251: INTO ZX_TRD_SERVICES_PUB_PKG.g_tax_dist_id
4252: FROM dual;
4253:
4254: p_rec_nrec_dist_tbl(i).rec_nrec_tax_dist_id :=
4255: ZX_TRD_SERVICES_PUB_PKG.g_tax_dist_id;
4256: