APPS.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTF_TERR_QUAL_ALL

Line 1895: from JTY_WEBADI_QUAL_HEADER qgt , jtf_terr_qual_all jtq, JTY_WEBADI_OTH_TERR_INTF jwot

1891: v_intf_type varchar2,
1892: v_qual_num number
1893: ) IS
1894: select jtq.terr_qual_id, jwot.lay_seq_num
1895: from JTY_WEBADI_QUAL_HEADER qgt , jtf_terr_qual_all jtq, JTY_WEBADI_OTH_TERR_INTF jwot
1896: WHERE qgt.qual_usg_id = jtq.qual_usg_id
1897: and jtq.org_id = jwot.org_id
1898: AND qgt.user_sequence = jwot.user_sequence
1899: AND jtq.terr_id = jwot.terr_id

Line 4160: ( SELECT TERR_QUAL_ID FROM JTF_TERR_QUAL_ALL

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
4164: --Delete Territory Qualifer records

Line 4165: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID = l_del_terr_rec.terr_id(i);

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
4164: --Delete Territory Qualifer records
4165: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID = l_del_terr_rec.terr_id(i);
4166:
4167: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
4168: --Delete Territory qual type usgs
4169: DELETE from JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID = l_del_terr_rec.terr_id(i);

Line 4232: DELETE from JTF_TERR_QUAL_ALL jtq

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;
4235: END Loop;
4236:

Line 4326: INSERT INTO JTF_TERR_QUAL_ALL(

4322: --x_return_status := FND_API.G_RET_STS_SUCCESS;
4323: if (l_Terr_Qual_Rec.TERR_ID.count > 0) then
4324: --dbms_output.put_line('U: get_qual_csr: create MA, rowcount: ' || l_Terr_Qual_Rec.TERR_ID.count);
4325: forall i in l_Terr_Qual_Rec.TERR_ID.first..l_Terr_Qual_Rec.TERR_ID.last
4326: INSERT INTO JTF_TERR_QUAL_ALL(
4327: TERR_QUAL_ID,
4328: LAST_UPDATE_DATE,
4329: LAST_UPDATED_BY,
4330: CREATION_DATE,

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 10515: DELETE FROM JTF_TERR_QUAL_ALL jtq

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
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);