APPS.AHL_ITEM_GROUPS_PKG dependencies on AHL_ITEM_GROUPS_B

Line 35: cursor C is select ROWID from AHL_ITEM_GROUPS_B

31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from AHL_ITEM_GROUPS_B
36: where ITEM_GROUP_ID = X_ITEM_GROUP_ID
37: ;
38: begin
39: insert into AHL_ITEM_GROUPS_B (

Line 39: insert into AHL_ITEM_GROUPS_B (

35: cursor C is select ROWID from AHL_ITEM_GROUPS_B
36: where ITEM_GROUP_ID = X_ITEM_GROUP_ID
37: ;
38: begin
39: insert into AHL_ITEM_GROUPS_B (
40: TYPE_CODE,
41: STATUS_CODE,
42: SOURCE_ITEM_GROUP_ID,
43: NAME,

Line 182: from AHL_ITEM_GROUPS_B

178: ATTRIBUTE13,
179: ATTRIBUTE14,
180: ATTRIBUTE15,
181: OBJECT_VERSION_NUMBER
182: from AHL_ITEM_GROUPS_B
183: where ITEM_GROUP_ID = X_ITEM_GROUP_ID
184: for update of ITEM_GROUP_ID nowait;
185: recinfo c%rowtype;
186:

Line 293: update AHL_ITEM_GROUPS_B set

289: X_LAST_UPDATED_BY in NUMBER,
290: X_LAST_UPDATE_LOGIN in NUMBER
291: ) is
292: begin
293: update AHL_ITEM_GROUPS_B set
294: TYPE_CODE = X_TYPE_CODE,
295: STATUS_CODE = X_STATUS_CODE,
296: SOURCE_ITEM_GROUP_ID = X_SOURCE_ITEM_GROUP_ID,
297: NAME = X_NAME,

Line 349: delete from AHL_ITEM_GROUPS_B

345: if (sql%notfound) then
346: raise no_data_found;
347: end if;
348:
349: delete from AHL_ITEM_GROUPS_B
350: where ITEM_GROUP_ID = X_ITEM_GROUP_ID;
351:
352: if (sql%notfound) then
353: raise no_data_found;

Line 363: from AHL_ITEM_GROUPS_B B

359: begin
360: delete from AHL_ITEM_GROUPS_TL T
361: where not exists
362: (select NULL
363: from AHL_ITEM_GROUPS_B B
364: where B.ITEM_GROUP_ID = T.ITEM_GROUP_ID
365: );
366:
367: update AHL_ITEM_GROUPS_TL T set (