DBA Data[Home] [Help]

APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on AHL_MR_EFFECTIVITIES_S

Line 1585: AHL_MR_EFFECTIVITIES_S.NEXTVAL,

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,

Line 1634: UPDATE AHL_MR_EFFECTIVITIES SET

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,