APPS.AMS_PROD_TEMPLATE_PVT dependencies on AMS_PROD_TEMPLATE_ATTR

Line 228: INSERT INTO ams_prod_template_attr

224: LOOP
225: FETCH c_get_prod_attr INTO l_get_prod_attr;
226: EXIT WHEN c_get_prod_attr%NOTFOUND;
227:
228: INSERT INTO ams_prod_template_attr
229: (
230: template_attribute_id
231: ,template_id
232: ,last_update_date

Line 245: ( ams_prod_template_attr_s.nextval,

241: ,default_flag
242: ,editable_flag
243: ,hide_flag
244: ) VALUES
245: ( ams_prod_template_attr_s.nextval,
246: x_template_id,
247: SYSDATE,
248: fnd_global.user_id,
249: SYSDATE,

Line 268: INSERT INTO ams_prod_template_attr

264: OPEN c_get_service_attr;
265: LOOP
266: FETCH c_get_service_attr INTO l_get_service_attr;
267: EXIT WHEN c_get_service_attr%NOTFOUND;
268: INSERT INTO ams_prod_template_attr
269: (
270: template_attribute_id
271: ,template_id
272: ,last_update_date

Line 285: (ams_prod_template_attr_s.nextval,

281: ,default_flag
282: ,editable_flag
283: ,hide_flag
284: ) VALUES
285: (ams_prod_template_attr_s.nextval,
286: x_template_id,
287: SYSDATE,
288: fnd_global.user_id,
289: SYSDATE,

Line 305: SELECT ams_prod_template_attr_s.nextval,

301: END IF;
302:
303:
304: /*
305: SELECT ams_prod_template_attr_s.nextval,
306: x_template_id,
307: SYSDATE,
308: fnd_global.user_id,
309: SYSDATE,

Line 698: DELETE FROM ams_prod_template_attr

694: END IF;
695: RAISE FND_API.g_exc_error;
696: END IF;
697:
698: DELETE FROM ams_prod_template_attr
699: WHERE template_id = p_template_id;
700:
701: DELETE FROM ams_templ_responsibility
702: WHERE template_id = p_template_id;