APPS.JAI_INV_ITEMS_PKG dependencies on DUAL

Line 201: --SELECT JAI_RGM_ITM_TEMPLATES_S.NEXTVAL INTO ln_template_id FROM DUAL;

197: ln_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE DEFAULT NULL;
198: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_create_template';
199: BEGIN -- Create Template
200:
201: --SELECT JAI_RGM_ITM_TEMPLATES_S.NEXTVAL INTO ln_template_id FROM DUAL;
202:
203: INSERT INTO JAI_RGM_ITM_TEMPLATES
204: (
205: template_id

Line 286: FROM DUAL;

282: IF p_templ_org_regns_id IS NULL THEN
283:
284: SELECT JAI_RGM_TMPL_ORG_REGNS_S.NEXTVAL
285: INTO p_templ_org_regns_id
286: FROM DUAL;
287: /* Create template organization association */
288: INSERT INTO JAI_RGM_TMPL_ORG_REGNS
289: ( templ_org_regns_id
290: , template_id

Line 406: --SELECT JAI_RGM_ITM_REGNS_S.NEXTVAL INTO ln_rgm_item_regns_id FROM DUAL;

402: * Item specific registration does not exist so create one by inserting a row in
403: * JAI_RGM_ITM_REGNS
404: */
405:
406: --SELECT JAI_RGM_ITM_REGNS_S.NEXTVAL INTO ln_rgm_item_regns_id FROM DUAL;
407:
408: INSERT INTO JAI_RGM_ITM_REGNS
409: ( rgm_item_regns_id
410: ,regime_code