APPS.JAI_INV_ITEMS_PKG dependencies on DUAL

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

202: ln_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE DEFAULT NULL;
203: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_create_template';
204: BEGIN -- Create Template
205:
206: --SELECT JAI_RGM_ITM_TEMPLATES_S.NEXTVAL INTO ln_template_id FROM DUAL;
207:
208: INSERT INTO JAI_RGM_ITM_TEMPLATES
209: (
210: template_id

Line 291: FROM DUAL;

287: IF p_templ_org_regns_id IS NULL THEN
288:
289: SELECT JAI_RGM_TMPL_ORG_REGNS_S.NEXTVAL
290: INTO p_templ_org_regns_id
291: FROM DUAL;
292: /* Create template organization association */
293: INSERT INTO JAI_RGM_TMPL_ORG_REGNS
294: ( templ_org_regns_id
295: , template_id

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

407: * Item specific registration does not exist so create one by inserting a row in
408: * JAI_RGM_ITM_REGNS
409: */
410:
411: --SELECT JAI_RGM_ITM_REGNS_S.NEXTVAL INTO ln_rgm_item_regns_id FROM DUAL;
412:
413: INSERT INTO JAI_RGM_ITM_REGNS
414: ( rgm_item_regns_id
415: ,regime_code