APPS.AMS_CTD_PVT dependencies on AMS_CTD_ASSOCIATIONS

Line 82: FROM ams_ctd_associations

78: /* bugfix: 3470296. Added by rrajesh on 02/27/04 */
79: CURSOR C_CHECK_CTD_ASSOCIATION_EXISTS
80: IS
81: SELECT ctd_id
82: FROM ams_ctd_associations
83: WHERE used_by_type = p_used_by AND used_by_val1 = p_used_by_val1;
84: /* End bugfix: 3470296.*/
85:
86: /* Bugfix: 4261272. Fix for SQL repository issue: 11753011 */

Line 95: FROM AMS_CTD_ASSOCIATIONS assoc,

91: (SELECT column_value ctd_id
92: FROM TABLE(CAST(p_ctd_id_list as JTF_NUMBER_TABLE)) ) CTD_LIST1
93: WHERE CTD_LIST1.CTD_ID NOT IN
94: (SELECT ASSOC.CTD_ID
95: FROM AMS_CTD_ASSOCIATIONS assoc,
96: (SELECT column_value ctd_id
97: FROM TABLE(CAST(p_ctd_id_list as JTF_NUMBER_TABLE))) ctd_list
98: WHERE assoc.ctd_id = ctd_list.ctd_id
99: ); */

Line 106: WHERE NOT EXISTS (select 1 from AMS_CTD_ASSOCIATIONS assoc WHERE

102: SELECT CTD_LIST1.CTD_ID
103: FROM
104: (SELECT column_value ctd_id
105: FROM TABLE(CAST(p_ctd_id_list as JTF_NUMBER_TABLE)) ) CTD_LIST1
106: WHERE NOT EXISTS (select 1 from AMS_CTD_ASSOCIATIONS assoc WHERE
107: assoc.ctd_id = ctd_list1.ctd_id);
108: /* End Bugfix: 4261272. */
109:
110: l_not_associated_ctd_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 138: DELETE FROM AMS_CTD_ASSOCIATIONS

134: 'Before bulk delete of association'
135: );
136: -- Delete the association
137: FORALL i in p_ctd_id_list.FIRST .. p_ctd_id_list.LAST
138: DELETE FROM AMS_CTD_ASSOCIATIONS
139: WHERE CTD_ID = p_ctd_id_list(i)
140: and used_by_type = p_used_by
141: and used_by_val1 = p_used_by_val1;
142:

Line 216: SELECT ams_ctd_associations_s.nextval

212: l_assoc_seq_id_list NUMBER_TABLE;
213:
214: CURSOR C_GET_NEXT_SEQ_ID
215: IS
216: SELECT ams_ctd_associations_s.nextval
217: FROM DUAL;
218:
219: l_list_count NUMBER;
220: list_count NUMBER;

Line 252: 'About to bulk upload into AMS_CTD_ASSOCIATIONS'

248:
249: write_debug_message(FND_LOG.LEVEL_EVENT,
250: PROCEDURE_NAME,
251: 'BEFORE_CTD_ASSOCIATIONS_BULK_UPLOAD',
252: 'About to bulk upload into AMS_CTD_ASSOCIATIONS'
253: );
254:
255: --Do a Bulk Upload
256: FORALL i in p_ctd_id_list.FIRST .. p_ctd_id_list.LAST

Line 258: AMS_CTD_ASSOCIATIONS

254:
255: --Do a Bulk Upload
256: FORALL i in p_ctd_id_list.FIRST .. p_ctd_id_list.LAST
257: INSERT INTO
258: AMS_CTD_ASSOCIATIONS
259: (
260: association_id,
261: ctd_id,
262: used_by_type,

Line 299: 'Bulk upload AMS_CTD_ASSOCIATIONS completed successfully!!'

295:
296: write_debug_message(FND_LOG.LEVEL_EVENT,
297: PROCEDURE_NAME,
298: 'AFTER_CTD_ASSOCIATIONS_BULK_UPLOAD',
299: 'Bulk upload AMS_CTD_ASSOCIATIONS completed successfully!!'
300: );
301: END IF;
302:
303:

Line 330: FROM AMS_CTD_ASSOCIATIONS assoc

326: FROM (SELECT column_value ctd_id
327: FROM TABLE(CAST(p_ctd_id_list as JTF_NUMBER_TABLE)) ) ctd_list
328: WHERE CTD_LIST.CTD_ID not in
329: (SELECT ASSOC.CTD_ID
330: FROM AMS_CTD_ASSOCIATIONS assoc
331: WHERE assoc.used_by_type = p_used_by
332: AND assoc.used_by_val1 = p_used_by_val1
333: );
334:

Line 339: FROM AMS_CTD_ASSOCIATIONS

335:
336: CURSOR C_REMOVED_ASSOCIATIONS
337: IS
338: SELECT CTD_ID
339: FROM AMS_CTD_ASSOCIATIONS
340: WHERE used_by_type = p_used_by
341: AND used_by_val1 = p_used_by_val1
342: AND CTD_ID NOT IN
343: (SELECT column_value ctd_id

Line 400: FROM AMS_CTD_ASSOCIATIONS

396:
397: CURSOR C_GET_ASSOCIATED_CTDS
398: IS
399: SELECT CTD_ID
400: FROM AMS_CTD_ASSOCIATIONS
401: WHERE USED_BY_TYPE = p_used_by
402: AND p_used_by_val1 = p_used_by_val1;
403:
404: BEGIN