APPS.JTF_QUAL_TYPES_PKG dependencies on JTF_QUAL_TYPES_ALL

Line 26: CURSOR C IS SELECT rowid FROM JTF_QUAL_TYPES_ALL

22: x_RELATED_ID4 IN NUMBER,
23: x_RELATED_ID5 IN NUMBER,
24: x_ORG_ID IN NUMBER
25: ) IS
26: CURSOR C IS SELECT rowid FROM JTF_QUAL_TYPES_ALL
27: WHERE QUAL_TYPE_ID = x_QUAL_TYPE_ID;
28: CURSOR C2 IS SELECT JTF_QUAL_TYPES_s.nextval FROM sys.dual;
29: BEGIN
30: If (x_QUAL_TYPE_ID IS NULL) then

Line 35: INSERT INTO JTF_QUAL_TYPES_ALL(

31: OPEN C2;
32: FETCH C2 INTO x_QUAL_TYPE_ID;
33: CLOSE C2;
34: End If;
35: INSERT INTO JTF_QUAL_TYPES_ALL(
36: QUAL_TYPE_ID,
37: LAST_UPDATE_DATE,
38: LAST_UPDATED_BY,
39: CREATION_DATE,

Line 86: DELETE FROM JTF_QUAL_TYPES_ALL

82:
83: PROCEDURE Delete_Row( x_QUAL_TYPE_ID IN NUMBER
84: ) IS
85: BEGIN
86: DELETE FROM JTF_QUAL_TYPES_ALL
87: WHERE QUAL_TYPE_ID = x_QUAL_TYPE_ID;
88: If (SQL%NOTFOUND) then
89: RAISE NO_DATA_FOUND;
90: End If;

Line 117: Update JTF_QUAL_TYPES_ALL

113: x_RELATED_ID5 IN NUMBER,
114: x_ORG_ID IN NUMBER
115: ) IS
116: BEGIN
117: Update JTF_QUAL_TYPES_ALL
118: SET
119: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),
120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

Line 170: FROM JTF_QUAL_TYPES_ALL

166: x_ORG_ID IN NUMBER
167: ) IS
168: CURSOR C IS
169: SELECT *
170: FROM JTF_QUAL_TYPES_ALL
171: WHERE rowid = x_Rowid
172: FOR UPDATE of QUAL_TYPE_ID NOWAIT;
173: Recinfo C%ROWTYPE;
174: BEGIN