APPS.JTF_TERR_VALUES_PKG dependencies on JTF_TERR_VALUES_ALL

Line 38: CURSOR C IS SELECT rowid FROM JTF_TERR_VALUES_ALL

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

Line 47: INSERT INTO JTF_TERR_VALUES_ALL(

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

Line 116: DELETE FROM JTF_TERR_VALUES_ALL

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

Line 155: Update JTF_TERR_VALUES_ALL

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

Line 223: FROM JTF_TERR_VALUES_ALL

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