APPS.JTF_TERR_QUAL_PKG dependencies on JTF_TERR_QUAL_ALL

Line 32: CURSOR C IS SELECT rowid FROM JTF_TERR_QUAL_ALL

28: x_OVERLAP_ALLOWED_FLAG IN VARCHAR2,
29: x_QUALIFIER_MODE IN VARCHAR2,
30: x_ORG_ID IN NUMBER
31: ) IS
32: CURSOR C IS SELECT rowid FROM JTF_TERR_QUAL_ALL
33: WHERE TERR_QUAL_ID = x_TERR_QUAL_ID;
34: CURSOR C2 IS SELECT JTF_TERR_QUAL_s.nextval FROM sys.dual;
35: BEGIN
36: If (x_TERR_QUAL_ID IS NULL) then

Line 41: INSERT INTO JTF_TERR_QUAL_ALL(

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

Line 82: DELETE FROM JTF_TERR_QUAL_ALL

78:
79: PROCEDURE Delete_Row(x_TERR_QUAL_ID IN NUMBER
80: ) IS
81: BEGIN
82: DELETE FROM JTF_TERR_QUAL_ALL
83: WHERE TERR_QUAL_ID = x_TERR_QUAL_ID;
84: If (SQL%NOTFOUND) then
85: RAISE NO_DATA_FOUND;
86: End If;

Line 108: Update JTF_TERR_QUAL_ALL

104: x_QUALIFIER_MODE IN VARCHAR2,
105: x_ORG_ID IN NUMBER
106: ) IS
107: BEGIN
108: Update JTF_TERR_QUAL_ALL
109: SET
110: TERR_QUAL_ID = decode( x_TERR_QUAL_ID, FND_API.G_MISS_NUM,TERR_QUAL_ID,x_TERR_QUAL_ID),
111: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
112: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

Line 150: FROM JTF_TERR_QUAL_ALL

146: x_ORG_ID IN NUMBER
147: ) IS
148: CURSOR C IS
149: SELECT *
150: FROM JTF_TERR_QUAL_ALL
151: WHERE TERR_QUAL_ID = x_TERR_QUAL_ID
152: FOR UPDATE of TERR_QUAL_ID NOWAIT;
153: Recinfo C%ROWTYPE;
154: BEGIN