APPS.JTF_TERR_VALUES_PKG dependencies on JTF_TERR_VALUES_ALL

Line 39: CURSOR C IS SELECT rowid FROM JTF_TERR_VALUES_ALL

35: x_VALUE2_ID IN NUMBER,
36: x_VALUE3_ID IN NUMBER,
37: x_VALUE4_ID IN NUMBER
38: ) IS
39: CURSOR C IS SELECT rowid FROM JTF_TERR_VALUES_ALL
40: WHERE TERR_VALUE_ID = x_TERR_VALUE_ID;
41: CURSOR C2 IS SELECT JTF_TERR_VALUES_s.nextval FROM sys.dual;
42: BEGIN
43: If (x_TERR_VALUE_ID IS NULL) then

Line 48: INSERT INTO JTF_TERR_VALUES_ALL(

44: OPEN C2;
45: FETCH C2 INTO x_TERR_VALUE_ID;
46: CLOSE C2;
47: End If;
48: INSERT INTO JTF_TERR_VALUES_ALL(
49: TERR_VALUE_ID,
50: LAST_UPDATED_BY,
51: LAST_UPDATE_DATE,
52: CREATED_BY,

Line 117: DELETE FROM JTF_TERR_VALUES_ALL

113:
114: PROCEDURE Delete_Row( x_TERR_VALUE_ID IN NUMBER
115: ) IS
116: BEGIN
117: DELETE FROM JTF_TERR_VALUES_ALL
118: WHERE TERR_VALUE_ID = x_TERR_VALUE_ID;
119: If (SQL%NOTFOUND) then
120: RAISE NO_DATA_FOUND;
121: End If;

Line 156: Update JTF_TERR_VALUES_ALL

152: x_VALUE3_ID IN NUMBER,
153: x_VALUE4_ID IN NUMBER
154: ) IS
155: BEGIN
156: Update JTF_TERR_VALUES_ALL
157: SET
158: TERR_VALUE_ID = decode( x_TERR_VALUE_ID, FND_API.G_MISS_NUM,TERR_VALUE_ID,x_TERR_VALUE_ID),
159: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
160: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),

Line 224: FROM JTF_TERR_VALUES_ALL

220: x_VALUE4_ID IN NUMBER
221: ) IS
222: CURSOR C IS
223: SELECT *
224: FROM JTF_TERR_VALUES_ALL
225: WHERE TERR_VALUE_ID = x_TERR_VALUE_ID
226: FOR UPDATE of TERR_VALUE_ID NOWAIT;
227: Recinfo C%ROWTYPE;
228: BEGIN