APPS.AMS_CTD_PVT dependencies on JTF_NUMBER_TABLE

Line 71: p_ctd_id_list JTF_NUMBER_TABLE,

67: -- This procedure deletes associations and all relevant CTD information
68: -- if no other object is using the CTD
69: --
70: Procedure DELETE_ASSOCIATION_AND_CTD(
71: p_ctd_id_list JTF_NUMBER_TABLE,
72: p_used_by VARCHAR2,
73: p_used_by_val1 VARCHAR2
74: )
75: IS

Line 92: FROM TABLE(CAST(p_ctd_id_list as JTF_NUMBER_TABLE)) ) CTD_LIST1

88: IS
89: SELECT CTD_LIST1.CTD_ID
90: FROM
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

Line 97: FROM TABLE(CAST(p_ctd_id_list as JTF_NUMBER_TABLE))) ctd_list

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: ); */
100: CURSOR C_GET_NOT_ASSOCIATED_CTD
101: IS

Line 105: FROM TABLE(CAST(p_ctd_id_list as JTF_NUMBER_TABLE)) ) CTD_LIST1

101: IS
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:

Line 110: l_not_associated_ctd_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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();
111: PROCEDURE_NAME CONSTANT VARCHAR2(30) := 'DELETE_ASSOCIATION_AND_CTD';
112:
113: BEGIN
114:

Line 207: p_ctd_id_list JTF_NUMBER_TABLE,

203: -- Used By and Used By PK1
204: --
205:
206: Procedure CREATE_ASSOCIATION(
207: p_ctd_id_list JTF_NUMBER_TABLE,
208: p_used_by VARCHAR2,
209: p_used_by_val1 VARCHAR2
210: )
211: IS

Line 318: p_ctd_id_list JTF_NUMBER_TABLE,

314: --
315: -- 2. Delete the associations which are not more valid
316: --
317: Procedure CREATE_AND_DELETE_ASSOCIATION(
318: p_ctd_id_list JTF_NUMBER_TABLE,
319: p_used_by VARCHAR2,
320: p_used_by_val1 VARCHAR2
321: )
322: IS

Line 327: FROM TABLE(CAST(p_ctd_id_list as JTF_NUMBER_TABLE)) ) ctd_list

323: CURSOR C_GET_NEW_ASSOCIATION
324: IS
325: SELECT CTD_LIST.CTD_ID
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

Line 344: FROM TABLE(CAST(p_ctd_id_list as JTF_NUMBER_TABLE))

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
344: FROM TABLE(CAST(p_ctd_id_list as JTF_NUMBER_TABLE))
345: );
346:
347: l_new_ctd_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
348: l_removed_ctd_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 347: l_new_ctd_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

343: (SELECT column_value ctd_id
344: FROM TABLE(CAST(p_ctd_id_list as JTF_NUMBER_TABLE))
345: );
346:
347: l_new_ctd_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
348: l_removed_ctd_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
349:
350:
351: BEGIN

Line 348: l_removed_ctd_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

344: FROM TABLE(CAST(p_ctd_id_list as JTF_NUMBER_TABLE))
345: );
346:
347: l_new_ctd_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
348: l_removed_ctd_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
349:
350:
351: BEGIN
352: -- Create the associations which do not already exist

Line 395: l_associated_ctd_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

391: p_used_by VARCHAR2,
392: p_used_by_val1 VARCHAR2
393: )
394: IS
395: l_associated_ctd_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
396:
397: CURSOR C_GET_ASSOCIATED_CTDS
398: IS
399: SELECT CTD_ID