1581: CREATED_BY,
1582: LAST_UPDATE_LOGIN
1583: ) VALUES
1584: (
1585: AHL_MR_EFFECTIVITIES_S.NEXTVAL,
1586: p_x_effectivity_tbl(i).object_version_number,
1587: p_mr_header_id,
1588: p_x_effectivity_tbl(i).name,
1589: DECODE( p_x_effectivity_tbl(i).relationship_id, NULL,
1630: ELSIF ( p_x_effectivity_tbl(i).dml_operation = 'U' ) THEN
1631:
1632: BEGIN
1633: -- Update the record
1634: UPDATE AHL_MR_EFFECTIVITIES SET
1635: object_version_number = object_version_number + 1,
1636: name = p_x_effectivity_tbl(i).name,
1637: inventory_item_id = DECODE(
1638: p_x_effectivity_tbl(i).relationship_id,