DBA Data[Home] [Help]

APPS.AHL_RM_ASO_RESOURCE_PVT dependencies on AHL_RESOURCE_MAPPINGS_S

Line 1449: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,

1445: ATTRIBUTE14,
1446: ATTRIBUTE15
1447: ) VALUES
1448: (
1449: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,
1450: p_x_bom_resource_tbl(i).object_version_number,
1451: p_x_bom_resource_tbl(i).last_update_date,
1452: p_x_bom_resource_tbl(i).last_updated_by,
1453: p_x_bom_resource_tbl(i).creation_date,

Line 1546: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,

1542: ATTRIBUTE13,
1543: ATTRIBUTE14,
1544: ATTRIBUTE15)
1545: VALUES(
1546: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,
1547: p_x_bom_resource_tbl(i).object_version_number,
1548: p_x_bom_resource_tbl(i).last_update_date,
1549: p_x_bom_resource_tbl(i).last_updated_by,
1550: p_x_bom_resource_tbl(i).creation_date,

Line 1576: UPDATE AHL_RESOURCE_MAPPINGS SET

1572: p_x_bom_resource_tbl(i).attribute15)
1573: RETURNING resource_mapping_id INTO l_resource_mapping_id;
1574: p_x_bom_resource_tbl(i).resource_mapping_id := l_resource_mapping_id;
1575: ELSIF p_x_bom_resource_tbl(i).dml_operation = 'U' THEN
1576: UPDATE AHL_RESOURCE_MAPPINGS SET
1577: object_version_number = object_version_number + 1,
1578: last_update_date = p_x_bom_resource_tbl(i).last_update_date,
1579: last_updated_by = p_x_bom_resource_tbl(i).last_updated_by,
1580: last_update_login = p_x_bom_resource_tbl(i).last_update_login,