APPS.AHL_FMP_MR_ACTION_PVT dependencies on AHL_MR_ACTIONS_B

Line 314: FROM AHL_MR_ACTIONS_B

310: as
311: CURSOR get_ACTION_id(c_mr_action_id NUMBER)
312: IS
313: SELECT MR_ACTION_ID
314: FROM AHL_MR_ACTIONS_B
315: WHERE MR_ACTION_ID=c_mr_action_id;
316:
317: CURSOR GetMrDet(c_mr_header_id NUMBER )
318: IS

Line 329: FROM AHL_MR_ACTIONS_B

325:
326: CURSOR CHECK_DUP_ACTION_CODE(c_mr_action_code VARCHAR2,c_mr_header_id NUMBER)
327: IS
328: SELECT *
329: FROM AHL_MR_ACTIONS_B
330: WHERE MR_HEADER_ID=c_mr_header_id
331: and MR_ACTION_CODE=c_MR_ACTION_CODE;
332:
333: l_act_rec CHECK_DUP_ACTION_CODE%ROWTYPE;

Line 566: delete from AHL_MR_ACTIONS_B

562: then
563: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
564: FND_MSG_PUB.ADD;
565: else
566: delete from AHL_MR_ACTIONS_B
567: where MR_ACTION_ID = p_x_mr_ACTION_TBL(i).MR_ACTION_ID
568: AND OBJECT_VERSION_NUMBER=p_x_mr_ACTION_TBL(i).OBJECT_VERSION_NUMBER;
569:
570: if (sql%ROWCOUNT=0) then

Line 608: SELECT AHL_MR_ACTIONS_B_S.NEXTVAL

604: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
605: END IF;
606: ELSIF p_x_mr_ACTION_TBL(i).DML_operation='C' then
607:
608: SELECT AHL_MR_ACTIONS_B_S.NEXTVAL
609: INTO l_MR_ACTION_ID
610: FROM DUAL;
611: IF x_return_status=FND_API.G_RET_STS_SUCCESS
612: THEN