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 598: delete from jtf_tty_terr_grp_owners

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

Line 748: FROM jtf_tty_terr_grp_owners tgo

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

Line 840: FROM jtf_tty_terr_grp_owners tgo

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

Line 851: jtf_tty_terr_grp_owners tgo1

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

Line 864: FROM JTF_TTY_TERR_GRP_OWNERS tgo,

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