1049: ATTRIBUTE13 = p_x_mr_relation_tbl(i).ATTRIBUTE13,
1050: ATTRIBUTE14 = p_x_mr_relation_tbl(i).ATTRIBUTE14,
1051: ATTRIBUTE15 = p_x_mr_relation_tbl(i).ATTRIBUTE15,
1052: LAST_UPDATE_DATE = sysdate,
1053: LAST_UPDATED_BY = fnd_global.user_id,
1054: LAST_UPDATE_LOGIN = fnd_global.user_id
1055: where MR_RELATIONSHIP_ID = p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID
1056: and OBJECT_VERSION_NUMBER=p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER;
1057:
1050: ATTRIBUTE14 = p_x_mr_relation_tbl(i).ATTRIBUTE14,
1051: ATTRIBUTE15 = p_x_mr_relation_tbl(i).ATTRIBUTE15,
1052: LAST_UPDATE_DATE = sysdate,
1053: LAST_UPDATED_BY = fnd_global.user_id,
1054: LAST_UPDATE_LOGIN = fnd_global.user_id
1055: where MR_RELATIONSHIP_ID = p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID
1056: and OBJECT_VERSION_NUMBER=p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER;
1057:
1058: if sql%rowcount=0 then
1102: values(
1103: p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID,
1104: 1,
1105: sysdate,
1106: fnd_global.user_id,
1107: SYSDATE,
1108: fnd_global.user_id,
1109: fnd_global.user_id,
1110: p_x_mr_relation_tbl(i).MR_HEADER_ID,
1104: 1,
1105: sysdate,
1106: fnd_global.user_id,
1107: SYSDATE,
1108: fnd_global.user_id,
1109: fnd_global.user_id,
1110: p_x_mr_relation_tbl(i).MR_HEADER_ID,
1111: p_x_mr_relation_tbl(i).RELATED_MR_HEADER_ID,
1112: p_x_mr_relation_tbl(i).RELATIONSHIP_CODE,
1105: sysdate,
1106: fnd_global.user_id,
1107: SYSDATE,
1108: fnd_global.user_id,
1109: fnd_global.user_id,
1110: p_x_mr_relation_tbl(i).MR_HEADER_ID,
1111: p_x_mr_relation_tbl(i).RELATED_MR_HEADER_ID,
1112: p_x_mr_relation_tbl(i).RELATIONSHIP_CODE,
1113: p_x_mr_relation_tbl(i).ATTRIBUTE_CATEGORY,