APPS.JTF_TTY_GEO_TERRGP dependencies on JTF_TTY_TERR_GRP_OWNERS

Line 272: Insert into jtf_tty_terr_grp_owners

268: END;
269:
270: BEGIN
271:
272: Insert into jtf_tty_terr_grp_owners
273: ( TERR_GROUP_OWNER_ID
274: , OBJECT_VERSION_NUMBER
275: , TERR_GROUP_ID
276: , RSC_GROUP_ID

Line 286: SELECT jtf_tty_terr_grp_owners_s.nextval

282: , LAST_UPDATED_BY
283: , LAST_UPDATE_DATE
284: , LAST_UPDATE_LOGIN
285: )
286: SELECT jtf_tty_terr_grp_owners_s.nextval
287: , 1
288: , l_terr_grp_id
289: , group_id
290: , resource_id

Line 600: delete from jtf_tty_terr_grp_owners

596: WHERE terr_group_id = p_terr_gp_id;
597:
598:
599: /* delete all the terr gp owners, access and product */
600: delete from jtf_tty_terr_grp_owners
601: where terr_group_id = p_terr_gp_id;
602:
603: delete from jtf_tty_role_prod_int
604: where terr_group_role_id in

Line 750: FROM jtf_tty_terr_grp_owners tgo

746: p_user_id,
747: sysdate,
748: p_user_id,
749: sysdate
750: FROM jtf_tty_terr_grp_owners tgo
751: WHERE tgo.terr_group_id = p_terr_gp_id;
752:
753: COMMIT;
754: END create_grp_geo_terr;

Line 842: FROM jtf_tty_terr_grp_owners tgo

838: AND gt.geo_territory_id = gtr.geo_territory_id
839: AND gt.owner_resource_id = -999
840: AND gtr.rsc_group_id
841: NOT IN (SELECT tgo.rsc_group_id
842: FROM jtf_tty_terr_grp_owners tgo
843: WHERE tgo.terr_group_id = p_terr_gp_id);
844:
845: CURSOR replaced_owners_c IS
846: SELECT tgo1.resource_id new_owner_resource_id,

Line 853: jtf_tty_terr_grp_owners tgo1

849: gtr.geo_territory_id,
850: gtr.resource_id replaced_owner_resource_id
851: FROM jtf_tty_geo_terr_rsc gtr,
852: jtf_tty_geo_terr gt,
853: jtf_tty_terr_grp_owners tgo1
854: WHERE gt.terr_group_id = p_terr_gp_id
855: AND gt.geo_territory_id = gtr.geo_territory_id
856: AND gt.owner_resource_id = -999
857: and tgo1.terr_group_id = p_terr_gp_id

Line 866: FROM JTF_TTY_TERR_GRP_OWNERS tgo,

862: SELECT tgo.resource_id,
863: tgo.rsc_group_id,
864: tgo.rsc_role_code,
865: gt.geo_territory_id
866: FROM JTF_TTY_TERR_GRP_OWNERS tgo,
867: jtf_tty_geo_terr gt
868: WHERE gt.terr_group_id = p_terr_gp_id
869: AND tgo.terr_group_id = p_terr_gp_id
870: AND gt.owner_resource_id = -999