APPS.JTF_TTY_PROD_CAT_MIGRATE_PVT dependencies on JTF_QUAL_USGS_ALL

Line 184: UPDATE jtf_qual_usgs_all

180:
181: --Disable usage of old qualifier
182: /*
183: commented out 07/10/2006, ref bug 5193133 replaced below
184: UPDATE jtf_qual_usgs_all
185: SET enabled_flag = 'N'
186: WHERE qual_usg_id = -1023;
187: */
188:

Line 195: DELETE FROM jtf_qual_usgs_all

191:
192: delete from jtf_seeded_qual_all_tl
193: where seeded_qual_id = -1024;
194:
195: DELETE FROM jtf_qual_usgs_all
196: WHERE qual_usg_id = -1023;
197:
198: if (upper(p_Debug_Flag) = 'Y') then
199: FND_FILE.PUT_LINE(FND_FILE.LOG,'Disabled Qualifier Opportunity Expected Purchase');

Line 203: UPDATE jtf_qual_usgs_all

199: FND_FILE.PUT_LINE(FND_FILE.LOG,'Disabled Qualifier Opportunity Expected Purchase');
200: end if;
201:
202: --Enable usage of new qualifier
203: UPDATE jtf_qual_usgs_all
204: SET enabled_flag = 'Y'
205: WHERE qual_usg_id = -1142;
206: if (upper(p_Debug_Flag) = 'Y') then
207: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enabled Qualifier Opportunity Product Category');

Line 221: UPDATE jtf_qual_usgs_all

217:
218: --Disable usage of old qualifier, lead expected
219: /*
220: commented out 07/10/2006, ref bug 5193133 replaced below
221: UPDATE jtf_qual_usgs_all
222: SET enabled_flag = 'N'
223: WHERE qual_usg_id = -1018;
224: */
225:

Line 232: DELETE FROM jtf_qual_usgs_all

228:
229: delete from jtf_seeded_qual_all_tl
230: where seeded_qual_id = -1019;
231:
232: DELETE FROM jtf_qual_usgs_all
233: WHERE qual_usg_id = -1018;
234:
235: if (upper(p_Debug_Flag) = 'Y') then
236: FND_FILE.PUT_LINE(FND_FILE.LOG,'Disabled Qualifier Lead Expected Purchase');

Line 239: UPDATE jtf_qual_usgs_all

235: if (upper(p_Debug_Flag) = 'Y') then
236: FND_FILE.PUT_LINE(FND_FILE.LOG,'Disabled Qualifier Lead Expected Purchase');
237: end if;
238:
239: UPDATE jtf_qual_usgs_all
240: SET enabled_flag = 'Y'
241: WHERE qual_usg_id = -1131;
242: if (upper(p_Debug_Flag) = 'Y') then
243: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enabled Qualifier Lead Product Category');