APPS.AHL_WARRANTY_ENTL_PVT dependencies on AHL_WARRANTY_ENTITLEMENTS_S

Line 1123: SELECT AHL_WARRANTY_ENTITLEMENTS_S.NEXTVAL INTO p_x_warranty_entl_rec.warranty_entitlement_id FROM DUAL;

1119: RETURN;
1120: END IF;
1121:
1122: -- prepare for insert
1123: SELECT AHL_WARRANTY_ENTITLEMENTS_S.NEXTVAL INTO p_x_warranty_entl_rec.warranty_entitlement_id FROM DUAL;
1124: -- setting object version number for create
1125: p_x_warranty_entl_rec.object_version_number := 1;
1126: -- setting up user/create/update information
1127: p_x_warranty_entl_rec.created_by := FND_GLOBAL.USER_ID;

Line 1711: UPDATE AHL_WARRANTY_ENTITLEMENTS SET

1707: FND_LOG.string(l_log_statement, l_full_name, 'Before approval update');
1708: END IF;
1709:
1710: -- update the warranty contract id, old contract id and the status
1711: UPDATE AHL_WARRANTY_ENTITLEMENTS SET
1712: warranty_contract_id = l_contract_id,
1713: old_warranty_contract_id = l_contract_id,
1714: entitlement_status_code = l_entl_status
1715: WHERE warranty_entitlement_id = p_x_warranty_entl_rec.warranty_entitlement_id;