eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JTF_TTY_GEO_TERRGP dependencies on JTF_TTY_GEO_TERR_RSC

Line 120: delete from jtf_tty_geo_terr_rsc where geo_territory_id = l_geo_terr_id;

116: delete from jtf_tty_geo_grp_values where terr_group_id = l_terr_grp_id;
117:
118: delete from jtf_tty_terr_groups where terr_group_id = l_terr_grp_id;
119:
120: delete from jtf_tty_geo_terr_rsc where geo_territory_id = l_geo_terr_id;
121:
122: delete from jtf_tty_geo_terr where geo_territory_id = l_geo_terr_id;
123:
124:

Line 229: insert into jtf_tty_geo_terr_rsc

225: END;
226:
227: BEGIN
228:
229: insert into jtf_tty_geo_terr_rsc
230: (geo_terr_resource_id,
231: object_version_number,
232: geo_territory_id,
233: resource_id,

Line 243: SELECT jtf_tty_geo_terr_rsc_s.nextval

239: creation_date,
240: last_updated_by,
241: last_update_date,
242: LAST_UPDATE_LOGIN)
243: SELECT jtf_tty_geo_terr_rsc_s.nextval
244: , 1
245: , l_geo_terr_id
246: , resource_id
247: , group_id

Line 584: DELETE from JTF_TTY_GEO_TERR_RSC

580: WHERE t.terr_group_id = p_terr_gp_id);
581:
582: /* delete all the geo territories assignments for the geo terr group */
583:
584: DELETE from JTF_TTY_GEO_TERR_RSC
585: WHERE geo_territory_id IN
586: (SELECT t.geo_territory_id
587: FROM jtf_tty_geo_terr t
588: WHERE t.terr_group_id = p_terr_gp_id);

Line 727: insert into jtf_tty_geo_terr_rsc

723: sysdate,
724: p_user_id,
725: sysdate);
726: /* Assign the top level territory to all the geo terr gp owners */
727: insert into jtf_tty_geo_terr_rsc
728: (geo_terr_resource_id,
729: object_version_number,
730: geo_territory_id,
731: resource_id,

Line 739: SELECT jtf_tty_geo_terr_rsc_s.nextval,

735: created_by,
736: creation_date,
737: last_updated_by,
738: last_update_date)
739: SELECT jtf_tty_geo_terr_rsc_s.nextval,
740: 1,
741: p_geo_territory_id,
742: tgo.resource_id,
743: tgo.rsc_group_id,

Line 835: FROM jtf_tty_geo_terr_rsc gtr,

831: SELECT gtr.resource_id,
832: gtr.rsc_group_id,
833: gtr.rsc_role_code,
834: gtr.geo_territory_id
835: FROM jtf_tty_geo_terr_rsc gtr,
836: jtf_tty_geo_terr gt
837: WHERE gt.terr_group_id = p_terr_gp_id
838: AND gt.geo_territory_id = gtr.geo_territory_id
839: AND gt.owner_resource_id = -999

Line 851: FROM jtf_tty_geo_terr_rsc gtr,

847: gtr.rsc_group_id,
848: gtr.rsc_role_code,
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

Line 873: FROM jtf_tty_geo_terr_rsc gtr

869: AND tgo.terr_group_id = p_terr_gp_id
870: AND gt.owner_resource_id = -999
871: AND (tgo.resource_id, tgo.rsc_group_id, tgo.rsc_role_code)
872: NOT IN (SELECT gtr.resource_id, gtr.rsc_group_id, gtr.rsc_role_code
873: FROM jtf_tty_geo_terr_rsc gtr
874: WHERE gt.geo_territory_id = gtr.geo_territory_id);
875: BEGIN
876: for removed_owners IN removed_owners_c LOOP
877: delete_geo_terr_rsc(removed_owners.geo_territory_id,

Line 936: DELETE from JTF_TTY_GEO_TERR_RSC gtr

932: AND gt1.parent_geo_terr_id = p_territory_id);
933:
934: /* Delete for the geo terrs assignments by the given resource and down
935: * from the given territory */
936: DELETE from JTF_TTY_GEO_TERR_RSC gtr
937: WHERE gtr.geo_territory_id IN
938: (SELECT gt.geo_territory_id
939: FROM JTF_TTY_GEO_TERR gt
940: START WITH gt.geo_territory_id IN

Line 950: DELETE from JTF_TTY_GEO_TERR_RSC gtr

946: AND gt1.parent_geo_terr_id = p_territory_id)
947: CONNECT BY PRIOR gt.geo_territory_id = gt.parent_geo_terr_id);
948: /* Delete geo terrs assignments created by the given resource
949: * from the given territory */
950: DELETE from JTF_TTY_GEO_TERR_RSC gtr
951: WHERE gtr.geo_territory_id IN
952: (SELECT gt1.geo_territory_id
953: FROM JTF_TTY_GEO_TERR gt1
954: WHERE gt1.owner_resource_id = p_resource_id

Line 958: DELETE from JTF_TTY_GEO_TERR_RSC gtr

954: WHERE gt1.owner_resource_id = p_resource_id
955: AND gt1.owner_rsc_group_id = p_rsc_group_id
956: AND gt1.owner_rsc_role_code = p_rsc_role_code
957: AND gt1.parent_geo_terr_id = p_territory_id);
958: DELETE from JTF_TTY_GEO_TERR_RSC gtr
959: WHERE gtr.geo_territory_id = p_territory_id
960: AND gtr.resource_id = p_resource_id
961: AND gtr.rsc_group_id = p_rsc_group_id
962: AND gtr.rsc_role_code = p_rsc_role_code;

Line 1004: insert into jtf_tty_geo_terr_rsc

1000: BEGIN
1001: p_user_id := fnd_global.user_id;
1002:
1003: /* Assign the top level territory to the geo terr gp owner/sales rep */
1004: insert into jtf_tty_geo_terr_rsc
1005: (geo_terr_resource_id,
1006: object_version_number,
1007: geo_territory_id,
1008: resource_id,

Line 1016: VALUES(jtf_tty_geo_terr_rsc_s.nextval,

1012: created_by,
1013: creation_date,
1014: last_updated_by,
1015: last_update_date)
1016: VALUES(jtf_tty_geo_terr_rsc_s.nextval,
1017: 1,
1018: p_territory_id,
1019: p_resource_id,
1020: p_rsc_group_id,

Line 1055: DELETE from JTF_TTY_GEO_TERR_RSC gtr

1051: and owner_resource_id = p_replaced_owner_resource_id;
1052:
1053: -- delete the replaced owner from geo terr assignment
1054: -- the territory is assigned to the new owner by assign geo terr api
1055: DELETE from JTF_TTY_GEO_TERR_RSC gtr
1056: WHERE gtr.geo_territory_id = p_territory_id
1057: AND gtr.resource_id = p_replaced_owner_resource_id
1058: AND gtr.rsc_group_id = p_rsc_group_id
1059: AND gtr.rsc_role_code = p_rsc_role_code;