APPS.JTF_TERR_QTYPE_USGS_PKG dependencies on JTF_TERR_QTYPE_USGS_ALL

Line 20: CURSOR C IS SELECT rowid FROM JTF_TERR_QTYPE_USGS_all

16: x_TERR_ID IN NUMBER,
17: x_QUAL_TYPE_USG_ID IN NUMBER,
18: x_ORG_ID IN NUMBER
19: ) IS
20: CURSOR C IS SELECT rowid FROM JTF_TERR_QTYPE_USGS_all
21: WHERE TERR_QTYPE_USG_ID = x_TERR_QTYPE_USG_ID;
22: CURSOR C2 IS SELECT JTF_TERR_QTYPE_USGS_s.nextval FROM sys.dual;
23: BEGIN
24: If (x_TERR_QTYPE_USG_ID IS NULL) then

Line 29: INSERT INTO JTF_TERR_QTYPE_USGS_ALL(

25: OPEN C2;
26: FETCH C2 INTO x_TERR_QTYPE_USG_ID;
27: CLOSE C2;
28: End If;
29: INSERT INTO JTF_TERR_QTYPE_USGS_ALL(
30: TERR_QTYPE_USG_ID,
31: LAST_UPDATED_BY,
32: LAST_UPDATE_DATE,
33: CREATED_BY,

Line 62: DELETE FROM JTF_TERR_QTYPE_USGS_ALL

58:
59: PROCEDURE Delete_Row( x_TERR_QTYPE_USG_ID IN NUMBER
60: ) IS
61: BEGIN
62: DELETE FROM JTF_TERR_QTYPE_USGS_ALL
63: WHERE TERR_QTYPE_USG_ID = x_TERR_QTYPE_USG_ID;
64: If (SQL%NOTFOUND) then
65: RAISE NO_DATA_FOUND;
66: End If;

Line 84: Update JTF_TERR_QTYPE_USGS_all

80: x_QUAL_TYPE_USG_ID IN NUMBER,
81: x_ORG_ID IN NUMBER
82: ) IS
83: BEGIN
84: Update JTF_TERR_QTYPE_USGS_all
85: SET
86: TERR_QTYPE_USG_ID = decode( x_TERR_QTYPE_USG_ID, FND_API.G_MISS_NUM,TERR_QTYPE_USG_ID,x_TERR_QTYPE_USG_ID),
87: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
88: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),

Line 118: FROM JTF_TERR_QTYPE_USGS_ALL

114: x_ORG_ID IN NUMBER
115: ) IS
116: CURSOR C IS
117: SELECT *
118: FROM JTF_TERR_QTYPE_USGS_ALL
119: WHERE TERR_QTYPE_USG_ID = x_TERR_QTYPE_USG_ID
120: FOR UPDATE of TERR_QTYPE_USG_ID NOWAIT;
121: Recinfo C%ROWTYPE;
122: BEGIN