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.

APPS.JTF_TTY_GEN_TERR_PVT dependencies on JTF_TTY_ROLE_ACCESS

Line 1000: , jtf_tty_role_access ra

996: FROM
997: JTF_TTY_GEO_TERR_RSC grsc
998: , jtf_tty_geo_terr gtr
999: , jtf_tty_terr_grp_roles tgr
1000: , jtf_tty_role_access ra
1001: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id
1002: AND gtr.geo_territory_id = grsc.geo_territory_id
1003: AND grsc.rsc_role_code = tgr.role_code
1004: AND tgr.terr_group_id = gtr.terr_group_id

Line 1013: , jtf_tty_role_access ra

1009: FROM
1010: JTF_TTY_GEO_TERR_RSC grsc
1011: , jtf_tty_geo_terr gtr
1012: , jtf_tty_terr_grp_roles tgr
1013: , jtf_tty_role_access ra
1014: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id
1015: AND gtr.geo_territory_id = grsc.geo_territory_id
1016: AND grsc.rsc_role_code = tgr.role_code
1017: AND tgr.terr_group_id = gtr.terr_group_id

Line 1152: FROM jtf_tty_role_access a

1148: /* Access Types for a particular Role within a Territory Group */
1149: CURSOR NON_OVLY_role_access( lp_terr_group_id NUMBER
1150: , lp_role VARCHAR2) IS
1151: SELECT DISTINCT a.access_type
1152: FROM jtf_tty_role_access a
1153: , jtf_tty_terr_grp_roles b
1154: WHERE a.terr_group_role_id = b.terr_group_role_id
1155: AND b.terr_group_id = lp_terr_group_id
1156: AND b.role_code = lp_role

Line 1267: FROM jtf_tty_role_access a

1263:
1264: /* Access Types for a particular Role within a Territory Group */
1265: CURSOR role_access(l_terr_group_id NUMBER,l_role VARCHAR2) IS
1266: SELECT DISTINCT a.access_type
1267: FROM jtf_tty_role_access a
1268: , jtf_tty_terr_grp_roles b
1269: WHERE a.terr_group_role_id = b.terr_group_role_id
1270: AND b.terr_group_id = l_terr_group_id
1271: AND b.role_code = l_role

Line 1289: FROM jtf_tty_role_access a

1285: /* get those roles for a territory Group that
1286: ** do not have Product Interest defined */
1287: CURSOR role_no_pi(l_terr_group_id NUMBER) IS
1288: SELECT DISTINCT b.role_code
1289: FROM jtf_tty_role_access a
1290: , jtf_tty_terr_grp_roles b
1291: , jtf_tty_role_prod_int c
1292: WHERE a.terr_group_role_id = b.terr_group_role_id
1293: AND b.terr_group_id = l_terr_group_id

