APPS.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTF_TERR_VALUES_ALL

Line 1871: DELETE from JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID IN

1867: if l_del_terr_rec.terr_id.count > 0 then
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

Line 1937: DELETE FROM JTF_TERR_VALUES_ALL

1933:
1934: if l_del_qual_val_rec.qual_value_id.count > 0 then
1935: BEGIN
1936: FORALL i in l_del_qual_val_rec.qual_value_id.first..l_del_qual_val_rec.qual_value_id.last
1937: DELETE FROM JTF_TERR_VALUES_ALL
1938: WHERE TERR_VALUE_ID = l_del_qual_val_rec.qual_value_id(i);
1939:
1940: FOR l_del_qual_rec in get_del_qual_csr(p_user_sequence, p_action_flag, p_intf_type, l_header)
1941: Loop

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

1938: WHERE TERR_VALUE_ID = l_del_qual_val_rec.qual_value_id(i);
1939:
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;

Line 2208: INSERT INTO JTF_TERR_VALUES_ALL(

2204: l_Terr_Values_Rec.VALUE3_ID(i) );
2205: end loop;
2206: */
2207: forall i in l_Terr_Values_Rec.TERR_QUAL_ID.first..l_Terr_Values_Rec.TERR_QUAL_ID.last
2208: INSERT INTO JTF_TERR_VALUES_ALL(
2209: TERR_VALUE_ID,
2210: LAST_UPDATED_BY,
2211: LAST_UPDATE_DATE,
2212: CREATED_BY,

Line 4580: Update JTF_TERR_VALUES_ALL

4576: end case;
4577: end loop;
4578:
4579: forall i in l_Terr_Values_Rec.TERR_VALUE_ID.first..l_Terr_Values_Rec.TERR_VALUE_ID.last
4580: Update JTF_TERR_VALUES_ALL
4581: SET
4582: LAST_UPDATED_BY = l_Terr_Values_Rec.LAST_UPDATED_BY(i),
4583: LAST_UPDATE_DATE = l_Terr_Values_Rec.LAST_UPDATE_DATE(i),
4584: LAST_UPDATE_LOGIN = l_Terr_Values_Rec.LAST_UPDATE_LOGIN(i),

Line 4643: DELETE FROM JTF_TERR_VALUES_ALL

4639: BEGIN
4640: --dbms_output.put_line('U: get_d_terr_value_csr: delete TV, rowcount: ' || l_Terr_Qual_Rec.TERR_QUAL_ID.count);
4641: x_return_status := FND_API.G_RET_STS_SUCCESS;
4642: forall i in l_Terr_Qual_Rec.qual_value_id.first..l_Terr_Qual_Rec.qual_value_id.last
4643: DELETE FROM JTF_TERR_VALUES_ALL
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

Line 4650: ( select 1 from JTF_TERR_VALUES_ALL jtv

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);
4653: --dbms_output.put_line(' U: get_d_terr_value_csr:TV, actual row processed: '||SQL%ROWCOUNT);
4654: