APPS.JTF_TTY_PROD_CAT_MIGRATE_PVT dependencies on JTF_TERR_VALUES_ALL

Line 8: and Lead Expected Purchase in the JTF_TERR_VALUES_ALL table. It also updates

4: --*****************************************************************************
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,

Line 41: interest codes in the JTF_TERR_VALUES_ALL table */

37: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in Product Catalog data migration '||SQLERRM);
38: END Migrate_All;
39:
40: /* This procedure migrates interest types, primary interest codes and secondary
41: interest codes in the JTF_TERR_VALUES_ALL table */
42: PROCEDURE Migrate_Product_Cat_Terr(p_Qual_Usg_Id IN NUMBER,
43: p_Qual_Usg_Id_New IN NUMBER,
44: p_Debug_Flag IN VARCHAR2 Default 'N') IS
45:

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 91: UPDATE jtf_terr_values_all jtv

87: if (upper(p_Debug_Flag) = 'Y') then
88: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interest Types: Rows to be migrated: ' || l_terr_val_ids_arr.COUNT);
89: end if;
90: FORALL j IN l_terr_val_ids_arr.FIRST..l_terr_val_ids_arr.LAST
91: UPDATE jtf_terr_values_all jtv
92: SET (value1_id, value2_id) =
93: (SELECT int.product_category_id, int.product_cat_set_id
94: FROM as_interest_types_b int
95: WHERE jtv.interest_type_id = int.interest_type_id)

Line 121: UPDATE jtf_terr_values_all jtv

117: if (upper(p_Debug_Flag) = 'Y') then
118: FND_FILE.PUT_LINE(FND_FILE.LOG,'Primary Interest Codes: Rows to be migrated: ' || l_terr_val_ids_arr.COUNT);
119: end if;
120: FORALL j IN l_terr_val_ids_arr.FIRST..l_terr_val_ids_arr.LAST
121: UPDATE jtf_terr_values_all jtv
122: SET (value1_id, value2_id) =
123: (SELECT int.product_category_id, int.product_cat_set_id
124: FROM as_interest_codes_b int
125: WHERE jtv.primary_interest_code_id = int.interest_code_id)

Line 151: UPDATE jtf_terr_values_all jtv

147: if (upper(p_Debug_Flag) = 'Y') then
148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Secondary Interest Codes: Rows to be migrated: ' || l_terr_val_ids_arr.COUNT);
149: end if;
150: FORALL j IN l_terr_val_ids_arr.FIRST..l_terr_val_ids_arr.LAST
151: UPDATE jtf_terr_values_all jtv
152: SET (value1_id, value2_id) =
153: (SELECT int.product_category_id, int.product_cat_set_id
154: FROM as_interest_codes_b int
155: WHERE jtv.secondary_interest_code_id = int.interest_code_id)