APPS.ITA_SETUP_APPLICATION_EXT_PKG dependencies on ITA_SETUP_APPLICATION_EXT

Line 1: package body ITA_SETUP_APPLICATION_EXT_PKG as

1: package body ITA_SETUP_APPLICATION_EXT_PKG as
2: /* $Header: itatapxb.pls 120.0 2005/06/15 18:06:09 appldev noship $ */
3:
4:
5: procedure INSERT_ROW (

Line 17: insert into ITA_SETUP_APPLICATION_EXT (

13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: begin
17: insert into ITA_SETUP_APPLICATION_EXT (
18: APPLICATION_ID,
19: MIN_HIERARCHY_LEVEL,
20: SECURITY_GROUP_ID,
21: OBJECT_VERSION_NUMBER,

Line 51: from ITA_SETUP_APPLICATION_EXT

47: cursor c is select
48: MIN_HIERARCHY_LEVEL,
49: SECURITY_GROUP_ID,
50: OBJECT_VERSION_NUMBER
51: from ITA_SETUP_APPLICATION_EXT
52: where APPLICATION_ID = X_APPLICATION_ID
53: for update of APPLICATION_ID nowait;
54: recinfo c%rowtype;
55:

Line 93: update ITA_SETUP_APPLICATION_EXT set

89: X_LAST_UPDATED_BY in NUMBER,
90: X_LAST_UPDATE_LOGIN in NUMBER
91: ) is
92: begin
93: update ITA_SETUP_APPLICATION_EXT set
94: APPLICATION_ID = X_APPLICATION_ID,
95: MIN_HIERARCHY_LEVEL = X_MIN_HIERARCHY_LEVEL,
96: SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
97: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 113: delete from ITA_SETUP_APPLICATION_EXT

109: procedure DELETE_ROW (
110: X_APPLICATION_ID in NUMBER
111: ) is
112: begin
113: delete from ITA_SETUP_APPLICATION_EXT
114: where APPLICATION_ID = X_APPLICATION_ID;
115:
116: if (sql%notfound) then
117: raise no_data_found;

Line 143: from ITA_SETUP_APPLICATION_EXT

139: -- Translate char last_update_date to date
140: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
141:
142: select last_updated_by, last_update_date into db_luby, db_ludate
143: from ITA_SETUP_APPLICATION_EXT
144: where application_id = X_APPLICATION_ID;
145:
146: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
147: then ITA_SETUP_APPLICATION_EXT_PKG.UPDATE_ROW(

Line 147: then ITA_SETUP_APPLICATION_EXT_PKG.UPDATE_ROW(

143: from ITA_SETUP_APPLICATION_EXT
144: where application_id = X_APPLICATION_ID;
145:
146: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
147: then ITA_SETUP_APPLICATION_EXT_PKG.UPDATE_ROW(
148: X_APPLICATION_ID => X_APPLICATION_ID,
149: X_MIN_HIERARCHY_LEVEL => X_MIN_HIERARCHY_LEVEL,
150: X_SECURITY_GROUP_ID => null,
151: X_OBJECT_VERSION_NUMBER => 1,

Line 157: then ITA_SETUP_APPLICATION_EXT_PKG.INSERT_ROW(

153: X_LAST_UPDATED_BY => f_luby,
154: X_LAST_UPDATE_LOGIN => 0);
155: end if;
156: exception when NO_DATA_FOUND
157: then ITA_SETUP_APPLICATION_EXT_PKG.INSERT_ROW(
158: X_APPLICATION_ID => X_APPLICATION_ID,
159: X_MIN_HIERARCHY_LEVEL => X_MIN_HIERARCHY_LEVEL,
160: X_SECURITY_GROUP_ID => null,
161: X_OBJECT_VERSION_NUMBER => 1,

Line 170: end ITA_SETUP_APPLICATION_EXT_PKG;

166: X_LAST_UPDATE_LOGIN => 0);
167: end LOAD_ROW;
168:
169:
170: end ITA_SETUP_APPLICATION_EXT_PKG;