APPS.JTF_TTY_PROD_CAT_MIGRATE_PVT dependencies on JTF_TTY_ROLE_PROD_INT

Line 26: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration started for Interest Types in JTF_TTY_ROLE_PROD_INT');

22: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration started for Lead Expected Purchase');
23: --Pass qual_usg_id for Lead Expected Purchase
24: Migrate_Product_Cat_Terr(-1018, -1131, p_Debug_Flag);
25:
26: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration started for Interest Types in JTF_TTY_ROLE_PROD_INT');
27: --Updating JTF_TTY_ROLE_PROD_INT table
28: Migrate_Product_Cat_Role(p_Debug_Flag);
29:
30: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration completed successfully');

Line 27: --Updating JTF_TTY_ROLE_PROD_INT table

23: --Pass qual_usg_id for Lead Expected Purchase
24: Migrate_Product_Cat_Terr(-1018, -1131, p_Debug_Flag);
25:
26: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration started for Interest Types in JTF_TTY_ROLE_PROD_INT');
27: --Updating JTF_TTY_ROLE_PROD_INT table
28: Migrate_Product_Cat_Role(p_Debug_Flag);
29:
30: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration completed successfully');
31:

Line 256: /* This procedure migrates interest types in the JTF_TTY_ROLE_PROD_INT table */

252: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Product Catalog data migration: ' || SQLERRM);
253: RAISE;
254: END Migrate_Product_Cat_Terr;
255:
256: /* This procedure migrates interest types in the JTF_TTY_ROLE_PROD_INT table */
257: PROCEDURE Migrate_Product_Cat_Role(p_Debug_Flag IN VARCHAR2 Default 'N') IS
258:
259: BEGIN
260:

Line 262: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start: Migrating Interest Types in JTF_TTY_ROLE_PROD_INT table');

258:
259: BEGIN
260:
261: if (upper(p_Debug_Flag) = 'Y') then
262: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start: Migrating Interest Types in JTF_TTY_ROLE_PROD_INT table');
263: end if;
264:
265: UPDATE jtf_tty_role_prod_int jtr
266: SET (product_category_id, product_category_set_id) =

Line 265: UPDATE jtf_tty_role_prod_int jtr

261: if (upper(p_Debug_Flag) = 'Y') then
262: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start: Migrating Interest Types in JTF_TTY_ROLE_PROD_INT table');
263: end if;
264:
265: UPDATE jtf_tty_role_prod_int jtr
266: SET (product_category_id, product_category_set_id) =
267: (SELECT int.product_category_id, int.product_cat_set_id
268: FROM as_interest_types_b int
269: WHERE jtr.interest_type_id = int.interest_type_id);

Line 273: FND_FILE.PUT_LINE(FND_FILE.LOG,'End: Migrating Interest Types in JTF_TTY_ROLE_PROD_INT table');

269: WHERE jtr.interest_type_id = int.interest_type_id);
270: COMMIT;
271:
272: if (upper(p_Debug_Flag) = 'Y') then
273: FND_FILE.PUT_LINE(FND_FILE.LOG,'End: Migrating Interest Types in JTF_TTY_ROLE_PROD_INT table');
274: end if;
275:
276: EXCEPTION
277: WHEN OTHERS THEN