APPS.AHL_ITEM_ASSOCIATIONS_H_PKG dependencies on AHL_ITEM_ASSOCIATIONS_B_H

Line 43: cursor C is select ROWID from AHL_ITEM_ASSOCIATIONS_B_H

39: X_LAST_UPDATE_DATE in DATE,
40: X_LAST_UPDATED_BY in NUMBER,
41: X_LAST_UPDATE_LOGIN in NUMBER
42: ) is
43: cursor C is select ROWID from AHL_ITEM_ASSOCIATIONS_B_H
44: where ITEM_ASSOCIATION_H_ID = X_ITEM_ASSOCIATION_H_ID
45: ;
46: begin
47: insert into AHL_ITEM_ASSOCIATIONS_B_H (

Line 47: insert into AHL_ITEM_ASSOCIATIONS_B_H (

43: cursor C is select ROWID from AHL_ITEM_ASSOCIATIONS_B_H
44: where ITEM_ASSOCIATION_H_ID = X_ITEM_ASSOCIATION_H_ID
45: ;
46: begin
47: insert into AHL_ITEM_ASSOCIATIONS_B_H (
48: ITEM_ASSOCIATION_H_ID,
49: ITEM_ASSOCIATION_ID,
50: ITEM_GROUP_ID,
51: OBJECT_VERSION_NUMBER,

Line 226: from AHL_ITEM_ASSOCIATIONS_B_H

222: ATTRIBUTE12,
223: ATTRIBUTE13,
224: ATTRIBUTE14,
225: ATTRIBUTE15
226: from AHL_ITEM_ASSOCIATIONS_B_H
227: where ITEM_ASSOCIATION_H_ID = X_ITEM_ASSOCIATION_H_ID
228: for update of ITEM_ASSOCIATION_H_ID nowait;
229: recinfo c%rowtype;
230:

Line 360: update AHL_ITEM_ASSOCIATIONS_B_H set

356: X_LAST_UPDATED_BY in NUMBER,
357: X_LAST_UPDATE_LOGIN in NUMBER
358: ) is
359: begin
360: update AHL_ITEM_ASSOCIATIONS_B_H set
361: ITEM_ASSOCIATION_ID = X_ITEM_ASSOCIATION_ID,
362: ITEM_GROUP_ID = X_ITEM_GROUP_ID,
363: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
364: INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,

Line 425: delete from AHL_ITEM_ASSOCIATIONS_B_H

421: if (sql%notfound) then
422: raise no_data_found;
423: end if;
424:
425: delete from AHL_ITEM_ASSOCIATIONS_B_H
426: where ITEM_ASSOCIATION_H_ID = X_ITEM_ASSOCIATION_H_ID;
427:
428: if (sql%notfound) then
429: raise no_data_found;

Line 439: from AHL_ITEM_ASSOCIATIONS_B_H B

435: begin
436: delete from AHL_ITEM_ASSOCIATIONS_TL_H T
437: where not exists
438: (select NULL
439: from AHL_ITEM_ASSOCIATIONS_B_H B
440: where B.ITEM_ASSOCIATION_H_ID = T.ITEM_ASSOCIATION_H_ID
441: );
442:
443: update AHL_ITEM_ASSOCIATIONS_TL_H T set (