599: X_ATTRIBUTE13 =>p_x_mr_ACTION_TBL(i).ATTRIBUTE13,
600: X_ATTRIBUTE14 =>p_x_mr_ACTION_TBL(i).ATTRIBUTE14,
601: X_ATTRIBUTE15 =>p_x_mr_ACTION_TBL(i).ATTRIBUTE15,
602: X_LAST_UPDATE_DATE =>sysdate,
603: X_LAST_UPDATED_BY =>fnd_global.user_id,
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:
600: X_ATTRIBUTE14 =>p_x_mr_ACTION_TBL(i).ATTRIBUTE14,
601: X_ATTRIBUTE15 =>p_x_mr_ACTION_TBL(i).ATTRIBUTE15,
602: X_LAST_UPDATE_DATE =>sysdate,
603: X_LAST_UPDATED_BY =>fnd_global.user_id,
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
634: X_ATTRIBUTE13 =>p_x_mr_ACTION_TBL(i).ATTRIBUTE13,
635: X_ATTRIBUTE14 =>p_x_mr_ACTION_TBL(i).ATTRIBUTE14,
636: X_ATTRIBUTE15 =>p_x_mr_ACTION_TBL(i).ATTRIBUTE15,
637: X_CREATION_DATE =>sysdate,
638: X_CREATED_BY =>fnd_global.user_id,
639: X_LAST_UPDATE_DATE =>sysdate,
640: X_LAST_UPDATED_BY =>fnd_global.user_id,
641: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
642: END IF;
636: X_ATTRIBUTE15 =>p_x_mr_ACTION_TBL(i).ATTRIBUTE15,
637: X_CREATION_DATE =>sysdate,
638: X_CREATED_BY =>fnd_global.user_id,
639: X_LAST_UPDATE_DATE =>sysdate,
640: X_LAST_UPDATED_BY =>fnd_global.user_id,
641: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
642: END IF;
643: END IF;
644: END LOOP;
637: X_CREATION_DATE =>sysdate,
638: X_CREATED_BY =>fnd_global.user_id,
639: X_LAST_UPDATE_DATE =>sysdate,
640: X_LAST_UPDATED_BY =>fnd_global.user_id,
641: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
642: END IF;
643: END IF;
644: END LOOP;
645: