APPS.AHL_MR_ACTIONS_PKG dependencies on AHL_MR_ACTIONS_B

Line 33: cursor C is select ROWID from AHL_MR_ACTIONS_B

29: X_LAST_UPDATE_DATE in DATE,
30: X_LAST_UPDATED_BY in NUMBER,
31: X_LAST_UPDATE_LOGIN in NUMBER
32: ) is
33: cursor C is select ROWID from AHL_MR_ACTIONS_B
34: where MR_ACTION_ID = X_MR_ACTION_ID
35: ;
36: begin
37: insert into AHL_MR_ACTIONS_B (

Line 37: insert into AHL_MR_ACTIONS_B (

33: cursor C is select ROWID from AHL_MR_ACTIONS_B
34: where MR_ACTION_ID = X_MR_ACTION_ID
35: ;
36: begin
37: insert into AHL_MR_ACTIONS_B (
38: MR_ACTION_ID,
39: OBJECT_VERSION_NUMBER,
40: MR_HEADER_ID,
41: MR_ACTION_CODE,

Line 159: update AHL_MR_ACTIONS_B set

155: X_LAST_UPDATED_BY in NUMBER,
156: X_LAST_UPDATE_LOGIN in NUMBER
157: ) is
158: begin
159: update AHL_MR_ACTIONS_B set
160: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1 ,
161: MR_HEADER_ID = X_MR_HEADER_ID,
162: MR_ACTION_CODE = X_MR_ACTION_CODE,
163: PLAN_ID = X_PLAN_ID,

Line 213: delete from AHL_MR_ACTIONS_B

209: if (sql%ROWCOUNT=0) then
210: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
211: FND_MSG_PUB.ADD;
212: else
213: delete from AHL_MR_ACTIONS_B
214: where MR_ACTION_ID = X_MR_ACTION_ID;
215: if (sql%ROWCOUNT=0) then
216: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
217: FND_MSG_PUB.ADD;

Line 233: from AHL_MR_ACTIONS_B B

229: begin
230: delete from AHL_MR_ACTIONS_TL T
231: where not exists
232: (select NULL
233: from AHL_MR_ACTIONS_B B
234: where B.MR_ACTION_ID = T.MR_ACTION_ID
235: );
236:
237: update AHL_MR_ACTIONS_TL T set (