APPS.AMS_LIST_SRC_TYPES_PVT dependencies on AMS_LIST_SRC_FIELDS

Line 61: TYPE I_LIST_SOURCE_FIELD_IDLIST IS TABLE OF AMS_LIST_SRC_FIELDS.LIST_SOURCE_FIELD_ID%TYPE

57: x_msg_data OUT NOCOPY VARCHAR2,
58: p_list_source_type_id IN NUMBER
59: ) IS
60:
61: TYPE I_LIST_SOURCE_FIELD_IDLIST IS TABLE OF AMS_LIST_SRC_FIELDS.LIST_SOURCE_FIELD_ID%TYPE
62: INDEX BY BINARY_INTEGER;
63:
64: TYPE I_COLUMN_NAME_LIST IS TABLE OF VARCHAR2(30)
65: INDEX BY BINARY_INTEGER;

Line 102: FROM ams_list_src_fields --ams_list_src_fields_vl

98:
99:
100: cursor c_master is
101: SELECT list_source_field_id, field_column_name, substr(replace(source_column_name,' ','_'),1,26)
102: FROM ams_list_src_fields --ams_list_src_fields_vl
103: WHERE list_source_type_id = p_list_source_type_id
104: AND field_column_name <> 'CUSTOMER_NAME'
105: AND upper(source_column_name) not in ('PARTY_ID','PARTY_NAME')
106: AND nvl(enabled_flag,'Y') = 'Y';

Line 110: FROM ams_list_src_fields asf,

106: AND nvl(enabled_flag,'Y') = 'Y';
107:
108: cursor c_all_sub_types is
109: SELECT distinct asa.sub_source_type_id
110: FROM ams_list_src_fields asf,
111: ams_list_src_type_assocs asa
112: WHERE asa.master_source_type_id = p_list_source_type_id
113: AND asa.sub_source_type_id =asf.list_source_type_id
114: AND asf.field_column_name <> 'CUSTOMER_NAME'

Line 125: FROM ams_list_src_fields_vl asf,

