APPS.JTF_SEEDED_QUAL_PKG dependencies on JTF_SEEDED_QUAL_ALL_B

Line 7: -- vnedunga 05/16/00 Fixing UPdate_Row/Delete row use JTF_SEEDED_QUAL_ALL_B

3:
4: -- eihsu 10/06/1999 adding procedures for MLS support
5: -- vnedunga 05/11/00 fixing the translate row as part of
6: -- MLS verification
7: -- vnedunga 05/16/00 Fixing UPdate_Row/Delete row use JTF_SEEDED_QUAL_ALL_B
8: -- instead of JTF_SEEDED_QUAL
9: -- jdochert 08/17/00 1331579 bug fix =>
10: -- Replaced: AND org_id = x_org_id
11: -- With: and NVL(ORG_ID, -99) = NVL(x_ORG_ID, -99)

Line 26: CURSOR C IS SELECT rowid FROM JTF_SEEDED_QUAL_ALL_B

22: x_NAME IN VARCHAR2,
23: x_DESCRIPTION IN VARCHAR2,
24: x_ORG_ID IN NUMBER
25: ) IS
26: CURSOR C IS SELECT rowid FROM JTF_SEEDED_QUAL_ALL_B
27: WHERE SEEDED_QUAL_ID = x_SEEDED_QUAL_ID and NVL(ORG_ID, -99) = NVL(x_ORG_ID, -99);
28: CURSOR C2 IS SELECT JTF_SEEDED_QUAL_s.nextval FROM sys.dual;
29: BEGIN
30: If (x_SEEDED_QUAL_ID IS NULL) then

Line 35: INSERT INTO JTF_SEEDED_QUAL_ALL_B(

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

Line 109: DELETE FROM JTF_SEEDED_QUAL_ALL_B

105: if (sql%notfound) then
106: raise no_data_found;
107: end if;
108:
109: DELETE FROM JTF_SEEDED_QUAL_ALL_B
110: WHERE SEEDED_QUAL_ID = x_SEEDED_QUAL_ID;
111: If (SQL%NOTFOUND) then
112: RAISE NO_DATA_FOUND;
113: End If;

Line 131: Update JTF_SEEDED_QUAL_ALL_B

127: x_DESCRIPTION IN VARCHAR2,
128: x_ORG_ID IN NUMBER
129: ) IS
130: BEGIN
131: Update JTF_SEEDED_QUAL_ALL_B
132: SET SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
133: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
134: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
135: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),

Line 256: from JTF_SEEDED_QUAL_ALL_B B

252: begin
253: delete from JTF_SEEDED_QUAL_ALL_TL T
254: where not exists
255: (select NULL
256: from JTF_SEEDED_QUAL_ALL_B B
257: where B.SEEDED_QUAL_ID = T.SEEDED_QUAL_ID
258: and NVL(B.ORG_ID,-99) = NVL(T.ORG_ID,-99) /* 1331579 BUG FIX */
259: );
260:

Line 346: UPDATE JTF_SEEDED_QUAL_ALL_B SET

342: ELSE
343: user_id := 0;
344: END IF;
345: -- Load The record to _B table
346: UPDATE JTF_SEEDED_QUAL_ALL_B SET
347: name = x_name,
348: description = x_description,
349: last_update_date = sysdate,
350: last_updated_by = user_id,

Line 356: INSERT INTO JTF_SEEDED_QUAL_ALL_B

352: WHERE SEEDED_QUAL_ID = x_SEEDED_QUAL_ID;
353:
354: IF (SQL%NOTFOUND) THEN
355: -- Insert new record to _B table
356: INSERT INTO JTF_SEEDED_QUAL_ALL_B
357: (SEEDED_QUAL_ID,
358: name,
359: description,
360: creation_date,