Line 1355: INSERT INTO JTF_TTY_ROLE_ACCESS(

1351: , G_USER_ID
1352: , SYSDATE
1353: , G_LOGIN_ID);
1354:
1355: INSERT INTO JTF_TTY_ROLE_ACCESS(
1356: TERR_GROUP_ROLE_ACCESS_ID
1357: , OBJECT_VERSION_NUMBER
1358: , TERR_GROUP_ROLE_ID
1359: , ACCESS_TYPE

Line 1366: JTF_TTY_ROLE_ACCESS_S.NEXTVAL

1362: , LAST_UPDATED_BY
1363: , LAST_UPDATE_DATE
1364: , LAST_UPDATE_LOGIN)
1365: VALUES(
1366: JTF_TTY_ROLE_ACCESS_S.NEXTVAL
1367: , 1
1368: , l_overnon_role_tbl(i).grp_role_id
1369: , 'ACCOUNT'
1370: , G_USER_ID

Line 1754: DELETE FROM jtf_tty_role_access

1750: FOR i IN l_overnon_role_tbl.first.. l_overnon_role_tbl.last LOOP
1751: DELETE FROM jtf_tty_terr_grp_roles
1752: WHERE TERR_GROUP_ROLE_ID=l_overnon_role_tbl(i).grp_role_id;
1753:
1754: DELETE FROM jtf_tty_role_access
1755: WHERE TERR_GROUP_ROLE_ID=l_overnon_role_tbl(i).grp_role_id;
1756: END LOOP;
1757: END IF;
1758:

Line 2501: , jtf_tty_role_access ra

2497: FROM
2498: JTF_TTY_GEO_TERR_RSC grsc
2499: , jtf_tty_geo_terr gtr
2500: , jtf_tty_terr_grp_roles tgr
2501: , jtf_tty_role_access ra
2502: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id
2503: AND gtr.geo_territory_id = grsc.geo_territory_id
2504: AND grsc.rsc_role_code = tgr.role_code
2505: AND tgr.terr_group_id = gtr.terr_group_id

Line 2514: , jtf_tty_role_access ra

2510: FROM
2511: JTF_TTY_GEO_TERR_RSC grsc
2512: , jtf_tty_geo_terr gtr
2513: , jtf_tty_terr_grp_roles tgr
2514: , jtf_tty_role_access ra
2515: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id
2516: AND gtr.geo_territory_id = grsc.geo_territory_id
2517: AND grsc.rsc_role_code = tgr.role_code
2518: AND tgr.terr_group_id = gtr.terr_group_id

Line 2653: FROM jtf_tty_role_access a

2649: /* Access Types for a particular Role within a Territory Group */
2650: CURSOR NON_OVLY_role_access( lp_terr_group_id NUMBER
2651: , lp_role VARCHAR2) IS
2652: SELECT DISTINCT a.access_type
2653: FROM jtf_tty_role_access a
2654: , jtf_tty_terr_grp_roles b
2655: WHERE a.terr_group_role_id = b.terr_group_role_id
2656: AND b.terr_group_id = lp_terr_group_id
2657: AND b.role_code = lp_role

Line 2768: FROM jtf_tty_role_access a

2764:
2765: /* Access Types for a particular Role within a Territory Group */
2766: CURSOR role_access(l_terr_group_id NUMBER,l_role VARCHAR2) IS
2767: SELECT DISTINCT a.access_type
2768: FROM jtf_tty_role_access a
2769: , jtf_tty_terr_grp_roles b
2770: WHERE a.terr_group_role_id = b.terr_group_role_id
2771: AND b.terr_group_id = l_terr_group_id
2772: AND b.role_code = l_role

Line 2790: FROM jtf_tty_role_access a

2786: /* get those roles for a territory Group that
2787: ** do not have Product Interest defined */
2788: CURSOR role_no_pi(l_terr_group_id NUMBER) IS
2789: SELECT DISTINCT b.role_code
2790: FROM jtf_tty_role_access a
2791: , jtf_tty_terr_grp_roles b
2792: , jtf_tty_role_prod_int c
2793: WHERE a.terr_group_role_id = b.terr_group_role_id
2794: AND b.terr_group_id = l_terr_group_id

Line 2870: INSERT INTO JTF_TTY_ROLE_ACCESS(

2866: , G_USER_ID
2867: , SYSDATE
2868: , G_LOGIN_ID);
2869:
2870: INSERT INTO JTF_TTY_ROLE_ACCESS(
2871: TERR_GROUP_ROLE_ACCESS_ID
2872: , OBJECT_VERSION_NUMBER
2873: , TERR_GROUP_ROLE_ID
2874: , ACCESS_TYPE

Line 2881: JTF_TTY_ROLE_ACCESS_S.NEXTVAL

2877: , LAST_UPDATED_BY
2878: , LAST_UPDATE_DATE
2879: , LAST_UPDATE_LOGIN)
2880: VALUES(
2881: JTF_TTY_ROLE_ACCESS_S.NEXTVAL
2882: , 1
2883: , l_overnon_role_tbl(i).grp_role_id
2884: , 'ACCOUNT'
2885: , G_USER_ID

Line 3420: DELETE FROM jtf_tty_role_access

3416: FOR i IN l_overnon_role_tbl.first.. l_overnon_role_tbl.last LOOP
3417: DELETE FROM jtf_tty_terr_grp_roles
3418: WHERE TERR_GROUP_ROLE_ID=l_overnon_role_tbl(i).grp_role_id;
3419:
3420: DELETE FROM jtf_tty_role_access
3421: WHERE TERR_GROUP_ROLE_ID=l_overnon_role_tbl(i).grp_role_id;
3422: END LOOP;
3423: END IF;
3424:

Line 4373: , jtf_tty_role_access ra

4369: FROM
4370: jtf_tty_named_acct_rsc nar
4371: , jtf_tty_terr_grp_accts tga
4372: , jtf_tty_terr_grp_roles tgr
4373: , jtf_tty_role_access ra
4374: WHERE tga.terr_group_account_id = nar.terr_group_account_id
4375: AND nar.terr_group_account_id = LP_terr_group_account_id
4376: AND tga.terr_group_id = tgr.terr_group_id
4377: AND nar.rsc_role_code = tgr.role_code

Line 4386: , jtf_tty_role_access ra

4382: FROM
4383: jtf_tty_named_acct_rsc nar
4384: , jtf_tty_terr_grp_accts tga
4385: , jtf_tty_terr_grp_roles tgr
4386: , jtf_tty_role_access ra
4387: WHERE tga.terr_group_account_id = nar.terr_group_account_id
4388: AND nar.terr_group_account_id = LP_terr_group_account_id
4389: AND tga.terr_group_id = tgr.terr_group_id
4390: AND nar.rsc_role_code = tgr.role_code

Line 4401: FROM jtf_tty_role_access a

4397:
4398: /* Access Types for a particular Role within a Territory Group */
4399: CURSOR role_access(l_terr_group_id NUMBER,l_role VARCHAR2) IS
4400: SELECT DISTINCT a.access_type
4401: FROM jtf_tty_role_access a
4402: , jtf_tty_terr_grp_roles b
4403: WHERE a.terr_group_role_id = b.terr_group_role_id
4404: AND b.terr_group_id = l_terr_group_id
4405: AND b.role_code = l_role

Line 4412: FROM jtf_tty_role_access a

4408: /* Access Types for a particular Role within a Territory Group */
4409: CURSOR NON_OVLY_role_access( lp_terr_group_id NUMBER
4410: , lp_role VARCHAR2) IS
4411: SELECT DISTINCT a.access_type, a.trans_access_code
4412: FROM jtf_tty_role_access a
4413: , jtf_tty_terr_grp_roles b
4414: WHERE a.terr_group_role_id = b.terr_group_role_id
4415: AND b.terr_group_id = lp_terr_group_id
4416: AND b.role_code = lp_role

Line 4637: FROM jtf_tty_role_access a

4633:
4634: /* Access Types for a Territory Group */
4635: CURSOR na_access(l_terr_group_id NUMBER) IS
4636: SELECT DISTINCT a.access_type
4637: FROM jtf_tty_role_access a
4638: , jtf_tty_terr_grp_roles b
4639: WHERE a.terr_group_role_id = b.terr_group_role_id
4640: AND b.terr_group_id = l_terr_group_id;
4641:

Line 4646: FROM jtf_tty_role_access a

4642: /* get those roles for a territory Group that
4643: ** do not have Product Interest defined */
4644: CURSOR role_no_pi(l_terr_group_id NUMBER) IS
4645: SELECT DISTINCT b.role_code
4646: FROM jtf_tty_role_access a
4647: , jtf_tty_terr_grp_roles b
4648: , jtf_tty_role_prod_int c
4649: WHERE a.terr_group_role_id = b.terr_group_role_id
4650: AND b.terr_group_id = l_terr_group_id

Line 4728: INSERT INTO JTF_TTY_ROLE_ACCESS(

4724: , G_USER_ID
4725: , SYSDATE
4726: , G_LOGIN_ID);
4727:
4728: INSERT INTO JTF_TTY_ROLE_ACCESS(
4729: TERR_GROUP_ROLE_ACCESS_ID
4730: , OBJECT_VERSION_NUMBER
4731: , TERR_GROUP_ROLE_ID
4732: , ACCESS_TYPE

Line 4739: JTF_TTY_ROLE_ACCESS_S.NEXTVAL

4735: , LAST_UPDATED_BY
4736: , LAST_UPDATE_DATE
4737: , LAST_UPDATE_LOGIN)
4738: VALUES(
4739: JTF_TTY_ROLE_ACCESS_S.NEXTVAL
4740: , 1
4741: , l_overnon_role_tbl(i).grp_role_id
4742: , 'ACCOUNT'
4743: , G_USER_ID

Line 5653: DELETE FROM jtf_tty_role_access

5649: LOOP
5650: DELETE FROM jtf_tty_terr_grp_roles
5651: WHERE TERR_GROUP_ROLE_ID=l_overnon_role_tbl(i).grp_role_id;
5652: --dbms_output.put_line('deleted');
5653: DELETE FROM jtf_tty_role_access
5654: WHERE TERR_GROUP_ROLE_ID=l_overnon_role_tbl(i).grp_role_id;
5655: END LOOP;
5656: END IF;
5657:

Line 7079: , jtf_tty_role_access ra

7075: FROM
7076: jtf_tty_named_acct_rsc nar
7077: , jtf_tty_terr_grp_accts tga
7078: , jtf_tty_terr_grp_roles tgr
7079: , jtf_tty_role_access ra
7080: WHERE tga.terr_group_account_id = nar.terr_group_account_id
7081: AND nar.terr_group_account_id = LP_terr_group_account_id
7082: AND tga.terr_group_id = tgr.terr_group_id
7083: AND nar.rsc_role_code = tgr.role_code

Line 7092: , jtf_tty_role_access ra

7088: FROM
7089: jtf_tty_named_acct_rsc nar
7090: , jtf_tty_terr_grp_accts tga
7091: , jtf_tty_terr_grp_roles tgr
7092: , jtf_tty_role_access ra
7093: WHERE tga.terr_group_account_id = nar.terr_group_account_id
7094: AND nar.terr_group_account_id = LP_terr_group_account_id
7095: AND tga.terr_group_id = tgr.terr_group_id
7096: AND nar.rsc_role_code = tgr.role_code

Line 7107: FROM jtf_tty_role_access a

7103:
7104: /* Access Types for a particular Role within a Territory Group */
7105: CURSOR role_access(l_terr_group_id NUMBER,l_role VARCHAR2) IS
7106: SELECT DISTINCT a.access_type
7107: FROM jtf_tty_role_access a
7108: , jtf_tty_terr_grp_roles b
7109: WHERE a.terr_group_role_id = b.terr_group_role_id
7110: AND b.terr_group_id = l_terr_group_id
7111: AND b.role_code = l_role

Line 7118: FROM jtf_tty_role_access a

7114: /* Access Types for a particular Role within a Territory Group */
7115: CURSOR NON_OVLY_role_access( lp_terr_group_id NUMBER
7116: , lp_role VARCHAR2) IS
7117: SELECT DISTINCT a.access_type, a.trans_access_code
7118: FROM jtf_tty_role_access a
7119: , jtf_tty_terr_grp_roles b
7120: WHERE a.terr_group_role_id = b.terr_group_role_id
7121: AND b.terr_group_id = lp_terr_group_id
7122: AND b.role_code = lp_role

Line 7402: FROM jtf_tty_role_access a

7398:
7399: /* Access Types for a Territory Group */
7400: CURSOR na_access(l_terr_group_id NUMBER) IS
7401: SELECT DISTINCT a.access_type
7402: FROM jtf_tty_role_access a
7403: , jtf_tty_terr_grp_roles b
7404: WHERE a.terr_group_role_id = b.terr_group_role_id
7405: AND b.terr_group_id = l_terr_group_id;
7406:

Line 7459: FROM jtf_tty_role_access a

7455: /* get those roles for a territory Group that
7456: ** do not have Product Interest defined */
7457: CURSOR role_no_pi(l_terr_group_id NUMBER) IS
7458: SELECT DISTINCT b.role_code
7459: FROM jtf_tty_role_access a
7460: , jtf_tty_terr_grp_roles b
7461: , jtf_tty_role_prod_int c
7462: WHERE a.terr_group_role_id = b.terr_group_role_id
7463: AND b.terr_group_id = l_terr_group_id

Line 7543: INSERT INTO JTF_TTY_ROLE_ACCESS(

7539: , G_USER_ID
7540: , SYSDATE
7541: , G_LOGIN_ID);
7542:
7543: INSERT INTO JTF_TTY_ROLE_ACCESS(
7544: TERR_GROUP_ROLE_ACCESS_ID
7545: , OBJECT_VERSION_NUMBER
7546: , TERR_GROUP_ROLE_ID
7547: , ACCESS_TYPE

Line 7554: JTF_TTY_ROLE_ACCESS_S.NEXTVAL

7550: , LAST_UPDATED_BY
7551: , LAST_UPDATE_DATE
7552: , LAST_UPDATE_LOGIN)
7553: VALUES(
7554: JTF_TTY_ROLE_ACCESS_S.NEXTVAL
7555: , 1
7556: , l_overnon_role_tbl(i).grp_role_id
7557: , 'ACCOUNT'
7558: , G_USER_ID

Line 8868: DELETE FROM jtf_tty_role_access

8864: LOOP
8865: DELETE FROM jtf_tty_terr_grp_roles
8866: WHERE TERR_GROUP_ROLE_ID=l_overnon_role_tbl(i).grp_role_id;
8867: --dbms_output.put_line('deleted');
8868: DELETE FROM jtf_tty_role_access
8869: WHERE TERR_GROUP_ROLE_ID=l_overnon_role_tbl(i).grp_role_id;
8870: END LOOP;
8871: END IF;
8872:

Line 12683: FROM jtf_tty_role_access a

12679:
12680: /* Access Types for a particular Role within a Territory Group */
12681: CURSOR role_access(l_terr_group_id NUMBER,l_role VARCHAR2) IS
12682: SELECT DISTINCT a.access_type, a.trans_access_code
12683: FROM jtf_tty_role_access a
12684: , jtf_tty_terr_grp_roles b
12685: WHERE a.terr_group_role_id = b.terr_group_role_id
12686: AND b.terr_group_id = l_terr_group_id
12687: AND b.role_code = l_role

Line 12922: FROM jtf_tty_role_access a

12918:
12919: /* Access Types for a particular Role within a Territory Group */
12920: CURSOR role_access(l_terr_group_id NUMBER,l_role VARCHAR2) IS
12921: SELECT DISTINCT a.access_type, a.trans_access_code
12922: FROM jtf_tty_role_access a
12923: , jtf_tty_terr_grp_roles b
12924: WHERE a.terr_group_role_id = b.terr_group_role_id
12925: AND b.terr_group_id = l_terr_group_id
12926: AND b.role_code = l_role