DBA Data[Home] [Help]

APPS.AHL_MR_HEADERS_PKG dependencies on AHL_MR_HEADERS_B

Line 62: insert into AHL_MR_HEADERS_B (

58: X_LAST_UPDATED_BY in NUMBER,
59: X_LAST_UPDATE_LOGIN in NUMBER
60: ) is
61: begin
62: insert into AHL_MR_HEADERS_B (
63: ATTRIBUTE11,
64: ATTRIBUTE12,
65: ATTRIBUTE13,
66: ATTRIBUTE14,

Line 124: AHL_MR_HEADERS_B_S.NEXTVAL,

120: X_ATTRIBUTE12,
121: X_ATTRIBUTE13,
122: X_ATTRIBUTE14,
123: X_ATTRIBUTE15,
124: AHL_MR_HEADERS_B_S.NEXTVAL,
125: X_OBJECT_VERSION_NUMBER,
126: X_TITLE,
127: X_VERSION_NUMBER,
128: X_ATTRIBUTE4,

Line 266: update AHL_MR_HEADERS_B set

262: X_LAST_UPDATED_BY in NUMBER,
263: X_LAST_UPDATE_LOGIN in NUMBER
264: ) is
265: begin
266: update AHL_MR_HEADERS_B set
267: ATTRIBUTE11 = X_ATTRIBUTE11,
268: ATTRIBUTE12 = X_ATTRIBUTE12,
269: ATTRIBUTE13 = X_ATTRIBUTE13,
270: ATTRIBUTE14 = X_ATTRIBUTE14,

Line 343: delete from AHL_MR_HEADERS_B

339: begin
340: delete from AHL_MR_HEADERS_TL
341: where MR_HEADER_ID = X_MR_HEADER_ID;
342:
343: delete from AHL_MR_HEADERS_B
344: where MR_HEADER_ID = X_MR_HEADER_ID;
345: end DELETE_ROW;
346:
347: procedure ADD_LANGUAGE

Line 353: from AHL_MR_HEADERS_B B

349: begin
350: delete from AHL_MR_HEADERS_TL T
351: where not exists
352: (select NULL
353: from AHL_MR_HEADERS_B B
354: where B.MR_HEADER_ID = T.MR_HEADER_ID
355: );
356:
357: update AHL_MR_HEADERS_TL T set (