APPS.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTF_TERR_QUAL_ALL

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

1015: v_intf_type varchar2,
1016: v_qual_num number
1017: ) IS
1018: select jtq.terr_qual_id, jwot.lay_seq_num
1019: from JTY_WEBADI_QUAL_HEADER qgt , jtf_terr_qual_all jtq, JTY_WEBADI_OTH_TERR_INTF jwot
1020: WHERE qgt.qual_usg_id = jtq.qual_usg_id
1021: and jtq.org_id = jwot.org_id
1022: AND qgt.user_sequence = jwot.user_sequence
1023: AND jtq.terr_id = jwot.terr_id

Line 1872: ( SELECT TERR_QUAL_ID FROM JTF_TERR_QUAL_ALL

1868: BEGIN
1869: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
1870: --Delete Territory Values
1871: DELETE from JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID IN
1872: ( SELECT TERR_QUAL_ID FROM JTF_TERR_QUAL_ALL
1873: WHERE TERR_ID = l_del_terr_rec.terr_id(i) );
1874:
1875: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
1876: --Delete Territory Qualifer records

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

1873: WHERE TERR_ID = l_del_terr_rec.terr_id(i) );
1874:
1875: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
1876: --Delete Territory Qualifer records
1877: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID = l_del_terr_rec.terr_id(i);
1878:
1879: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
1880: --Delete Territory qual type usgs
1881: DELETE from JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID = l_del_terr_rec.terr_id(i);

Line 1944: DELETE from JTF_TERR_QUAL_ALL jtq

1940: FOR l_del_qual_rec in get_del_qual_csr(p_user_sequence, p_action_flag, p_intf_type, l_header)
1941: Loop
1942: SELECT COUNT(*) INTO l_qual_values_count FROM JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID = l_del_qual_rec.terr_qual_id;
1943: IF l_qual_values_count = 0 THEN
1944: DELETE from JTF_TERR_QUAL_ALL jtq
1945: WHERE jtq.terr_qual_id = l_del_qual_rec.terr_qual_id;
1946: END IF;
1947: END Loop;
1948:

Line 2036: INSERT INTO JTF_TERR_QUAL_ALL(

2032: BEGIN
2033: if (l_Terr_Qual_Rec.TERR_ID.count > 0) then
2034: --dbms_output.put_line('U: get_qual_csr: create MA, rowcount: ' || l_Terr_Qual_Rec.TERR_ID.count);
2035: forall i in l_Terr_Qual_Rec.TERR_ID.first..l_Terr_Qual_Rec.TERR_ID.last
2036: INSERT INTO JTF_TERR_QUAL_ALL(
2037: TERR_QUAL_ID,
2038: LAST_UPDATE_DATE,
2039: LAST_UPDATED_BY,
2040: CREATION_DATE,

Line 4648: DELETE FROM JTF_TERR_QUAL_ALL jtq

4644: where TERR_VALUE_ID = l_Terr_Qual_Rec.qual_value_id(i);
4645: --dbms_output.put_line(' U: get_d_terr_value_csr:actual row processed: '||SQL%ROWCOUNT);
4646:
4647: forall i in l_Terr_Qual_Rec.TERR_QUAL_ID.first..l_Terr_Qual_Rec.TERR_QUAL_ID.last
4648: DELETE FROM JTF_TERR_QUAL_ALL jtq
4649: WHERE not exists
4650: ( select 1 from JTF_TERR_VALUES_ALL jtv
4651: where jtv.terr_qual_id = jtq.terr_qual_id)
4652: and jtq.terr_qual_id = l_Terr_Qual_Rec.TERR_QUAL_ID(i);