DBA Data[Home] [Help]

APPS.AHL_RM_ASO_RESOURCE_PVT dependencies on AHL_RESOURCE_MAPPINGS_S

Line 1532: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,

1528: ATTRIBUTE14,
1529: ATTRIBUTE15
1530: ) VALUES
1531: (
1532: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,
1533: p_x_bom_resource_tbl(i).object_version_number,
1534: p_x_bom_resource_tbl(i).last_update_date,
1535: p_x_bom_resource_tbl(i).last_updated_by,
1536: p_x_bom_resource_tbl(i).creation_date,

Line 1629: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,

1625: ATTRIBUTE13,
1626: ATTRIBUTE14,
1627: ATTRIBUTE15)
1628: VALUES(
1629: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,
1630: p_x_bom_resource_tbl(i).object_version_number,
1631: p_x_bom_resource_tbl(i).last_update_date,
1632: p_x_bom_resource_tbl(i).last_updated_by,
1633: p_x_bom_resource_tbl(i).creation_date,

Line 1659: UPDATE AHL_RESOURCE_MAPPINGS SET

1655: p_x_bom_resource_tbl(i).attribute15)
1656: RETURNING resource_mapping_id INTO l_resource_mapping_id;
1657: p_x_bom_resource_tbl(i).resource_mapping_id := l_resource_mapping_id;
1658: ELSIF p_x_bom_resource_tbl(i).dml_operation = 'U' THEN
1659: UPDATE AHL_RESOURCE_MAPPINGS SET
1660: object_version_number = object_version_number + 1,
1661: last_update_date = p_x_bom_resource_tbl(i).last_update_date,
1662: last_updated_by = p_x_bom_resource_tbl(i).last_updated_by,
1663: last_update_login = p_x_bom_resource_tbl(i).last_update_login,