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_ALIGN_WEBADI_INT_PKG dependencies on JTF_TTY_PTERR_ACCTS

Line 181: JTF_TTY_PTERR_ACCTS pa,

177: select role_code, MAX(num) num
178: from (
179: select ap.rsc_role_code role_code, count(ap.rsc_role_code) num
180: from JTF_TTY_ALIGN_ACCTS aa,
181: JTF_TTY_PTERR_ACCTS pa,
182: JTF_TTY_ALIGN_PTERR ap
183: -- jtf_rs_roles_vl rol
184: where
185: aa.alignment_id = p_align_id

Line 275: JTF_TTY_PTERR_ACCTS pa,

271: select rsc.resource_name, --ap.resource_id,
272: grp.group_name, --ap.rsc_group_id group_id,
273: rol.role_name, ap.rsc_role_code role_code
274: from JTF_TTY_ALIGN_ACCTS aa,
275: JTF_TTY_PTERR_ACCTS pa,
276: JTF_TTY_ALIGN_PTERR ap,
277: jtf_rs_resource_extns_vl rsc,
278: jtf_rs_groups_vl grp,
279: jtf_rs_roles_vl rol

Line 763: JTF_TTY_PTERR_ACCTS pa,

759: ,sum(am.metric_value) metric_value
760: ,round( (sum(am.metric_value)/ alm.align_metric_val )* 100, 2 ) metric_pct
761: from JTF_TTY_ACCT_METRICS AM,
762: jtf_tty_align_accts ac,
763: JTF_TTY_PTERR_ACCTS pa,
764: jtf_tty_terr_grp_accts ga,
765: jtf_tty_align_pterr ap,
766: ( select sum(ams.metric_value) align_metric_val
767: from jtf_tty_acct_metrics ams

Line 822: JTF_TTY_PTERR_ACCTS pa,

818: ,sum(am.metric_value) metric_value
819: ,round( (sum(am.metric_value)/ alm.align_metric_val )* 100, 2 ) metric_pct
820: from JTF_TTY_ACCT_METRICS AM,
821: jtf_tty_align_accts ac,
822: JTF_TTY_PTERR_ACCTS pa,
823: jtf_tty_terr_grp_accts ga,
824: jtf_tty_align_pterr ap,
825: ( select sum(ams.metric_value) align_metric_val
826: from jtf_tty_acct_metrics ams

Line 880: JTF_TTY_PTERR_ACCTS pa,

876: from (select pa.align_proposed_terr_id pterr_id
877: ,count(pa.align_acct_id) metric_value
878: ,round( (count(pa.align_acct_id)/ alm.tot_align_metric_val )* 100, 2 ) metric_pct
879: from
880: JTF_TTY_PTERR_ACCTS pa,
881: jtf_tty_align_pterr ap,
882: ( select count(ala.terr_group_account_id) tot_align_metric_val
883: from jtf_tty_align_accts ala
884: where ala.alignment_id = l_alignment_id

Line 927: JTF_TTY_PTERR_ACCTS pa,

923: ,sum(am.metric_value) metric_value
924: ,round( (sum(am.metric_value)/ alm.align_metric_val )* 100, 2 ) metric_pct
925: from JTF_TTY_ACCT_METRICS AM,
926: jtf_tty_align_accts ac,
927: JTF_TTY_PTERR_ACCTS pa,
928: jtf_tty_terr_grp_accts ga,
929: jtf_tty_align_pterr ap,
930: ( select sum(ams.metric_value) align_metric_val
931: from jtf_tty_acct_metrics ams

Line 992: JTF_TTY_PTERR_ACCTS PA

988:
989: cursor c_all_pterrs (c_align_acct_id NUMBER, c_alignment_id NUMBER ) IS
990: select AA.align_proposed_terr_id
991: from JTF_TTY_ALIGN_PTERR AA,
992: JTF_TTY_PTERR_ACCTS PA
993: where AA.ALIGNMENT_ID = c_alignment_id
994: and AA.ALIGN_PROPOSED_TERR_ID = PA.ALIGN_PROPOSED_TERR_ID
995: and PA.ALIGN_ACCT_ID = c_align_acct_id ;
996:

Line 1147: --insert into tmp2 values('40. insert into JTF_TTY_PTERR_ACCTS, align_rec.align_proposed_terr_id', align_rec.align_proposed_terr_id); commit;

1143: , c_group_id => res_rec.group_id
1144: , c_role_code => res_rec.role_code
1145: , c_alignment_id => l_alignment_id)
1146: LOOP
1147: --insert into tmp2 values('40. insert into JTF_TTY_PTERR_ACCTS, align_rec.align_proposed_terr_id', align_rec.align_proposed_terr_id); commit;
1148: --populate JTF_TTY_PTERR_ACCTS
1149: insert into JTF_TTY_PTERR_ACCTS
1150: ( align_pterr_acct_id
1151: ,object_version_number

Line 1148: --populate JTF_TTY_PTERR_ACCTS

1144: , c_role_code => res_rec.role_code
1145: , c_alignment_id => l_alignment_id)
1146: LOOP
1147: --insert into tmp2 values('40. insert into JTF_TTY_PTERR_ACCTS, align_rec.align_proposed_terr_id', align_rec.align_proposed_terr_id); commit;
1148: --populate JTF_TTY_PTERR_ACCTS
1149: insert into JTF_TTY_PTERR_ACCTS
1150: ( align_pterr_acct_id
1151: ,object_version_number
1152: ,align_proposed_terr_id

Line 1149: insert into JTF_TTY_PTERR_ACCTS

1145: , c_alignment_id => l_alignment_id)
1146: LOOP
1147: --insert into tmp2 values('40. insert into JTF_TTY_PTERR_ACCTS, align_rec.align_proposed_terr_id', align_rec.align_proposed_terr_id); commit;
1148: --populate JTF_TTY_PTERR_ACCTS
1149: insert into JTF_TTY_PTERR_ACCTS
1150: ( align_pterr_acct_id
1151: ,object_version_number
1152: ,align_proposed_terr_id
1153: ,align_acct_id

Line 1160: ( JTF_TTY_PTERR_ACCTS_S.nextval

1156: ,last_updated_by
1157: ,last_update_date
1158: ,last_update_login
1159: ) values
1160: ( JTF_TTY_PTERR_ACCTS_S.nextval
1161: ,1
1162: ,align_rec.align_proposed_terr_id
1163: ,all_align_accts_tbl(j)
1164: ,G_USER

Line 1171: --insert into tmp2 values('50. END OF: insert into JTF_TTY_PTERR_ACCTS, align_rec.align_proposed_terr_id', align_rec.align_proposed_terr_id); commit;

1167: ,l_sysdate
1168: ,G_LOGIN
1169: );
1170: l_found := TRUE;
1171: --insert into tmp2 values('50. END OF: insert into JTF_TTY_PTERR_ACCTS, align_rec.align_proposed_terr_id', align_rec.align_proposed_terr_id); commit;
1172: END LOOP;
1173: IF ( NOT l_found )
1174: THEN
1175: /* Get all user's directs which have the resource in their hierarchy */

Line 1184: --insert into tmp2 values('40. insert into JTF_TTY_PTERR_ACCTS, align_rec.align_proposed_terr_id', align_rec.align_proposed_terr_id); commit;

1180: , c_group_id => direct_rec.group_id
1181: , c_role_code => direct_rec.role_code
1182: , c_alignment_id => l_alignment_id )
1183: LOOP
1184: --insert into tmp2 values('40. insert into JTF_TTY_PTERR_ACCTS, align_rec.align_proposed_terr_id', align_rec.align_proposed_terr_id); commit;
1185: --populate JTF_TTY_PTERR_ACCTS
1186:
1187: l_pterr_accts_num := 0;
1188:

Line 1185: --populate JTF_TTY_PTERR_ACCTS

1181: , c_role_code => direct_rec.role_code
1182: , c_alignment_id => l_alignment_id )
1183: LOOP
1184: --insert into tmp2 values('40. insert into JTF_TTY_PTERR_ACCTS, align_rec.align_proposed_terr_id', align_rec.align_proposed_terr_id); commit;
1185: --populate JTF_TTY_PTERR_ACCTS
1186:
1187: l_pterr_accts_num := 0;
1188:
1189: select count(*)

Line 1191: from jtf_tty_pterr_accts

1187: l_pterr_accts_num := 0;
1188:
1189: select count(*)
1190: into l_pterr_accts_num
1191: from jtf_tty_pterr_accts
1192: where align_proposed_terr_id = align_pterr_rec.align_proposed_terr_id
1193: and align_acct_id = all_align_accts_tbl(j);
1194:
1195: IF l_pterr_accts_num < 1

Line 1197: insert into JTF_TTY_PTERR_ACCTS

1193: and align_acct_id = all_align_accts_tbl(j);
1194:
1195: IF l_pterr_accts_num < 1
1196: THEN
1197: insert into JTF_TTY_PTERR_ACCTS
1198: ( align_pterr_acct_id
1199: ,object_version_number
1200: ,align_proposed_terr_id
1201: ,align_acct_id

Line 1208: ( JTF_TTY_PTERR_ACCTS_S.nextval

1204: ,last_updated_by
1205: ,last_update_date
1206: ,last_update_login
1207: ) values
1208: ( JTF_TTY_PTERR_ACCTS_S.nextval
1209: ,1
1210: ,align_pterr_rec.align_proposed_terr_id
1211: ,all_align_accts_tbl(j)
1212: ,G_USER

Line 1219: --insert into tmp2 values('50. END OF: insert into JTF_TTY_PTERR_ACCTS, align_rec.align_proposed_terr_id', align_rec.align_proposed_terr_id); commit;

1215: ,l_sysdate
1216: ,G_LOGIN
1217: );
1218: END IF;
1219: --insert into tmp2 values('50. END OF: insert into JTF_TTY_PTERR_ACCTS, align_rec.align_proposed_terr_id', align_rec.align_proposed_terr_id); commit;
1220: END LOOP; -- end align_rec
1221: END LOOP; -- end direct_rec
1222: END IF; -- end not found
1223: END LOOP; -- end res_rec

Line 1341: from jtf_tty_pterr_accts

1337: l_pterr_accts_num := 0;
1338:
1339: select count(*)
1340: into l_pterr_accts_num
1341: from jtf_tty_pterr_accts
1342: where align_proposed_terr_id = l_align_pterr_id
1343: and align_acct_id = l_align_acct_id
1344: and rownum < 2;
1345:

Line 1350: insert into JTF_TTY_PTERR_ACCTS

1346: if l_pterr_accts_num < 1
1347: then
1348: --insert into tmp2 values('3. b4 create pterr accts. l_align_pterr_id, l_align_acct_id =', l_align_pterr_id||' '||l_align_acct_id); commit;
1349:
1350: insert into JTF_TTY_PTERR_ACCTS
1351: ( align_pterr_acct_id
1352: ,object_version_number
1353: ,align_proposed_terr_id
1354: ,align_acct_id

Line 1361: ( JTF_TTY_PTERR_ACCTS_S.nextval

1357: ,last_updated_by
1358: ,last_update_date
1359: ,last_update_login
1360: ) values
1361: ( JTF_TTY_PTERR_ACCTS_S.nextval
1362: ,1
1363: ,l_align_pterr_id
1364: ,l_align_acct_id
1365: ,G_USER

Line 1433: delete from JTF_TTY_PTERR_ACCTS

1429: if l_align_pterr_id is null then
1430: exit;
1431: end if;
1432:
1433: delete from JTF_TTY_PTERR_ACCTS
1434: where align_proposed_terr_id = l_align_pterr_id
1435: and align_acct_id = l_align_acct_id;
1436:
1437: IF SQL%ROWCOUNT > 0

Line 1497: delete from jtf_tty_pterr_accts

1493: and repdn.current_user_id = l_user_id
1494: )
1495: );
1496:
1497: delete from jtf_tty_pterr_accts
1498: where align_proposed_terr_id IN
1499: ( select align_proposed_terr_id
1500: from jtf_tty_align_pterr
1501: where alignment_id = l_alignment_id )