APPS.AHL_ITEM_ASSOCIATIONS_PKG dependencies on AHL_ITEM_ASSOCIATIONS_B

Line 40: cursor C is select ROWID from AHL_ITEM_ASSOCIATIONS_B

36: X_LAST_UPDATE_DATE in DATE,
37: X_LAST_UPDATED_BY in NUMBER,
38: X_LAST_UPDATE_LOGIN in NUMBER
39: ) is
40: cursor C is select ROWID from AHL_ITEM_ASSOCIATIONS_B
41: where ITEM_ASSOCIATION_ID = X_ITEM_ASSOCIATION_ID
42: ;
43: begin
44: insert into AHL_ITEM_ASSOCIATIONS_B (

Line 44: insert into AHL_ITEM_ASSOCIATIONS_B (

40: cursor C is select ROWID from AHL_ITEM_ASSOCIATIONS_B
41: where ITEM_ASSOCIATION_ID = X_ITEM_ASSOCIATION_ID
42: ;
43: begin
44: insert into AHL_ITEM_ASSOCIATIONS_B (
45: SOURCE_ITEM_ASSOCIATION_ID,
46: ITEM_ASSOCIATION_ID,
47: OBJECT_VERSION_NUMBER,
48: ITEM_GROUP_ID,

Line 211: from AHL_ITEM_ASSOCIATIONS_B

207: ATTRIBUTE12,
208: ATTRIBUTE13,
209: ATTRIBUTE14,
210: ATTRIBUTE15
211: from AHL_ITEM_ASSOCIATIONS_B
212: where ITEM_ASSOCIATION_ID = X_ITEM_ASSOCIATION_ID
213: for update of ITEM_ASSOCIATION_ID nowait;
214: recinfo c%rowtype;
215:

Line 338: update AHL_ITEM_ASSOCIATIONS_B set

334: X_LAST_UPDATED_BY in NUMBER,
335: X_LAST_UPDATE_LOGIN in NUMBER
336: ) is
337: begin
338: update AHL_ITEM_ASSOCIATIONS_B set
339: SOURCE_ITEM_ASSOCIATION_ID = X_SOURCE_ITEM_ASSOCIATION_ID,
340: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
341: ITEM_GROUP_ID = X_ITEM_GROUP_ID,
342: INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,

Line 400: delete from AHL_ITEM_ASSOCIATIONS_B

396: if (sql%notfound) then
397: raise no_data_found;
398: end if;
399:
400: delete from AHL_ITEM_ASSOCIATIONS_B
401: where ITEM_ASSOCIATION_ID = X_ITEM_ASSOCIATION_ID;
402:
403: if (sql%notfound) then
404: raise no_data_found;

Line 414: from AHL_ITEM_ASSOCIATIONS_B B

410: begin
411: delete from AHL_ITEM_ASSOCIATIONS_TL T
412: where not exists
413: (select NULL
414: from AHL_ITEM_ASSOCIATIONS_B B
415: where B.ITEM_ASSOCIATION_ID = T.ITEM_ASSOCIATION_ID
416: );
417:
418: update AHL_ITEM_ASSOCIATIONS_TL T set (