APPS.JTF_TERR_RSC_PKG dependencies on JTF_TERR_RSC_ALL

Line 32: CURSOR C IS SELECT rowid FROM JTF_TERR_RSC_ALL

28: x_END_DATE_ACTIVE IN DATE,
29: x_FULL_ACCESS_FLAG IN VARCHAR2,
30: x_ORG_ID IN NUMBER
31: ) IS
32: CURSOR C IS SELECT rowid FROM JTF_TERR_RSC_ALL
33: WHERE TERR_RSC_ID = x_TERR_RSC_ID;
34: CURSOR C2 IS SELECT JTF_TERR_RSC_s.nextval FROM sys.dual;
35: BEGIN
36: If (x_TERR_RSC_ID IS NULL) then

Line 41: INSERT INTO JTF_TERR_RSC_ALL(

37: OPEN C2;
38: FETCH C2 INTO x_TERR_RSC_ID;
39: CLOSE C2;
40: End If;
41: INSERT INTO JTF_TERR_RSC_ALL(
42: TERR_RSC_ID,
43: LAST_UPDATE_DATE,
44: LAST_UPDATED_BY,
45: CREATION_DATE,

Line 120: CURSOR C IS SELECT rowid FROM JTF_TERR_RSC_ALL

116: x_ATTRIBUTE13 IN VARCHAR2,
117: x_ATTRIBUTE14 IN VARCHAR2,
118: x_ATTRIBUTE15 IN VARCHAR2
119: ) IS
120: CURSOR C IS SELECT rowid FROM JTF_TERR_RSC_ALL
121: WHERE TERR_RSC_ID = x_TERR_RSC_ID;
122: CURSOR C2 IS SELECT JTF_TERR_RSC_s.nextval FROM sys.dual;
123: BEGIN
124: If (x_TERR_RSC_ID IS NULL) then

Line 129: INSERT INTO JTF_TERR_RSC_ALL(

125: OPEN C2;
126: FETCH C2 INTO x_TERR_RSC_ID;
127: CLOSE C2;
128: End If;
129: INSERT INTO JTF_TERR_RSC_ALL(
130: TERR_RSC_ID,
131: LAST_UPDATE_DATE,
132: LAST_UPDATED_BY,
133: CREATION_DATE,

Line 208: DELETE FROM JTF_TERR_RSC_ALL

204:
205: PROCEDURE Delete_Row( x_TERR_RSC_ID IN NUMBER
206: ) IS
207: BEGIN
208: DELETE FROM JTF_TERR_RSC_ALL
209: WHERE TERR_RSC_ID = x_TERR_RSC_ID;
210: If (SQL%NOTFOUND) then
211: RAISE NO_DATA_FOUND;
212: End If;

Line 237: Update JTF_TERR_RSC_ALL

233: x_FULL_ACCESS_FLAG IN VARCHAR2,
234: x_ORG_ID IN NUMBER
235: ) IS
236: BEGIN
237: Update JTF_TERR_RSC_ALL
238: SET
239: TERR_RSC_ID = decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM,TERR_RSC_ID,x_TERR_RSC_ID),
240: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
241: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

Line 285: FROM JTF_TERR_RSC_ALL

281: x_ORG_ID IN NUMBER
282: ) IS
283: CURSOR C IS
284: SELECT *
285: FROM JTF_TERR_RSC_ALL
286: WHERE TERR_RSC_ID = x_TERR_RSC_ID
287: FOR UPDATE of TERR_RSC_ID NOWAIT;
288: Recinfo C%ROWTYPE;
289: BEGIN