APPS.IEU_SH_ACT_TYPES_PKG dependencies on IEU_SH_ACT_TYPES_B

Line 18: cursor C is select ROWID from IEU_SH_ACT_TYPES_B

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from IEU_SH_ACT_TYPES_B
19: where ACTIVITY_TYPE_ID = X_ACTIVITY_TYPE_ID
20: ;
21: begin
22: insert into IEU_SH_ACT_TYPES_B (

Line 22: insert into IEU_SH_ACT_TYPES_B (

18: cursor C is select ROWID from IEU_SH_ACT_TYPES_B
19: where ACTIVITY_TYPE_ID = X_ACTIVITY_TYPE_ID
20: ;
21: begin
22: insert into IEU_SH_ACT_TYPES_B (
23: ACTIVITY_TYPE_ID,
24: OBJECT_VERSION_NUMBER,
25: ACTIVITY_TYPE_CODE,
26: APPLICATION_ID,

Line 100: from IEU_SH_ACT_TYPES_B

96: cursor c is select
97: OBJECT_VERSION_NUMBER,
98: ACTIVITY_TYPE_CODE,
99: APPLICATION_ID
100: from IEU_SH_ACT_TYPES_B
101: where ACTIVITY_TYPE_ID = X_ACTIVITY_TYPE_ID
102: for update of ACTIVITY_TYPE_ID nowait;
103: recinfo c%rowtype;
104:

Line 159: update IEU_SH_ACT_TYPES_B set

155: X_LAST_UPDATED_BY in NUMBER,
156: X_LAST_UPDATE_LOGIN in NUMBER
157: ) is
158: begin
159: update IEU_SH_ACT_TYPES_B set
160: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
161: ACTIVITY_TYPE_CODE = X_ACTIVITY_TYPE_CODE,
162: APPLICATION_ID = X_APPLICATION_ID,
163: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 198: delete from IEU_SH_ACT_TYPES_B

194: if (sql%notfound) then
195: raise no_data_found;
196: end if;
197:
198: delete from IEU_SH_ACT_TYPES_B
199: where ACTIVITY_TYPE_ID = X_ACTIVITY_TYPE_ID;
200:
201: if (sql%notfound) then
202: raise no_data_found;

Line 212: from IEU_SH_ACT_TYPES_B B

208: begin
209: delete from IEU_SH_ACT_TYPES_TL T
210: where not exists
211: (select NULL
212: from IEU_SH_ACT_TYPES_B B
213: where B.ACTIVITY_TYPE_ID = T.ACTIVITY_TYPE_ID
214: );
215:
216: update IEU_SH_ACT_TYPES_TL T set (