DBA Data[Home] [Help]

APPS.JAI_INV_ITEMS_PKG dependencies on JAI_RGM_ITM_TEMPLATES_S

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 223: JAI_RGM_ITM_TEMPLATES_S.NEXTVAL /* Modified by Ramananda for removal of SQL LITERALs */

219: )
220: VALUES
221: (
222: --ln_template_id
223: JAI_RGM_ITM_TEMPLATES_S.NEXTVAL /* Modified by Ramananda for removal of SQL LITERALs */
224: , p_template_name
225: , p_description
226: , p_regime_code
227: , sysdate