[Home] [Help]
3174: x_return_status => l_return_status,
3175: x_msg_count => l_msg_count,
3176: x_msg_data => l_msg_data);
3177:
3178: UPDATE AMW_CONTROL_ASSOCIATIONS SET
3179: LAST_UPDATE_DATE = sysdate,
3180: last_updated_by = fnd_global.user_id,
3181: last_update_login = fnd_global.conc_login_id,
3182: pk5 = l_opinion_log_id
5056: APPROVAL_DATE,
5057: DELETION_DATE,
5058: DELETION_APPROVAL_DATE,
5059: CONTROL_REV_ID)
5060: VALUES (AMW_CONTROL_ASSOCIATIONS_S.nextval,
5061: control_rec.control_id,
5062: p_certification_id,
5063: control_rec.PK1,
5064: control_rec.PK2,
5088: OPEN last_evaluation(control_rec.pk1, control_rec.control_id);
5089: FETCH last_evaluation INTO m_opinion_log_id;
5090: CLOSE last_evaluation;
5091:
5092: UPDATE AMW_CONTROL_ASSOCIATIONS SET
5093: LAST_UPDATE_DATE = sysdate,
5094: last_updated_by = fnd_global.user_id,
5095: last_update_login = fnd_global.conc_login_id,
5096: pk5 = m_opinion_log_id
10357: APPROVAL_DATE,
10358: DELETION_DATE,
10359: DELETION_APPROVAL_DATE,
10360: CONTROL_REV_ID)
10361: VALUES (AMW_CONTROL_ASSOCIATIONS_S.nextval,
10362: control_rec.control_id,
10363: p_certification_id,
10364: control_rec.PK1,
10365: control_rec.PK2,