APPS.JTF_TTY_PROD_CAT_MIGRATE_PVT dependencies on JTF_TERR_QUAL_ALL

Line 9: the JTF_TERR_QUAL_ALL table with new qual_usg_ids */

5:
6: /* This procedure calls other procedure(s) to migrate the interest types, primary
7: interest codes and secondary interest codes for Opportunity Expected Purchase
8: and Lead Expected Purchase in the JTF_TERR_VALUES_ALL table. It also updates
9: the JTF_TERR_QUAL_ALL table with new qual_usg_ids */
10:
11: PROCEDURE Migrate_All ( ERRBUF OUT NOCOPY VARCHAR2,
12: RETCODE OUT NOCOPY VARCHAR2,
13: p_Debug_Flag IN VARCHAR2 default 'N') IS

Line 52: FROM jtf_terr_values_all a, jtf_terr_qual_all b

48:
49: -- Cursor for Interest Type Updates
50: CURSOR c_int_type_upd_list(l_qual_usg_id NUMBER, l_qual_usg_id_new NUMBER ) IS
51: SELECT a.terr_value_id
52: FROM jtf_terr_values_all a, jtf_terr_qual_all b
53: WHERE a.terr_qual_id = b.terr_qual_id
54: AND b.qual_usg_id IN (l_qual_usg_id, l_qual_usg_id_new)
55: AND a.interest_type_id is not null
56: AND a.primary_interest_code_id is null

Line 62: FROM jtf_terr_values_all a, jtf_terr_qual_all b

58:
59: -- Cursor for Primary Interest Code Updates
60: CURSOR c_pri_int_upd_list(l_qual_usg_id NUMBER, l_qual_usg_id_new NUMBER) IS
61: SELECT a.terr_value_id
62: FROM jtf_terr_values_all a, jtf_terr_qual_all b
63: WHERE a.terr_qual_id = b.terr_qual_id
64: AND b.qual_usg_id IN (l_qual_usg_id, l_qual_usg_id_new)
65: AND a.primary_interest_code_id is not null
66: AND a.secondary_interest_code_id is null;

Line 71: FROM jtf_terr_values_all a, jtf_terr_qual_all b

67:
68: -- Cursor for Secondary Interest Code Updates
69: CURSOR c_sec_int_upd_list(l_qual_usg_id NUMBER, l_qual_usg_id_new NUMBER) IS
70: SELECT a.terr_value_id
71: FROM jtf_terr_values_all a, jtf_terr_qual_all b
72: WHERE a.terr_qual_id = b.terr_qual_id
73: AND b.qual_usg_id IN (l_qual_usg_id, l_qual_usg_id_new)
74: AND a.secondary_interest_code_id is not null;
75:

Line 174: UPDATE jtf_terr_qual_all qual

170:
171: if (p_Qual_Usg_Id = -1023) then
172:
173: --Update Qualifiers
174: UPDATE jtf_terr_qual_all qual
175: SET qual_usg_id = -1142
176: WHERE qual_usg_id = -1023;
177: if (upper(p_Debug_Flag) = 'Y') then
178: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updated Qualifier Opportunity Expected Purchase to Opportunity Product Category');

Line 211: UPDATE jtf_terr_qual_all qual

207: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enabled Qualifier Opportunity Product Category');
208: end if;
209:
210: elsif (p_Qual_Usg_Id = -1018) then
211: UPDATE jtf_terr_qual_all qual
212: SET qual_usg_id = -1131
213: WHERE qual_usg_id = -1018;
214: if (upper(p_Debug_Flag) = 'Y') then
215: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updated Qualifier Lead Expected Purchase to Lead Product Category');