APPS.JTF_OBJECTS_MAPPING_PKG dependencies on JTF_OBJECT_MAPPINGS

Line 33: cursor C is select ROWID from JTF_OBJECT_MAPPINGS

29: X_CREATED_BY in NUMBER,
30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER ) is
33: cursor C is select ROWID from JTF_OBJECT_MAPPINGS
34: where MAPPING_ID = X_MAPPING_ID
35: ;
36: begin
37: insert into JTF_OBJECT_MAPPINGS(

Line 37: insert into JTF_OBJECT_MAPPINGS(

33: cursor C is select ROWID from JTF_OBJECT_MAPPINGS
34: where MAPPING_ID = X_MAPPING_ID
35: ;
36: begin
37: insert into JTF_OBJECT_MAPPINGS(
38: MAPPING_ID,
39: APPLICATION_ID ,
40: SOURCE_OBJECT_CODE ,
41: OBJECT_CODE ,

Line 115: from JTF_OBJECT_MAPPINGS_V

111: X_OBJECT_VERSION_NUMBER in NUMBER
112: ) is
113: cursor c is select
114: OBJECT_VERSION_NUMBER
115: from JTF_OBJECT_MAPPINGS_V
116: where MAPPING_ID = X_MAPPING_ID
117: and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
118: for update of MAPPING_ID nowait;
119: recinfo c%rowtype;

Line 176: update JTF_OBJECT_MAPPINGS set

172: X_LAST_UPDATE_LOGIN in NUMBER,
173: X_OBJECT_VERSION_NUMBER in NUMBER)
174: is
175: begin
176: update JTF_OBJECT_MAPPINGS set
177: APPLICATION_ID = X_APPLICATION_ID ,
178: SOURCE_OBJECT_CODE = X_SOURCE_OBJECT_CODE,
179: OBJECT_CODE = X_OBJECT_CODE,
180: OBJECT_ID=X_OBJECT_ID ,

Line 218: delete from JTF_OBJECT_MAPPINGS

214: procedure DELETE_ROW (
215: X_MAPPING_ID in NUMBER
216: ) is
217: begin
218: delete from JTF_OBJECT_MAPPINGS
219: where MAPPING_ID = X_MAPPING_ID;
220:
221: if (sql%notfound) then
222: raise no_data_found;