APPS.JTF_TERR_RSC_ACCESS_PKG dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 23: CURSOR C IS SELECT rowid FROM JTF_TERR_RSC_ACCESS_ALL

19: x_ACCESS_TYPE IN VARCHAR2,
20: x_TRANS_ACCESS_CODE IN VARCHAR2,
21: x_ORG_ID IN NUMBER
22: ) IS
23: CURSOR C IS SELECT rowid FROM JTF_TERR_RSC_ACCESS_ALL
24: WHERE TERR_RSC_ACCESS_ID = x_TERR_RSC_ACCESS_ID;
25: CURSOR C2 IS SELECT JTF_TERR_RSC_ACCESS_s.nextval FROM sys.dual;
26: BEGIN
27: If (x_TERR_RSC_ACCESS_ID IS NULL) then

Line 32: INSERT INTO JTF_TERR_RSC_ACCESS_ALL(

28: OPEN C2;
29: FETCH C2 INTO x_TERR_RSC_ACCESS_ID;
30: CLOSE C2;
31: End If;
32: INSERT INTO JTF_TERR_RSC_ACCESS_ALL(
33: TERR_RSC_ACCESS_ID,
34: LAST_UPDATE_DATE,
35: LAST_UPDATED_BY,
36: CREATION_DATE,

Line 68: DELETE FROM JTF_TERR_RSC_ACCESS_ALL

64:
65: PROCEDURE Delete_Row( x_TERR_RSC_ACCESS_ID IN NUMBER
66: ) IS
67: BEGIN
68: DELETE FROM JTF_TERR_RSC_ACCESS_ALL
69: WHERE TERR_RSC_ACCESS_ID = x_TERR_RSC_ACCESS_ID;
70: If (SQL%NOTFOUND) then
71: RAISE NO_DATA_FOUND;
72: End If;

Line 91: Update JTF_TERR_RSC_ACCESS_ALL

87: x_TRANS_ACCESS_CODE IN VARCHAR2,
88: x_ORG_ID IN NUMBER
89: ) IS
90: BEGIN
91: Update JTF_TERR_RSC_ACCESS_ALL
92: SET
93: TERR_RSC_ACCESS_ID = decode( x_TERR_RSC_ACCESS_ID, FND_API.G_MISS_NUM,TERR_RSC_ACCESS_ID,x_TERR_RSC_ACCESS_ID),
94: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
95: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

Line 127: FROM JTF_TERR_RSC_ACCESS_ALL

123: x_ORG_ID IN NUMBER
124: ) IS
125: CURSOR C IS
126: SELECT *
127: FROM JTF_TERR_RSC_ACCESS_ALL
128: WHERE TERR_RSC_ACCESS_ID = x_TERR_RSC_ACCESS_ID
129: FOR UPDATE of TERR_RSC_ACCESS_ID NOWAIT;
130: Recinfo C%ROWTYPE;
131: BEGIN