APPS.JTF_TERR_PKG dependencies on JTF_TERR_ALL

Line 59: CURSOR C IS SELECT rowid FROM JTF_TERR_ALL

55: x_ORG_ID IN NUMBER,
56: x_NUM_WINNERS IN NUMBER,
57: x_NUM_QUAL IN NUMBER
58: ) IS
59: CURSOR C IS SELECT rowid FROM JTF_TERR_ALL
60: WHERE TERR_ID = x_TERR_ID;
61: CURSOR C2 IS SELECT JTF_TERR_s.nextval FROM sys.dual;
62: BEGIN
63: If (x_TERR_ID IS NULL) then

Line 68: INSERT INTO JTF_TERR_ALL(

64: OPEN C2;
65: FETCH C2 INTO x_TERR_ID;
66: CLOSE C2;
67: End If;
68: INSERT INTO JTF_TERR_ALL(
69: TERR_ID,
70: LAST_UPDATE_DATE,
71: LAST_UPDATED_BY,
72: CREATION_DATE,

Line 175: DELETE FROM JTF_TERR_ALL

171:
172: PROCEDURE Delete_Row( x_TERR_ID IN NUMBER
173: ) IS
174: BEGIN
175: DELETE FROM JTF_TERR_ALL
176: WHERE TERR_ID = x_TERR_ID;
177: If (SQL%NOTFOUND) then
178: RAISE NO_DATA_FOUND;
179: End If;

Line 234: Update JTF_TERR_ALL

230: x_NUM_WINNERS IN NUMBER,
231: x_NUM_QUAL IN NUMBER
232: ) IS
233: BEGIN
234: Update JTF_TERR_ALL
235: SET
236: TERR_ID = decode( x_TERR_ID, FND_API.G_MISS_NUM,TERR_ID,x_TERR_ID),
237: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
238: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

Line 341: FROM JTF_TERR_ALL

337: x_NUM_WINNERS IN NUMBER
338: ) IS
339: CURSOR C IS
340: SELECT *
341: FROM JTF_TERR_ALL
342: WHERE TERR_ID = x_TERR_ID
343: FOR UPDATE of TERR_ID NOWAIT;
344: Recinfo C%ROWTYPE;
345: BEGIN