APPS.JTF_TTY_NA_TERRGP dependencies on JTF_TTY_ROLE_PROD_INT

Line 421: DELETE FROM jtf_tty_role_prod_int

417: /* delete all the terr gp owners, access and product */
418: DELETE FROM jtf_tty_terr_grp_owners
419: WHERE terr_group_id = p_terr_gp_id;
420:
421: DELETE FROM jtf_tty_role_prod_int
422: WHERE terr_group_role_id IN
423: (SELECT terr_group_role_id FROM jtf_tty_terr_grp_roles
424: WHERE terr_group_id = p_terr_gp_id);
425:

Line 2215: DELETE FROM jtf_tty_role_prod_int

2211: DELETE FROM jtf_tty_terr_grp_owners
2212: WHERE terr_group_id = p_terr_gp_id;
2213:
2214: /* delete all the roles, first the product interests, access and finally the roles */
2215: DELETE FROM jtf_tty_role_prod_int
2216: WHERE terr_group_role_id IN (
2217: SELECT terr_group_role_id
2218: FROM jtf_tty_terr_grp_roles
2219: WHERE terr_group_id = p_terr_gp_id);

Line 2657: INSERT INTO JTF_TTY_ROLE_PROD_INT(

2653: AS
2654: BEGIN
2655: /* create product interests for the role */
2656: IF (p_cat_enabled_flag = 'N') THEN
2657: INSERT INTO JTF_TTY_ROLE_PROD_INT(
2658: TERR_GROUP_ROLE_PROD_INT_ID,
2659: OBJECT_VERSION_NUMBER ,
2660: TERR_GROUP_ROLE_ID ,
2661: INTEREST_TYPE_ID,

Line 2668: JTF_TTY_ROLE_PROD_INT_S.NEXTVAL,

2664: LAST_UPDATED_BY ,
2665: LAST_UPDATE_DATE ,
2666: LAST_UPDATE_LOGIN)
2667: VALUES(
2668: JTF_TTY_ROLE_PROD_INT_S.NEXTVAL,
2669: 1,
2670: p_terr_gp_role_id,
2671: p_interest_type_id,
2672: p_user_id,

Line 2678: INSERT INTO JTF_TTY_ROLE_PROD_INT(

2674: p_user_id,
2675: SYSDATE,
2676: p_user_id);
2677: ELSE
2678: INSERT INTO JTF_TTY_ROLE_PROD_INT(
2679: TERR_GROUP_ROLE_PROD_INT_ID,
2680: OBJECT_VERSION_NUMBER ,
2681: TERR_GROUP_ROLE_ID ,
2682: INTEREST_TYPE_ID,

Line 2691: JTF_TTY_ROLE_PROD_INT_S.NEXTVAL,

2687: LAST_UPDATED_BY ,
2688: LAST_UPDATE_DATE ,
2689: LAST_UPDATE_LOGIN)
2690: VALUES(
2691: JTF_TTY_ROLE_PROD_INT_S.NEXTVAL,
2692: 1,
2693: p_terr_gp_role_id,
2694: -999,
2695: p_interest_type_id,

Line 2763: INSERT INTO JTF_TTY_ROLE_PROD_INT(

2759: SYSDATE,
2760: p_user_id);
2761:
2762: /* create product interests for the role */
2763: INSERT INTO JTF_TTY_ROLE_PROD_INT(
2764: TERR_GROUP_ROLE_PROD_INT_ID,
2765: OBJECT_VERSION_NUMBER ,
2766: TERR_GROUP_ROLE_ID ,
2767: INTEREST_TYPE_ID,

Line 2774: JTF_TTY_ROLE_PROD_INT_S.NEXTVAL,

2770: LAST_UPDATED_BY ,
2771: LAST_UPDATE_DATE ,
2772: LAST_UPDATE_LOGIN)
2773: VALUES(
2774: JTF_TTY_ROLE_PROD_INT_S.NEXTVAL,
2775: 1,
2776: p_terr_gp_role_id,
2777: p_interest_type_id,
2778: p_user_id,