APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_TTY_ROLE_ACCESS

Line 475: , jtf_tty_role_access ra

471: FROM
472: jtf_tty_named_acct_rsc nar
473: , jtf_tty_terr_grp_accts tga
474: , jtf_tty_terr_grp_roles tgr
475: , jtf_tty_role_access ra
476: WHERE tga.terr_group_account_id = nar.terr_group_account_id
477: AND nar.terr_group_account_id = LP_terr_group_account_id
478: AND nar.rsc_role_code = tgr.role_code
479: AND ra.terr_group_role_id = tgr.terr_group_role_id

Line 487: , jtf_tty_role_access ra

483: FROM
484: jtf_tty_named_acct_rsc nar
485: , jtf_tty_terr_grp_accts tga
486: , jtf_tty_terr_grp_roles tgr
487: , jtf_tty_role_access ra
488: WHERE tga.terr_group_account_id = nar.terr_group_account_id
489: AND nar.terr_group_account_id = LP_terr_group_account_id
490: AND nar.rsc_role_code = tgr.role_code
491: AND ra.terr_group_role_id = tgr.terr_group_role_id

Line 501: from jtf_tty_role_access a

497:
498: /* Access Types for a Territory Group */
499: CURSOR na_access(l_terr_group_id number) IS
500: SELECT distinct a.access_type
501: from jtf_tty_role_access a
502: , jtf_tty_terr_grp_roles b
503: where a.terr_group_role_id = b.terr_group_role_id
504: and b.terr_group_id = l_terr_group_id;
505:

Line 510: from jtf_tty_role_access a

506: /* Access Types for a particular Role within a Territory Group */
507: CURSOR NON_OVLY_role_access( lp_terr_group_id number
508: , lp_role varchar2) IS
509: SELECT distinct a.access_type
510: from jtf_tty_role_access a
511: , jtf_tty_terr_grp_roles b
512: where a.terr_group_role_id = b.terr_group_role_id
513: and b.terr_group_id = lp_terr_group_id
514: and b.role_code = lp_role

Line 526: from jtf_tty_role_access a

522:
523: /* Access Types for a particular Role within a Territory Group */
524: CURSOR role_access(l_terr_group_id number,l_role varchar2) IS
525: SELECT distinct a.access_type
526: from jtf_tty_role_access a
527: , jtf_tty_terr_grp_roles b
528: where a.terr_group_role_id = b.terr_group_role_id
529: and b.terr_group_id = l_terr_group_id
530: and b.role_code = l_role

Line 781: from jtf_tty_role_access a

777: /* get those roles for a territory Group that
778: ** do not have Product Interest defined */
779: CURSOR role_no_pi(l_terr_group_id number) IS
780: SELECT distinct b.role_code
781: from jtf_tty_role_access a
782: , jtf_tty_terr_grp_roles b
783: , jtf_tty_role_prod_int c
784: where a.terr_group_role_id = b.terr_group_role_id
785: and b.terr_group_id = l_terr_group_id

Line 876: INSERT into JTF_TTY_ROLE_ACCESS(

872: , sysdate
873: , G_USER_ID
874: , sysdate
875: , G_LOGIN_ID);
876: INSERT into JTF_TTY_ROLE_ACCESS(
877: TERR_GROUP_ROLE_ACCESS_ID
878: , OBJECT_VERSION_NUMBER
879: , TERR_GROUP_ROLE_ID
880: , ACCESS_TYPE

Line 887: JTF_TTY_ROLE_ACCESS_S.nextval

883: , LAST_UPDATED_BY
884: , LAST_UPDATE_DATE
885: , LAST_UPDATE_LOGIN)
886: VALUES(
887: JTF_TTY_ROLE_ACCESS_S.nextval
888: , 1
889: , l_overnon_role_tbl(i).grp_role_id
890: , 'ACCOUNT'
891: , G_USER_ID

Line 2232: delete from jtf_tty_role_access

2228: loop
2229: delete from jtf_tty_terr_grp_roles
2230: where TERR_GROUP_ROLE_ID=l_overnon_role_tbl(i).grp_role_id;
2231: --dbms_output.put_line('deleted');
2232: delete from jtf_tty_role_access
2233: where TERR_GROUP_ROLE_ID=l_overnon_role_tbl(i).grp_role_id;
2234: end loop;
2235: end if;
2236: