APPS.AMS_CUST_SETUP_PVT dependencies on AMS_CUSTOM_SETUP_ATTR

Line 196: INSERT INTO AMS_CUSTOM_SETUP_ATTR

192: -- finish
193: x_cust_setup_id := l_cust_setup_rec.custom_setup_id;
194:
195: IF l_cust_setup_rec.usage IS NULL THEN
196: INSERT INTO AMS_CUSTOM_SETUP_ATTR
197: (
198: setup_attribute_id,
199: custom_setup_id,
200: last_update_date,

Line 220: select ams_custom_setup_attr_s.nextval,

216: copy_allowed_flag,
217: related_ak_attribute,
218: essential_seq_num
219: )
220: select ams_custom_setup_attr_s.nextval,
221: x_cust_setup_id,
222: SYSDATE,
223: FND_GLOBAL.user_id,
224: SYSDATE,

Line 248: INSERT INTO AMS_CUSTOM_SETUP_ATTR

244: AND stp.activity_type_code = l_cust_setup_rec.activity_type_code
245: AND (stp.usage ='ALL' OR stp.usage is null)
246: AND stp.application_id = l_cust_setup_rec.application_id;
247: IF SQL%NOTFOUND THEN
248: INSERT INTO AMS_CUSTOM_SETUP_ATTR
249: (
250: setup_attribute_id,
251: custom_setup_id,
252: last_update_date,

Line 272: select ams_custom_setup_attr_s.nextval,

268: copy_allowed_flag,
269: related_ak_attribute,
270: essential_seq_num
271: )
272: select ams_custom_setup_attr_s.nextval,
273: x_cust_setup_id,
274: SYSDATE,
275: FND_GLOBAL.user_id,
276: SYSDATE,

Line 303: INSERT INTO AMS_CUSTOM_SETUP_ATTR

299:
300: ELSE
301: --anchaudh adding the IF condition for bug#3718563
302: IF (l_cust_setup_rec.activity_type_code = 'DIRECT_MARKETING' AND l_cust_setup_rec.media_id = 460) THEN
303: INSERT INTO AMS_CUSTOM_SETUP_ATTR
304: (
305: setup_attribute_id,
306: custom_setup_id,
307: last_update_date,

Line 327: select ams_custom_setup_attr_s.nextval,

323: copy_allowed_flag,
324: related_ak_attribute,
325: essential_seq_num
326: )
327: select ams_custom_setup_attr_s.nextval,
328: x_cust_setup_id,
329: SYSDATE,
330: FND_GLOBAL.user_id,
331: SYSDATE,

Line 359: INSERT INTO AMS_CUSTOM_SETUP_ATTR

355: AND stp.application_id = l_cust_setup_rec.application_id
356: AND stp.setup_attribute not in ('COLT'); --ANCHAUDH
357:
358: IF SQL%NOTFOUND THEN
359: INSERT INTO AMS_CUSTOM_SETUP_ATTR
360: (
361: setup_attribute_id,
362: custom_setup_id,
363: last_update_date,

Line 383: select ams_custom_setup_attr_s.nextval,

379: copy_allowed_flag,
380: related_ak_attribute,
381: essential_seq_num
382: )
383: select ams_custom_setup_attr_s.nextval,
384: x_cust_setup_id,
385: SYSDATE,
386: FND_GLOBAL.user_id,
387: SYSDATE,

Line 416: INSERT INTO AMS_CUSTOM_SETUP_ATTR

412: END IF;
413:
414: ELSE --anchaudh adding the ELSE condition for bug#3718563
415:
416: INSERT INTO AMS_CUSTOM_SETUP_ATTR
417: (
418: setup_attribute_id,
419: custom_setup_id,
420: last_update_date,

Line 440: select ams_custom_setup_attr_s.nextval,

436: copy_allowed_flag,
437: related_ak_attribute,
438: essential_seq_num
439: )
440: select ams_custom_setup_attr_s.nextval,
441: x_cust_setup_id,
442: SYSDATE,
443: FND_GLOBAL.user_id,
444: SYSDATE,

Line 471: INSERT INTO AMS_CUSTOM_SETUP_ATTR

467: AND stp.usage in ('LITE','ALL')
468: AND stp.application_id = l_cust_setup_rec.application_id;
469:
470: IF SQL%NOTFOUND THEN
471: INSERT INTO AMS_CUSTOM_SETUP_ATTR
472: (
473: setup_attribute_id,
474: custom_setup_id,
475: last_update_date,

Line 495: select ams_custom_setup_attr_s.nextval,

491: copy_allowed_flag,
492: related_ak_attribute,
493: essential_seq_num
494: )
495: select ams_custom_setup_attr_s.nextval,
496: x_cust_setup_id,
497: SYSDATE,
498: FND_GLOBAL.user_id,
499: SYSDATE,

Line 883: DELETE FROM AMS_CUSTOM_SETUP_ATTR

879: CLOSE c_object_version;
880:
881: IF l_is_used_count = 0 THEN -- IS NOT USED
882: IF l_object_version = p_object_version THEN -- VERSIONS MATCH
883: DELETE FROM AMS_CUSTOM_SETUP_ATTR
884: WHERE custom_setup_id = p_cust_setup_id;
885:
886: DELETE FROM AMS_CUSTOM_SETUPS_TL
887: WHERE custom_setup_id = p_cust_setup_id;