121: WHERE aso.master_source_type_id = p_list_source_type_id
122: AND nvl(aso.enabled_flag,'Y') = 'Y' -- bug:4055791:musman checking for the enabled flag of the associations
123: and aso.SUB_SOURCE_TYPE_ID in (
124: SELECT distinct asa.sub_source_type_id
125: FROM ams_list_src_fields_vl asf,
126: ams_list_src_type_assocs asa,
127: ams_list_src_types_vl ast
128: WHERE asa.master_source_type_id = aso.master_source_type_id
129: AND asa.sub_source_type_id = aso.SUB_SOURCE_TYPE_ID

Line 141: FROM ams_list_src_fields asf

137:
138:
139: cursor c_total_sub_types is
140: SELECT count(distinct asa.sub_source_type_id)
141: FROM ams_list_src_fields asf
142: ,ams_list_src_type_assocs asa
143: WHERE asa.master_source_type_id = p_list_source_type_id
144: AND asa.sub_source_type_id = asf.list_source_type_id
145: AND asf.field_column_name <> 'CUSTOMER_NAME'

Line 155: FROM ams_list_src_fields_vl asf,

151: WHERE aso.master_source_type_id = p_list_source_type_id
152: AND nvl(aso.enabled_flag,'Y') = 'Y' -- bug:4055791:musman checking for the enabled flag of the associations
153: and aso.SUB_SOURCE_TYPE_ID in (
154: SELECT distinct asa.sub_source_type_id
155: FROM ams_list_src_fields_vl asf,
156: ams_list_src_type_assocs asa,
157: ams_list_src_types_vl ast
158: WHERE asa.master_source_type_id = aso.master_source_type_id
159: AND asa.sub_source_type_id = aso.SUB_SOURCE_TYPE_ID

Line 173: FROM ams_list_src_fields asf,

169: SELECT list_source_type_id FROM ams_list_src_types_vl WHERE source_type_code = 'FAX';
170:
171: cursor c_sub_type is
172: SELECT asf.list_source_field_id, asf.field_column_name, substr(replace(asf.source_column_name,' ','_'),1,26)||'_S'||to_char(i_number)
173: FROM ams_list_src_fields asf,
174: ams_list_src_type_assocs asa
175: WHERE asa.master_source_type_id = p_list_source_type_id
176: AND asa.sub_source_type_id = L_SUB_SOURCE_TYPE_ID
177: AND asa.sub_source_type_id = asf.list_source_type_id

Line 183: FROM ams_list_src_fields_vl asf,

179: AND nvl(asa.enabled_flag,'Y') = 'Y'
180: AND nvl(asf.enabled_flag,'Y') = 'Y';
181: /* SQL ID: 11756019 Fix
182: SELECT asf.list_source_field_id, asf.field_column_name, substr(replace(asf.source_column_name,' ','_'),1,26)||'_S'||to_char(i_number)
183: FROM ams_list_src_fields_vl asf,
184: ams_list_src_type_assocs asa,
185: ams_list_src_types_vl ast
186: WHERE asa.master_source_type_id = p_list_source_type_id
187: AND asa.sub_source_type_id = L_SUB_SOURCE_TYPE_ID

Line 198: FROM ams_list_src_fields asf,

194: */
195:
196: cursor c_count_sub_type is
197: SELECT count(*)
198: FROM ams_list_src_fields asf,
199: ams_list_src_type_assocs asa
200: WHERE asa.master_source_type_id = p_list_source_type_id
201: AND asa.sub_source_type_id = L_SUB_SOURCE_TYPE_ID
202: AND asa.sub_source_type_id = asf.list_source_type_id

Line 208: FROM ams_list_src_fields_vl asf,

204: AND nvl(asf.enabled_flag,'Y') = 'Y'
205: AND nvl(asa.enabled_flag,'Y') = 'Y';
206: /* SQL ID: 11756034 fix: musman
207: SELECT count(*)
208: FROM ams_list_src_fields_vl asf,
209: ams_list_src_type_assocs asa,
210: ams_list_src_types_vl ast
211: WHERE asa.master_source_type_id = p_list_source_type_id
212: AND asa.sub_source_type_id = L_SUB_SOURCE_TYPE_ID

Line 223: FROM ams_list_src_fields_vl asf,

219:
220: /* -- looks like this cursor has not been used : musman
221: cursor c_dup_st is
222: SELECT COUNT(*)
223: FROM ams_list_src_fields_vl asf,
224: ams_list_src_type_assocs asa,
225: ams_list_src_types_vl ast
226: WHERE asa.master_source_type_id = p_list_source_type_id
227: AND asa.sub_source_type_id = asf.list_source_type_id

Line 235: FROM ams_list_src_fields --ams_list_src_fields_vl

231: */
232:
233: cursor c_master_exists is
234: SELECT 'Y'
235: FROM ams_list_src_fields --ams_list_src_fields_vl
236: WHERE list_source_type_id = p_list_source_type_id
237: AND field_column_name <> 'CUSTOMER_NAME'
238: AND upper(source_column_name) not in ('PARTY_ID','PARTY_NAME')
239: AND nvl(enabled_flag,'Y') = 'Y'

Line 244: FROM ams_list_src_fields asf, --ams_list_src_fields_vl asf,

240: AND ROWNUM < 2;
241:
242: cursor c_sub_type_exists is
243: SELECT 'Y'
244: FROM ams_list_src_fields asf, --ams_list_src_fields_vl asf,
245: ams_list_src_type_assocs asa
246: WHERE asa.master_source_type_id = p_list_source_type_id
247: AND asa.sub_source_type_id = asf.list_source_type_id
248: AND NVL(asf.enabled_flag,'Y') = 'Y'

Line 254: FROM ams_list_src_fields_vl

250: AND ROWNUM < 2;
251:
252: cursor c_mst_exist is
253: SELECT 'Y'
254: FROM ams_list_src_fields_vl
255: WHERE list_source_type_id = p_list_source_type_id
256: AND nvl(enabled_flag,'Y') = 'Y'
257: AND substr(source_column_name,1,28) = i_mst_source ;
258: