APPS.JTF_TERR_USGS_PKG dependencies on JTF_TERR_USGS_ALL

Line 21: CURSOR C IS SELECT rowid FROM JTF_TERR_USGS_all

17: x_TERR_ID IN NUMBER,
18: x_SOURCE_ID IN NUMBER,
19: x_ORG_ID IN NUMBER
20: ) IS
21: CURSOR C IS SELECT rowid FROM JTF_TERR_USGS_all
22: WHERE TERR_USG_ID = x_TERR_USG_ID;
23: CURSOR C2 IS SELECT JTF_TERR_USGS_s.nextval FROM sys.dual;
24: BEGIN
25: If (x_TERR_USG_ID IS NULL) then

Line 30: INSERT INTO JTF_TERR_USGS_ALL(

26: OPEN C2;
27: FETCH C2 INTO x_TERR_USG_ID;
28: CLOSE C2;
29: End If;
30: INSERT INTO JTF_TERR_USGS_ALL(
31: TERR_USG_ID,
32: LAST_UPDATE_DATE,
33: LAST_UPDATED_BY,
34: CREATION_DATE,

Line 64: DELETE FROM JTF_TERR_USGS_ALL

60:
61: PROCEDURE Delete_Row( x_TERR_USG_ID IN NUMBER
62: ) IS
63: BEGIN
64: DELETE FROM JTF_TERR_USGS_ALL
65: WHERE TERR_USG_ID = x_TERR_USG_ID;
66: If (SQL%NOTFOUND) then
67: RAISE NO_DATA_FOUND;
68: End If;

Line 86: Update JTF_TERR_USGS_all

82: x_SOURCE_ID IN NUMBER,
83: x_ORG_ID IN NUMBER
84: ) IS
85: BEGIN
86: Update JTF_TERR_USGS_all
87: SET
88: TERR_USG_ID = decode( x_TERR_USG_ID, FND_API.G_MISS_NUM,TERR_USG_ID,x_TERR_USG_ID),
89: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
90: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

Line 120: FROM JTF_TERR_USGS_ALL

116: x_ORG_ID IN NUMBER
117: ) IS
118: CURSOR C IS
119: SELECT *
120: FROM JTF_TERR_USGS_ALL
121: WHERE TERR_USG_ID = x_TERR_USG_ID
122: FOR UPDATE of TERR_USG_ID NOWAIT;
123: Recinfo C%ROWTYPE;
124: BEGIN