APPS.JTF_SOURCES_PKG dependencies on JTF_SOURCES_ALL

Line 6: -- sp 07/12/02 - Modified the access from JTF_SOURCES to JTF_SOURCES_ALL

2: /* $Header: jtfvsrcb.pls 120.5 2006/03/28 18:21:01 achanda ship $ */
3: --
4: -- arpatel 06/25/01 - Added related_id columns (1-5) to insert/update/lock procedures
5: --
6: -- sp 07/12/02 - Modified the access from JTF_SOURCES to JTF_SOURCES_ALL
7: -- as the view definition of JTF_SOURCES has changeds
8: --
9:
10: PROCEDURE Insert_Row(

Line 39: CURSOR C IS SELECT rowid FROM JTF_SOURCES_ALL

35: X_DENORM_VALUE_TABLE_NAME IN VARCHAR2,
36: X_DENORM_DEA_VALUE_TABLE_NAME IN VARCHAR2,
37: x_ORG_ID IN NUMBER
38: ) IS
39: CURSOR C IS SELECT rowid FROM JTF_SOURCES_ALL
40: WHERE SOURCE_ID = x_SOURCE_ID;
41: CURSOR C2 IS SELECT JTF_SOURCES_s.nextval FROM sys.dual;
42: BEGIN
43: If (x_SOURCE_ID IS NULL) then

Line 48: INSERT INTO JTF_SOURCES_ALL(

44: OPEN C2;
45: FETCH C2 INTO x_SOURCE_ID;
46: CLOSE C2;
47: End If;
48: INSERT INTO JTF_SOURCES_ALL(
49: SOURCE_ID,
50: LAST_UPDATE_DATE,
51: LAST_UPDATED_BY,
52: CREATION_DATE,

Line 115: DELETE FROM JTF_SOURCES_ALL

111:
112: PROCEDURE Delete_Row( x_SOURCE_ID IN NUMBER
113: ) IS
114: BEGIN
115: DELETE FROM JTF_SOURCES_ALL
116: WHERE SOURCE_ID = x_SOURCE_ID;
117: If (SQL%NOTFOUND) then
118: RAISE NO_DATA_FOUND;
119: End If;

Line 147: Update JTF_SOURCES_ALL

143: x_RELATED_ID5 IN NUMBER,
144: x_ORG_ID IN NUMBER
145: ) IS
146: BEGIN
147: Update JTF_SOURCES_ALL
148: SET
149: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),
150: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
151: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

Line 202: FROM JTF_SOURCES_ALL

198: x_ORG_ID IN NUMBER
199: ) IS
200: CURSOR C IS
201: SELECT *
202: FROM JTF_SOURCES_ALL
203: WHERE rowid = x_Rowid
204: FOR UPDATE of SOURCE_ID NOWAIT;
205: Recinfo C%ROWTYPE;
206: BEGIN