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.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTF_TERR_VALUES_ALL

Line 4159: DELETE from JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID IN

4155: if l_del_terr_rec.terr_id.count > 0 then
4156: BEGIN
4157: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
4158: --Delete Territory Values
4159: DELETE from JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID IN
4160: ( SELECT TERR_QUAL_ID FROM JTF_TERR_QUAL_ALL
4161: WHERE TERR_ID = l_del_terr_rec.terr_id(i) );
4162:
4163: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last

Line 4225: DELETE FROM JTF_TERR_VALUES_ALL

4221:
4222: if l_del_qual_val_rec.qual_value_id.count > 0 then
4223: BEGIN
4224: FORALL i in l_del_qual_val_rec.qual_value_id.first..l_del_qual_val_rec.qual_value_id.last
4225: DELETE FROM JTF_TERR_VALUES_ALL
4226: WHERE TERR_VALUE_ID = l_del_qual_val_rec.qual_value_id(i);
4227:
4228: FOR l_del_qual_rec in get_del_qual_csr(p_user_sequence, p_action_flag, p_intf_type, l_header)
4229: Loop

Line 4230: SELECT COUNT(*) INTO l_qual_values_count FROM JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID = l_del_qual_rec.terr_qual_id;

4226: WHERE TERR_VALUE_ID = l_del_qual_val_rec.qual_value_id(i);
4227:
4228: FOR l_del_qual_rec in get_del_qual_csr(p_user_sequence, p_action_flag, p_intf_type, l_header)
4229: Loop
4230: SELECT COUNT(*) INTO l_qual_values_count FROM JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID = l_del_qual_rec.terr_qual_id;
4231: IF l_qual_values_count = 0 THEN
4232: DELETE from JTF_TERR_QUAL_ALL jtq
4233: WHERE jtq.terr_qual_id = l_del_qual_rec.terr_qual_id;
4234: END IF;

Line 4382: FROM jtf_terr_values_all

4378: LOOP
4379: BEGIN
4380: SELECT 'X'
4381: INTO l_dummy
4382: FROM jtf_terr_values_all
4383: WHERE terr_qual_id = l_terr_values_rec.terr_qual_id(i)
4384: AND nvl(comparison_operator, '-9999') = nvl(l_terr_values_rec.comparison_operator(i), '-9999')
4385: AND nvl(low_value_char, '-9999') = nvl(l_terr_values_rec.low_value_char(i), '-9999')
4386: AND nvl(high_value_char, '-9999') = nvl(l_terr_values_rec.high_value_char(i), '-9999')

Line 4440: FROM jtf_terr_values_all

4436:
4437: Begin
4438: SELECT 'X'
4439: INTO l_dummy
4440: FROM jtf_terr_values_all
4441: WHERE TERR_VALUE_ID <> l_terr_values_rec.TERR_VALUE_ID(i)
4442: AND terr_qual_id = l_terr_values_rec.terr_qual_id(i)
4443: AND nvl(comparison_operator, '-9999') = nvl(l_terr_values_rec.comparison_operator(i), '-9999')
4444: AND nvl(low_value_char, '-9999') = nvl(l_terr_values_rec.low_value_char(i), '-9999')

Line 4628: INSERT INTO JTF_TERR_VALUES_ALL(

4624:
4625:
4626: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
4627: forall i in l_Terr_Values_Rec.TERR_QUAL_ID.first..l_Terr_Values_Rec.TERR_QUAL_ID.last
4628: INSERT INTO JTF_TERR_VALUES_ALL(
4629: TERR_VALUE_ID,
4630: LAST_UPDATED_BY,
4631: LAST_UPDATE_DATE,
4632: CREATED_BY,

Line 4681: delete from jtf_terr_qual_all where terr_id = l_terr_qual_rec.TERR_ID(i) and terr_qual_id not in (select terr_qual_id from jtf_terr_values_all);

4677: p_terr_values_out_rec.TERR_QUAL_ID;
4678:
4679:
4680: forall i in l_terr_qual_rec.TERR_ID.first..l_terr_qual_rec.TERR_ID.last
4681: delete from jtf_terr_qual_all where terr_id = l_terr_qual_rec.TERR_ID(i) and terr_qual_id not in (select terr_qual_id from jtf_terr_values_all);
4682:
4683: --dbms_output.put_line(' C: get_qual_csr:TV, actual row processed: '||SQL%ROWCOUNT);
4684:
4685: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 10422: Update JTF_TERR_VALUES_ALL

10418: x_msg_data => x_msg_data );
10419:
10420: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
10421: forall i in l_Terr_Values_Rec.TERR_VALUE_ID.first..l_Terr_Values_Rec.TERR_VALUE_ID.last
10422: Update JTF_TERR_VALUES_ALL
10423: SET
10424: LAST_UPDATED_BY = l_Terr_Values_Rec.LAST_UPDATED_BY(i),
10425: LAST_UPDATE_DATE = l_Terr_Values_Rec.LAST_UPDATE_DATE(i),
10426: LAST_UPDATE_LOGIN = l_Terr_Values_Rec.LAST_UPDATE_LOGIN(i),

Line 10510: DELETE FROM JTF_TERR_VALUES_ALL

10506: BEGIN
10507: --dbms_output.put_line('U: get_d_terr_value_csr: delete TV, rowcount: ' || l_Terr_Qual_Rec.TERR_QUAL_ID.count);
10508: x_return_status := FND_API.G_RET_STS_SUCCESS;
10509: forall i in l_Terr_Qual_Rec.qual_value_id.first..l_Terr_Qual_Rec.qual_value_id.last
10510: DELETE FROM JTF_TERR_VALUES_ALL
10511: where TERR_VALUE_ID = l_Terr_Qual_Rec.qual_value_id(i);
10512: --dbms_output.put_line(' U: get_d_terr_value_csr:actual row processed: '||SQL%ROWCOUNT);
10513:
10514: forall i in l_Terr_Qual_Rec.TERR_QUAL_ID.first..l_Terr_Qual_Rec.TERR_QUAL_ID.last

Line 10517: ( select 1 from JTF_TERR_VALUES_ALL jtv

10513:
10514: forall i in l_Terr_Qual_Rec.TERR_QUAL_ID.first..l_Terr_Qual_Rec.TERR_QUAL_ID.last
10515: DELETE FROM JTF_TERR_QUAL_ALL jtq
10516: WHERE not exists
10517: ( select 1 from JTF_TERR_VALUES_ALL jtv
10518: where jtv.terr_qual_id = jtq.terr_qual_id)
10519: and jtq.terr_qual_id = l_Terr_Qual_Rec.TERR_QUAL_ID(i);
10520: --dbms_output.put_line(' U: get_d_terr_value_csr:TV, actual row processed: '||SQL%ROWCOUNT);
10521: